blog.

After the latest service pack of Analysis Office 2.8 was released this week, the online help is now available. Analysis Office now offers a button for creating and deleting of comments in the ribbon menu. In former versions, SAP used the text of Microsoft Excel for comments. As Microsoft renamed the comments to notes, it was inconsistent in the ribbon and the context menu. Now it is consistently again.

Also new is the file system setting UseLegacyModeForFormulaContext which allows you to specify the mode for creating formulas with Table Design. And in the planning area there is a new setting called PlanningFunctionUploadFolder, which allows you to upload the values for executing planning objects from a file.

So it is nothing big, but Analysis Office is still developing and not dead, even if there is a new SAC Addin. I hope there will be some feature I submitted. 

The SAP Transport Dependency Check (TDC) is a little tool that helps you to find corresponding transport requests in your SAP NetWeaver Business Warehouse  which are not imported yet in your target system (e.g. production system). First you have to enter a transport request you want to check and also a target system and the last considered date (e.g. last go live).

Since today the latest version of Analysis Office 2.8 (release notes) is available. You can download it with your s-user in the SAP Support Portal.  There are only a few fixes:

• AO: BEx Analyzer Workbook Conversion - Not all filters of Text Element converted (s-note 2902130)
• Chart Data Series are added again as Chart Data (s-note 2898931)
• Exception thrown when the login process is interrupted (s-note 2900972)
• Hierarchy selection disappears after confirming Filter Dialog in case of HANA (s-note 2897838)

The online help is not updated, but will be in a few days I think. Also the special addin for SAP Analytics Cloud 2.8 SP2 is released. If you have any questions feel free to ask.

If you want the latest edition of Analysis Office - The Comprehensive Guide, you can get it now with a 20% discount until easter 2020. Use the code Easter2020 in the online shop. 

If you want to read a review first, have a look at the review from Tammy Powlas or from Xavier Hacking. Tammys review is about the 3rd edition and Xaviers about the 1st edition.

If you have any questions or need any help, don't hesitate to contact me.

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.

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.

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 the admin or user guide by pressing F1 in the ribbon menu or the help on this function in the insert function dialog. The sam works for the customize user interface and the technical configuration.

This are some sweet features even not everything is running smoothly.

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.

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.

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.

Now the book Analysis Office - The Comprehensive Guide 4th edition is now available via digistore24.com. You can use credit card, paypal and other payment options.

>>> https://www.digistore24.com/product/284862

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)
• SAPSetFilterComponent and Time Characteristics (s-note 2829371)

As you can see in this version there is not many things fixed or maybe they found not more? But the What's new Guide lists some new file system settings (technical parameter)

• ForceWriteOlapConnectionInformationDuringWorkbookSave 
• UseDocumentDescriptionToConstructBIDocumentFileName
• UseDocumentDescriptionToConstructBWDocumentFileName
• SacHttpSessionPingInterval
• SearchFetchMemberLimit
• AllowOverwritingOfDimensionNames
• AllowOverwritingOfStructureMemberNames
• ReverseVariableProcessingOrderForHanaFromOldxml
• UseKeyForHierarchySelection
• UseQueryVariantsForViews

The admin guide now documented now all these parameters. A nice parameter is UseKeyForHierarchySelection, which allows you to define if you want to see the keys of a hierarchy in the first coloumn or second column of your prompt.

Hi,

I just got an email from you via the contact formula. But When I answer to your email or to your shop order, I get an error "The email account that you tried to reach does not exist." I tried it several times, maybe your account is full? So can you please provide me another mail address or contact information? Maybe via Linkedin or so?

Thanks, I don't know any other way to contact you :)

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.

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 whether the cut, copy and paste entries should be available in the context menu for a crosstab cell. The setting EnableImprovedAddInCompatibility should improve the compatibility with other Microsoft Office add-ins. How this work we will see.

The setting UseSeparateDisplaySettingsForFilterDialog you can define if the display settings defined in the filter dialog should be saved with the workbook.

So as you can see nothing spectecularit fixes also a little bit:

• ALL: Current View Edition mode when a member start with the same characters that another member (s-note 2811124)
• ALL: during a customized drill through Excel remains frozen (s-note 2813223)
• ALL: last selection not saved when set to Base Level (s-note 2811297)
• AO 2.7 SP6: Office 2010 - Can't open AO workbooks via launcher (s-note 2814329)
• Analysis Office Performance Issue when Refreshing Workbooks with Many Format (Design) Rules (s-note 2813968)
• ALL:Report options are truncated (s-note 2814791)

 I am still looking for Analysis Office 2.8, but now I am first enyoing my vacation.

In our current project we had to deal with the requirement that the enduser only want to show a certain node of a hierarchy to filter. So we used the F4 restriction from the transaction spro. You find the entry under Business Warehouse >> Enhancements >> BAdI: Restricting the Value Help in the Variables Screen. We implemented it in the method GET_RESTRICTION_NODE.

At this time I had only experience with the method GET_RESTRICTION_FLAT and searched for implementation examples. I found a wiki entry on scn. In our case we had bookable nodes so we implemented it like this to get these node and all children of it.

l_s_node-nodename = 'NODE1'.

l_s_node-niobnjm      = 'ZZ_IO'.

Append l_s_node to c_t_node.

But it didn't work out. The debugging showed no error, but the restriction always showed the complete hierarchy. After a little digging we found our mistake, it have to look like the follwing:

l_s_node-nodename = 'LEAF1'.

Append l_s_node to c_t_node.

l_s_node-nodename = 'LEAF2'.

Append l_s_node to c_t_node.

And so on for all leafs. So we had to add all leafs and not the nodes. I didn't found any good explanation so here is the short article about it. Thanks to my collegue who had the problem.

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."

That's an odd thing, because the query has only six columns and 110 rows and when the user dragged the calendar month into the columns it should have 12 columns for the actual year and 110 rows. Which is defintily lower than the limit of Analysis Office, which is 500.000 cells.

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:

• Analysis Office: Exception from HRESULT: 0x800A03EC when trying to save a protected workbook (s-note 2781162)
• Launcher error when launching from BIP (s-note 2781090)
• Warning message about comments without using comments (s-note 2780925)
• ALL: Locked cells can be edited when Excel grouping/ungrouping is allowed (s-note 2784832)
• ALL: Refresh may be incorrect in some cases (s-note 2786604)
• ALL: Refresh metadata fails when a workbook was closed before (s-note 2786615)
• AO: End-User-Defined Characters on Prompts (s-note 2781131)
• AO: Mouse actions don't work in wbs with brackets in their name (s-note 2782332)
• All crosstabs are deleted after clicking on cell after editing (s-note 2791886)
• Analysis Office: After execution of planning sequence or applying filter new lines contain data of the result set (s-note 2789464)
• Analysis Office: Exception when closing workbook (s-note 2788026)
• Analysis Office: Grouping of crosstabs containing characteristics with different names but same descriptions (s-note 2784694)
• Analysis Office: erroneously new lines are displayed after executing a planning sequence (s-note 2785251)
• New Lines - Value Help does not return selected value (s-note 2780363)
• Refresh Data fails if additional Workbook appears during opening and one is cleaned (s-note 2790594)
• Scheduled Workbooks Get Corrupted and Issues with Special Named Ranges and Sheet Names (s-note 2784545)

Did anyone have the same bug with the Insert DataSource function?

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).