Posts tagged with "analysisoffice"

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...
09. July 2019
Query with a simple layout
It has been a quite while since the last post. But with a go live and a reorganization of my current project I hadn't time to look into some topic. But here is a new kind of interessting bug. We had an open task from a user of the controlling department, that a query display the message: "Size Limit of result set exceeded."
06. June 2019
Since 24.05.2019 the latest service pack of Analysis Office is available. At the moment I am working on a test tool to automate testing in BW so I can easy check if any change of mappings and so on has an impact on my ADSO or query result. But I found time to install it. A "bug" what I found was when I want to insert a data source from the recent list, nothing happend. The solution was to reinstall Analysis Office and now it works. Here is the list of bug fixes:

Show more