december 2017.

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.

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.