Posts tagged with "analysisoffice"



13. January 2019
It is done, the newest edtion of Analysis Office - The Comprehensive Guide is available. It took me this time a little bit longer to update it. There are several reasons like my project workload or the the private stuff which make it sometimes difficult to write on a book and tests functions in peace without noise. You can now find it in the store and here is the table of content. It covers Analysis Office 2.7 SP3 and contains 299 Pages. It is only available as PDF but it is as always DRM free....
03. January 2019
Since the 21.12.2018 the latest service pack of Analysis Office 2.7 is available. I looked in the morning into the Support Portal but it wasn't released and in the afternoon Patrick wrote on Twitter, that Analysis Office 2.7 SP3 is released. I thought it wouldn't released anymore in 2018 but here are the fixed problems: New Options in Excel Single Workbook Publication (s-note 2729417) Bad Performance when switching presentations in Member Selector (s-note 2731997) Excel 2010 - "Not enough...
22. November 2018
I received an email from Jean-Pierre, who tried the new function Data Source for Defining Formulas of Analysis Office 2.7 - but it didn't work as he mentioned in his email. The option Select Data Soure for Defining Formulas was gray out for BEx Queries. It worked when he insert the Multiprovider or the Composite Provider. So I was very confused and tried to find a solution.
06. November 2018
It is a little late for Analysis Office 2.7 SP2 but SAP just delivered Patch 1 so I can write a short note about it. Finaly SAP give you the option to Create a Web Application in Lumira Designer. But if you installed SAP Design Studio an SAP Lumira Designer, it always opens Design Studio. Analysis Office doesn't care if you first install Lumira or Design Studio. Design Studio always wins. At the moment there is no setting like the DefaultBWQueryDesigner for the old BEx Query Designer or the new...
25. October 2018
It's been a while since the last blog post and I am also late for the news that Analysis Office 2.7 SP2 is available. As Patrick told me on 05.10.2018 Analysis Office 2.7 SP2 is GA. But I was on vaction so I didn't find the time to write about it. So here we are: This is fixed in Service Pack 2 'Value cannot be null.' exception in Formula Optimized mode (s-note 2695717) AO 2.7 Reference to another Sheet causes an Error in AO (s-note 2694323) Analysis Office: SSO not working for Olap connections...
07. August 2018
Since last week Analysis Office 2.7 SP1 is available. Here is a short overview what SAP fixed in this verison. Advanced calculation initially not visible (s-note 2663436) Analysis Office: No connections displayed after login to BIP server (s-note 2667319) Analysis Office: RFC sessions not closed after workbook is closed (s-note 2669330) Analysis Office: data sources contained in workbooks which are deleted on BW server are still visible (s-note 2664623) Error at undo operation of show / hide...
31. July 2018
Since Analysis Office 2.6 you are able to launch workbooks from BIP with variables. The biggest problem is to have a BI Platform 4.2 SP5 and time to test this feature. In case of writing an updated version of Analysis Office - The Comprehensive Guide, I now have a BI Platform which fulfilled the conditions. According to SAP slides, the command looks like this:
16. July 2018
Analysis Office Components tab - Use Data Source Formula-Optimized
A new function in Analysis Office 2.7 is "Select Data Source for Defining Formulas". But what does this mean? First the prerequisites: BW/4HANA SP8 and apply the following notes: 2624495 and 2600508 BW 7.50 SP12 (or >= SP8 and apply the following notes: 2579842, 2627315, 2624495 and 2600508) So I just logged into my BW 7.50 test system and what I have to see, we only have a BW 7.5 SP11. So I have applied the notes and each note need further notes to implemented. I just want to test something...
14. June 2018
Today Analysis Office 2.7 was released. Thanks to Zisi1990, who pointed me seconds after it was released that it is available. You can download it with a S-User. Here is a short overview what's new in Analysis Office 2.7: You now have to two ribbon tabs. One for the analysis and one for design There is a new formula called SAPSelectMember. The formula returns a member of a dimension, this might be interressting for VBA. You can now save comments to BW/4HANA. The history of these comments is...
28. May 2018
After a short vacation over Pentecost I have now time to write "What's new in Analysis Office 2.6 SP3". A short overview yo find in this post. The user guide shows some new things: The formula SAPSetFilterComponent has two new parameters: MEMBERSELECTOR You can now copy Table Design from one Crosstab to another. This is really cool. Table Design formulas can now be restricted The admin guide has 20 new pages to the Analysis Office 2.6 guide. The settings chapter is new organized and in my...

Show more