july 2016.

Analysis Office Infofields, formulas & Dashboard functions

Analysis Office provides own Microsoft Excel formulas to show information of your data source. I want to explain some of the 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 BW variable. For example:

Read More 0 Comments

Design Studio crashes during start

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.

Read More 2 Comments

Analysis Office Filter Data by Member

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 Office until version 2.2 SP3. So I looked deeper in this function and want to share my knowledge.

Read More 4 Comments

Analysis Office Workbook vs. DataSource Variants

Analysis 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.

Read More 0 Comments