Skip to Content
Author's profile photo Tammy Powlas

BusinessObjects Analysis Office 1.4 – More Features, Part 3

Part 1 covered installation and some features.  Part 2 discussed more features including Waterfall Charts, Read Access Mode, and Reset Data Source.

Launch BEx Query Designer

First I want to cover some troubleshooting.  Some comments in the discussion forum indicate that individuals are unable to launch the BEx query designer – it is greyed out.  Note you must be on a later SP for the BEx Query Designer.  Check your version by going to Help > About in the BEx Query Designer:


If you are not on this version then go to Service Marketplace and download the BI Add on:


Then you should be able to click this option in the User Settings.

Adjusting the Member Selector

You can limit the number of members in the “member selector” by going to User > Settings:


You can change the Maximum Number of Entries in Recent List – the default is 1000.  This may help improve performance when working with large amounts of data.

Filter Hierarchy in Display Panel

In the display panel, you have the option to filter based on hierarchy only – if you select this, your hierarchy turns into a flat presentation.


When it is clicked on, the hierarchy in the cross tab is turned into a “flat presentation”


But then you can filter by the hierarchy or the leaves of the hierarchy:


Hands On Experience

Next week at BI 2013 in Amsterdam, SAP Mentor Ingo Hilgefort will be providing hands-on sessions for the Analysis Suite, including Analysis Office.  I attended this myself at BI2013 in Las Vegas in March and these sessions were quite popular with great feedback.  I recommend attending these sessions if you are attending.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for this posting Tammy.



      Author's profile photo John Baron
      John Baron

      Hi Tammy,

      Thanks for the info. We have been looking for information on inserting a dynamic filter based on a range of cells in an AO workbook. Any help would be great.


      John B.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi John - thank you for your reply.

      Would you please post your question in the discussion forum?  I admit it's been years since I've used the BEx Analyzer so I do not have an answer to your question.