july 2016.

Analysis for Office provides own Microsoft Excel formulas to show information of your data source. I want to explain some functions and how to use them in a dashboard or a report.

• SAPGetVariable
• SAPGetMember
• SAPGetInfoLabel
• SAPGetSourceInfo
• SAPGetWorkbookInfo
• SAPGetDimensionInfo
• SAPListOF
• SAPListOfDimensions
• SAPListOfEffectiveFilters
• SAPListOfDynamicFilters
• SAPSetFilterComponent

The function SAPGetVariable returns the value for a specific SAP Business Warehouse variable. For example:

Sometimes Design Studio crashes during start after installation of a new version. I found two threads in the SCN. The simple solution is to uninstall Design Studio, rename the following folder:

• C:\Users\<user>\Analysis-config
• C:\Users\<user>\Analysis-workspace

and reinstall Design Studio again. Maybe sometimes it is enough to rename only the folders. More Design Studio troubleshooting can be find in the Design Studio Wiki.

A feature of Bex Analyzer was the upload of selections, so you haven't to type the selections all the time. This feature wasn't available for Analysis for Office until version 2.2 SP3. So I looked deeper in this function and want to share my knowledge.

Analysis for Office has different two kinds of variants. One is a workbook variant and the other is a DataSource variant. So what is exactly the difference?

If you have a workbook you can save your variants in the prompt dialog.