BI Automation Framework Samples

[TJe]

The Automation Framework is delivered with content that allows customers to easily build, manage and run Scenarios.

• Task Templates
  Logon, Logout, Refresh Documents, Change Web Intelligence Source, Add/Remove User & User Groups, Query Worklist and more


• Workflow Templates
  Logical groups of task templates

In addition the Automation Framework supports the development of Custom Task Templates (see development tutorial) to extend the functionality and build tailored scenarios.

Samples available on GitHub

To illustrate advanced Automation Framework use cases, we have created sample content for you, available on the GitHub - SAP Samples: https://github.com/SAP-samples/boe-custom-task-template

• Explore - the samples from various areas and find more helpful details


• Learn - how Custom Task Templates can be used and developed


• Try it - deploy and run the sample scenarios on your BI platform

Get excited about the Automation Framework capabilities and inspired to build your own customized solution to simplify operations of your BI platform.

Updates

• 2020-05
  Task Template: Get WebIntelligence Worklist - Get the values of a report table as CSV worklist, which can be used as input parameters for another Task Template

 

Click the Follow button to stay notified when new information or samples are published.

[Paul1202]

Good potential, this Automation Framework. But SAP should make it first usable through https . See  https://launchpad.support.sap.com/#/notes/2842404 .

This SAP-note came after we had logged an incident that it is not working with https.

[TJe]

Valid feedback, it is planned to be solved in BI 4.3, which is not possible with current architecture in BI 4.2.
The Automation Framework can be used with https, the limitation is only for Task Templates which are using the RESTFul API (currently only WebI change source).

regards
Thomas

[Paul1202]

Thanks Thomas for your reply. And indeed , for Task Templates (RESTFul API) we wanted it to use, to change , on several hundreds of WEBI-Docs, the universe from .unv to .unx version. And we found that it indeed does not work.

[TJe]

Based on your feedback, I have tested on BI 4.2 SP07 and here https is working out of the box. We are currently validating a solution for SP05 & SP06 also.

[christian_key2]

Hi,

I want to convert Web Intelligence source from UNX to UNX. The documentation for the universe mapping CSV says:

CSV format (for UNX-UNX): src_cuid,dest_cuid,type

What value do I use for 'type' please as this is not documented?

Thanks,

Christian

[TJe]

possible values for type are: unv-unx, unx-bex

Seems this type is especially important for mapping to BEX Query as you have to specify the additional parameter technical_name.
It doesn't check if the specified object ID/CUID is a unv or a unx.
In other words, for unx to unx you still have to specify unv-unx.

hope this helps,

regards
Thomas

[TJe]

working with universe you don’t need the type. Just use:

• unv_id, unx_id
• unv_cuid, unx_cuid

[saaidia]

Hello,

Please i need details about "Documents Worklist" and "UniverseMapping Worklist" parameters for the standard workflow "change source " is it a csv file or txt file, version of BO is 4.2 SP9.

Thank you.

Best regards.

[ghassanzghaib]

Hi Riadh,

In my case BI42. SP8 I specified a csv file:

Documents Worklist

Cuid

AdjPmTqhJHpCkZnX4wsJmvw

Ae_bpUdz2K1FgBlgWuVLbvQ

AfxF_hw_HpFHlYEIs7nEJx0

ASBQk10ApG5Eo84sa0HRrdk

AV3G0dGaJZVBntWhzcs.daI

 

UniverseMapping Worklist

unv_cuid,unx_cuid

M0Wvo7sAAD8PAA8QBAAATU4AAqwaBSsAAAA,ATw.d1hto69BlJ7MG60Z3y8

 

Both files return "Success" in my scenario but don't seem to be taken into consideration in "Change Web intelligence Sources" workflow wich "Fails".

Have you been able to run a successful "Change Web intelligence Sources" workflow?

 

[former_member190781]

I would like to try this for Webi unv>unx migration, Is it possible to attach it with the KBA 2906634 or any other KBA as github is restricted in my organization network.

Thanks