Filter by hierarchy node, show flat list

[#1]

Hi all,

in Design Studio we like to display a characteristic as a flat list, but filter it by hierarchy nodes.

In Analysis Office I could flag the characteristic as "use hierarchy for filter only".

Where could I set these settings in Design Studio?

Regards

Arne

[MustafaBensan]

Hi Arne,

At first glance I was not able to come up with an approach to fulfil your requirement using the standard filter components (perhaps others in the community may have ideas about this).  However, assuming your data source is a BEx Query, you can implement your requirement using a Hierarchy Node Variable as follows:

1.  In your BEx Query, define a Hierarchy Node Variable for the the characteristic you wish to filter and place this in the filter panel:

2.  Create a data source in Design Studio based on the above BEx Query and make sure the hierarchy is not activated for the characteristic to be filtered.  If you then connect the data source to a Crosstab for instance, initially the unfiltered data should be displayed as a flat list (in this example characteristic Airline ID):

3.  Invoke the Prompt Dialog using the APPLICATION.openPromptDialog() method at a suitable point in your application to display the hierarchy node variable.  In my example I created a "Filter" button to launch the dialogue:

4.  Select the node from the hierarchy that you want to filter by:

5.  After confirming the dialogue prompt with the selected hierarchy node, the Crosstab displays the filtered data as a flat list:

Maybe not the most elegant solution but it works.

Regards,

Mustafa.