Hierarchical Prompt

[jwickstr]

Is there a way to create a prompt in Report Studio that displays each of the levels of a dimensional hierarchy and allows a user to choose values from any level of the hierarchy?

For example, consider a hierarchy of product line, product type and product name.Ã,  I'd like to create a prompt that would display each product line, the product types within each product line and the product names within each product type.Ã,  The user could then select values from any level to construct a filter such as "All of product line A, product types 1 and 2 from product line B, and products x, y and z from product type 3 from product line C", or any other combination they choose.

Here is an image of something similar in MicroStrategy's tool:Ã,  http://i.cmpnet.com/intelligententerprise/040320/gifs/704products_fig2.gif

I know how to create a cascading prompt among the members of a hierarchy, where I could choose a product line and the product types within it are displayed.Ã,  Then I choose a product type and see the list of product names within the product type.Ã,  What I want to be able to do here is max and match selections from multiple levels of the hierarchy with no dependencies on previous selections.

Any thoughts?

Thanks

[Darek]

Tricky and sounds alot like an OLAP report, which would be better handled by PowerPlay. Or actually it will exist in Series 8 accordingly to some reports.

[Merri]

I don't know of an easy way to display the prompt like your example, but you should be able to construct a query for use in a Search and Select prompt.

You may be able to simulate the look of a hierarchy if you left-padded the string values while preserving the sort order with a separate sort order field in the prompt query. You would need to be very tricky in determining the prompt value from a given selection, although you should be able to construct something based on the level of the selection. It depends on how complex your hierarchy is.
Of course, the more processing required in your prompt query and resulting filters, the more performance of the underlying report will be affected. However, the search and select prompt should supply something close to your requirement; you may just have to manage the users' expectations.