Exel with SAP add-in "Analysis for Microsoft Excel" wont open

[Schlosser_Tobias]

Hello there,

i have an issue if i will open a .xlsm file which has a included add-in from SAP and a db connection. In this file i have predefined a report on a db. the file should update my report with the corrent status from the db by opening the file. I have built a bot that should open this file and read the range of the updated report. I built it with the “Use Excel File” activity. When i run the bot, it opens the file but without the SAP add-in and the file cannot update the report to the current version.

Can anyone give me some hints or ideas how i can manage this?

Thank you

[Riyas.Muhammed (Muhammed Riyas)]

SAP Analysis for Excel use

Normally we use “Excel Application Scope” activity to run the VBA, but Analysis & Analysis Design tabs will not be available while we are using “Excel application Scope” activity. To use Analysis tab and run any VBA codes with SAP Analysis in the excel, use “Open Application” activity to open blank excel workbook then brows the excel file. Once the file is opened, use “Excel Application Scope” activity and open the same excel file. Now we can see the Analysis & Analysis Design tabs. [image] […

[patla8640]

Is it truly a 4 level-based (balanced) hierarchy or is it a parent-child (ragged) hierarchy? If it’s level-based, your BW developers may be able to change each level into a dimension so that you can pull all 4 in as individual columns.

[patla8640]

Can anyone give me some hints or ideas how i can manage this?

Spotiflyer

[Kishore_Kannaa]

Initially using the start process activity, open the macro workbook. It will automatically close. Then use a delay activity. Followed by use the excel application scope to open the same macro workbook. Now you can see the analysis tab enabled.

Thanks