Posts tagged with "analysisoffice"

27. January 2020
Master Data of an InfoObject
Until now, we speak of Analysis Office 2.8, if you have different text maintained for an infoobject, Analysis Office shows only the short text in the prompt dialog. The maintenance view of the InfoObject shows all different texts.
21. January 2020
It is done, the latest version of my book Analysis Office - The Comprehensive Guide is available. It was a lot to do and so the book has now 346 pages. The 4th edition had only 299 pages. So there is some new stuff inside. The first 5 who contact me will get a promo discount code. Also I am happy if you want to write a review you get a review discount code. So you can buy it in the store. In future I will create more videos if there is any interest. So please leave a comment.
03. December 2019
Highlighted dimensions
Yeah finally is Analysis Office 2.8 available. It took a long time. Here is a overview what's new. In the prompt dialog you can clear all values In the prompt dialog you can insert easily ranges with "value" "space" "minus" "space" "value" e.g. 2018 - 2019 You can display Dimension Groups in the Query. The used dimensions are highlighted in the design panel You can easily select the access mode in the property view Variants in the prompt dialog are now in alphabetical order You can easily get...
02. December 2019
Since last week the latest version of Analysis Office is available. I installed it right away and want to test it. And what I have to see? You cann't add hierarchies into the rows or columns of your crosstab. I tried to record it maybe you can see it in the video below.
28. November 2019
Filter Hierarchy Nodes by select manually
This week I discussed with a colleague. He ask if there is any way to filter multiple entries in a hierarchy because there is no Paste or Upload function in the hierarchy filter dialog.
25. October 2019
Analysis Office Workbook Structure
The Analysis Office Workbook saves a lot of information in it. The Microsoft Excel format xlsx is a container which can save a lot of other information besides the normal data. When you rename a xlsx file to a zip file you can extract it with for example 7-Zip. Now you see the following folder structure.
24. October 2019
Now the book Analysis Office - The Comprehensive Guide 4th edition is now available via You can use credit card, paypal and other payment options. >>>
02. October 2019
Default Value UseKeyForHierarchySelection
The latest version of Analysis Office is now available. It was released on 27.09.2019 and after the go live of my project is now done, I may have time to look more into Analysis Office again. AO Prompt Selection makes Excel.exe freeze (s-note 2836430) Analysis Office: Red borders around valid new line cells (s-note 2831840) Exception when opening or saving a workbook or data source after Log Off (s-note 2838591) RRI passes wrong context for axis tuple element (s-note 2834404)...
16. August 2019
Until the end of the month you can get my book with 30% off. Just use the discount code Summer2019. You can buy it here.
15. August 2019
It's a kind of summer break at the moment and I haven't done a lot for this blog in the last time. But SAP now release the 7th service pack of Analysis Office. You can now use the filtering data access mode with SAP Analytics Cloud data sources, analytic and planning models. There are also 3 new file system settings: ShowCutCopyPasteInGridContextMenu EnableImprovedAddInCompatibility UseSeparateDisplaySettingsForFilterDialog The setting ShowCutCopyPasteInGridContextMenu allows you to sepcify...

Show more