december 2017.

Analysis Office Filter by Member Attribute

Crosstab before Filter by Member Attribute
Crosstab before Filter by Member Attribute
Read More 2 Comments

SAP BW: Keyfigure to Account Model

In my current project we have a lots of source systems which delivers our data in a key figure model. In a normal case is this not a problem. But we need the values of the key figures in a hierarchy. So there are two ways to realize it. First way would be we build a structure with restricted key figures and get our hierarchy. Here is the problem, the customer will need different queries to realize his needs. If there is a change, we need to adjust different queries (each has a light different hierarchy) and the maintainace is immense.

Read More 5 Comments

Analysis Office 2.6 is available

As you might know, Analysis Office 2.6 is available now. To download it, you need a S-User with download credentials. First SAP BusinessObjects Analysis for Microsoft Office is now called, SAP Analysis for Microsoft Office. Damn I have to rewrite my book, just kidding. Here is a short overview of What's new in Analysis Office 2.6:

  • You can now copy a Table Design formula by using Microsoft Excel Fill Handling
  • The formula SAPSetFilterComponent has a new selection type MEMBERSSELECTOR.
  • The API Command NumberOfNewLines can now set the number of new lines for a crosstab
  • According to Matthew Shaw you can now connect to/report on SAP Analytics Cloud.

So I just downloaded Analysis Office 2.6 and maybe I can write a little bit more in the next days.

Read More 0 Comments