2019.

Analysis Office 2.7 SP6 is available

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:

Read More 0 Comments

SAP BW fix incorrect data in a DataStore-Object

Here just a short notice if somebody doesn't know it yet. If you have a false information in a data record you can fix this manually either in a PSA or (A)DSO. Just select the desired entry and click Display (F7).

Read More 0 Comments

SAP HANA Table Functions

It has been very quite at the moment.Because nothing spectecular is happening in the Analysis Office world. SAP released Analysis Office 2.7 SP5. I still hope they get Analysis Office 2.8 back on track and without so much problems as they have today.  But back to topic.

Read More 2 Comments

Analysis Office 2.7 SP5 is available

Since last week SAP published the latest version of Analysis Office 2.7 SP5. I don't know if any other version ever had a service pack so high like the actual version. At this time SAP doesn't offer the newst help file under help.sap.com/boaa. So stay tuned if there is something happening. Here is an overview about what they fixed:

Read More 2 Comments

Customer exit variable to hide hierachy node

In my current project we have the hide a position in a hierarchy, because it is a departmental requirement. The hierarchy is used by many departments so we cannot change it and we also don't want to have the same hierarchy two times (except for the one position). So we first excluded the position in the query.

Read More 0 Comments

Analysis Office 2.7 SP4 is available

Since last week the latest SP of Analysis Office is available. You can download it here, but you need a S-User.  I know I am a little bit late but here here is the overview of what is now fixed:

  • AO 2.7: SAC - Exception when editing cell values while characteristic Versions is in Background Filters (s-note 2743351)
  • AO 2.x: HANA - Member Selector - Searching for a date does not return any results for characteristics of data type "DATE" (s-note 2742728)
  • AO: SAC - Versions Tab not displayed when opening a saved workbook that contains a planning enabled model (s-note 2743355)
  • Analysis Office: Exception when closing Excel workbook (s-note 2741439)
  • Analysis Office: calling SAPSetFilterComponent via Visual Basic throws an exception (s-note 2740920)
  • Analysis Office: connection to BW system fails if message server is maintained on BIP using router syntax (s-note 2744794)
  • Dependent hierarchy node variables have wrong value (s-note 2745229)
  • Excel hangs during workbook refresh (s-note 2743853)
  • F4 Help on Input Ready Cells (s-note 2742723)
  • SAPGetData referencing a cell of type numeric (s-note 2741409)
  • ALL:Report recognition issue (s-note 2743045)
  • AO 2.x: Can't logon with language Basque / Euskara (EU) (s-note 2744455)
  • Added Support for PowerPoint Feature 'Design Ideas' (s-note 2743659)
  • Could not read grid properties (s-note 2744138)
  • Workbook is corrupted if contained charts are filtered (s-note 2741492)
Read More 0 Comments

Analysis Office - The Comprehensive Guide 4th edition

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. Also is the 3rd edition now available on amazon.

Read More 0 Comments

Analysis Office 2.7 SP3 is available

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 system resources" exception after disabling Analysis (s-note 2715429)
  • Rendering issues with hierarchies when opening or saving workbooks (s-note 2730596)
  • After launching document from platform some functionality of Analysis Office is not available (s-note 2725968)
  • Analysis Office Scheduling Fails for Workbooks with Waterfall Charts (s-note 2731173)
  • Analysis Office: Expanding or collapsing hierachical nodes not possible after entering planning data (s-note 2725060)
  • Analysis for Office: empty cell is displayed instead of header text when using grouped crosstabs (s-note 2714938)
  • Array Formulas are not dectected and updated (s-note 2729399)
  • BW comments: document filter (s-note 2709480)
  • CTRL + F4 or ALT + F4 open Value Help on Input Enabled Cell (s-note 2718143)
  • Crosstab Formatting by User is discarded when Data is Removed Before Saving (s-note 2715376)
  • Dynamic calculation initially not visible (s-note 2714787)
  • Error caused by circular dependency with restrictions (s-note 2732084)
  • Error when open workbook from BI Launchpad with local BW data source (s-note 2725798)
  • Exception 0x80020005 when working with several workbooks (s-note 2714665)
  • Exception when selecting measure or key figure of crosstab (s-note 2719635)
  • Known Issues in Application Builder Embedded Profiles in Analysis Office (s-note 2685815)
  • Missing authorization when loading comments from BI Platform (s-note 2717435)
  • Recent List of Open Workbook from SAP Business Objects BI Platform shows all workbook entries as enabled (s-note 2723455)
  • Ribbon controls get duplicated with Embedded profiles in Analysis Office workbooks (s-note 2717113)
  • ValueHelp is shown by pressing F4 even if context is wrong (s-note 2716038)
  • Workbooks are loaded from Netweaver backend although caching is active (s-note 2722138)
Read More 0 Comments