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.