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.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

Please share a comment if you like the video.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

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.

But the filter dialog in Analysis Office shows only the short text of this InfoObject and you cannot change it.

So this is very annoying because sometimes the short text does not explain the selection in a proper way. But there is a solution for this. You have to change the setting Display in the
Reporting Properties of the Composite Provider. You find this setting under Output of every Composite Provider for each InfoObject.

You can change the setting Display to the following options:

• Key and text
• Text
• Key
• Text and key
• Long text
• Medium-length text
• No display
• Short text
• Text and key as short text
• Text and key as medium text
• Text and key as long text
• Key and text as short text
• Key and text as medium text
• Key and text as long text

So when you now change it for example to Key and text as medium text, the prompt dialog filter shows the medium text.

I hope this help someone to solve a problem. If you have any questions write them in the comments.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

It is done, the latest version of my book Analysis for 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.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

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.

If someone finds another interesting point, let me know.

These posts might also be interesting:

• What’s new in Analysis Office 2.7 SP7
• What’s new in Analysis Office 2.7 SP2
• What’s new in Analysis Office 2.7
• What’s new in Analysis Office 2.6 SP3

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

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.

Does nobody test basic functions before releasing a new version? But they also fixed some bugs from previous versions.

• Analysis Office: Red borders around valid new line cells (s-note 2831840)
• AO: Documents opened from a BI Platform system are not displayed in Recent Documents List of AO (s-note 2848548)
• Analyis Office: Content of new line cells is overwritten by content of other crosstab cells when opening workbook (s-note 2861063)
• Analysis Office: Design rules formats of master crosstab not applied to dependent crosstab (s-note 2849041)
• Analysis Office: Exception when closing workbook in case ‚Remove Data Before Saving‘ is active (s-note 2854979)
• Analysis Office: Inconsistent behavior if RSADMIN parameter BICS_NEW_LINE_CHECK_ENABLED is set to blank or not existing (s-note 2844345)
• Analysis Office: Performance Tuning (s-note 2821386)
• Error after assigning attributes or while dragging them (s-note 2852220)
• Filter of a planning function not set (s-note 2851131)
• Grouped Crosstabs: „No Applicable Data“ in all Cells of the Dependants (s-note 2858675)
• Login to SAC System fails due to not receiving a valid X-XSRF token from the root url (s-note 2853284)
• New Lines – Value suggestion is not working for cell if display is combination of Text and Key (s-note 2859180)
• New Lines and Format Cells entries not disabled in context menu while running Analysis for Office in embedded Excel (s-note 2860401)
• RFC_METADATA error after upgrading BW server (client part) (s-note 2861026)
• Refresh does not work when refreshing via Workbook_SAP_Initialize event (s-note 2848410)
• Scheduling fails if Workbook contains several Styles Definitions for same Name (s-note 2840608)

I hope SAP will release soon a serivce pack 1 for Analysis Office 2.8 and fix the problem with the hierarchy, because at the moment Analysis Office 2.8 is not useable.

Update 09.12.19:

As described in the comments, it works on SAP BW 7.5 SP11 and my test was on a SAP BW 7.5 SP16.

These posts might also be interesting:

• Analysis Office 2.7 SP8 is available
• Analysis Office 2.7 SP6 is available
• Analysis Office 2.7 SP5 is available
• Analysis Office 2.6 SP3 is available

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.

So he selects the nodes he needed manually. This could be very frustrating and time intense if you have a lot of nodes you want to select. But there is a smarter way to filter multiple hierarchy
nodes either via Paste or Upload. How it works I show you in this post.

First add your dimension into the rows.

Make a right click on the dimension and select the option Use only hierarchy Product Hierarchy for Filter. The term Product Hierarchy comes from your dimension. In
my case the Product Hierarchy.

And when you now select Filter By Range, the following filter dialog will be shown, where you get a Paste or Upload function.

Now you can paste or upload your values and click OK. Your data will be filtered. When you now remove the the option Use only hierarchy for filter, the hierarchy
wil be displayed again.

If you have any questions or problems, just leave a comment or write me an email.

These posts might also be interesting:

• Analysis Office  – The Comprehensive Guide 4th edition
• Analysis Office Size Limit of result set exceeded with small query
• Analysis Office 2.7 SP6 is available
• Analysis Office Data Source for Defining Formulas

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

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

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

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.

As you can see, the user can now either see the description or the technical name in his selection. Another setting is the AllowOverwritingOfDimensionNames. The default value is true,
that means the user can overwrite the name of a dimension in the design panel.

The same works with the setting AllowOverwritingOfStructureMemberNames for structures. The best setting is UseQueryVariantsForViews. With this setting you can get the query
variant when you insert a query view.

As you can see in the right picture, I can access the variant of my query. This is really cool when I use a lot of variants. I know this service pack is not the hotest shit, but slowly it gets
better. I am still hoping for Analysis Office 2.8 with new features.

These posts might also be interesting:

• What’s  new in Analysis Office 2.7 SP7
• Analysis Office 2.7 SP5 is available
• Analysis Office 2.7 SP2 is available
• Analysis Office 2.5 – Technical Configuration

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.