Skip to Content

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:

/wp-content/uploads/2013/06/querydesigner_226708.jpg

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

/wp-content/uploads/2013/06/querdesignersmp_226712.jpg

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:

/wp-content/uploads/2013/06/memberselector_226713.jpg

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.

/wp-content/uploads/2013/06/rightclickusehierarchyforfilteronly_226714.jpg

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

/wp-content/uploads/2013/06/2rightclick_226721.jpg

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

/wp-content/uploads/2013/06/3filter_226722.jpg

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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

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

    Regards,

    John B.

    (0) 
    1. Tammy Powlas 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.

      Regards,

      Tammy

      (0) 

Leave a Reply