Web Intelligence Cascading Prompts

[Former Member]

Hi all,

I have a question about Web Intelligence, I am building a webi query over the top of a Bex query, so using a BICS connection. The customer wants to user cascading Query prompts, so basically if the user selects Italy as a country only the products sold in Italy will be displayed as possible selections in a product query prompt. Does anyone know how to do this? I have looked at the ‘Result from another Query’ option where we could have chained two queries together, however this option is not available in a BICS connection.

Any help is gratefully appreciated.

Thanks

Dave

[sateesh_kumar1 · Accepted solution]

Hi David,

Ssince we can't do any modifications to OLAP connection in BO end, We need to use BEx hierarchy variables to achieve this requirement.

[Former Member]

Hi David,

Good Approach would be building the Universe on top of Bex Query and take it at the Universe Level

Hope the below link helps you to go with the UDT Approach

http://blog.davidg.com.au/2011/05/cascading-prompts.html

[Former Member]

Getting data from another query is not an option with the BICS based webi.Also unfortunately there is no good way to have a custom cascading prompt if the hierarchies are not available in Bex. Here is a link to the idea place to have this functionality in a future release https://ideas.sap.com/ct/ct_a_view_idea.bix?c=7732DE74-E9A6-4736-AEE0-6181E5BB5F5E&idea_id=EE6432C0-... However if performance is not an issue and you need this functionality you might also want to look at MDX based OLAP universe using the old UDT tool which is still available with BI 4.0 . That will allow the custom cascading prompt  to be created on the universe.