Cascading prompts is a feature that is liked by many customers because it allows them to have a preview of their data through prompts before actually seeing the data. Within Business Objects, the prompt behavior is delegated to the system where the prompts are defined.

If the prompts are in BW or HANA , the prompt behavior is handled by their respective systems and this usually meant that cascading prompts were available only if we modeled HANA Universes and set the prompts on the Universe. Having a direct connection to HANA in BOBJ 4.2 I was curious to see how we could achieve Cascading prompts in HANA directly as opposed to using a universe to create cascading prompts with filters applied on LOVs.

To achieve this, we make use of Parent Child Hierarchy in HANA.

Cascading Prompts in HANA

Create a calculation view (CV) ‘CV_PRODHIER’ that defines the “Product_Category” Hierarchy.

Cascading Prompts in HANA

Assuming that Fact table or CV is available, we create final CV of Data Category type ‘CUBE’ with ‘Star Join’ checked in& include the Fact table/CV in Star Join along with ‘CV_PRODHIER’.

Cascading Prompts in HANA
Cascading Prompts in HANA


Make Referential join with ‘Product’ & ‘Child’ fields as Child field contains all the possible values in the Hierarchy (Both Parent & Child level values).

Cascading Prompts in HANA

Create an Input Parameter that makes use of the Hierarchy we created as a Value Help

Cascading Prompts in HANA

Apply Filter to the Fact node on the fields involved in the Hierarchy.

Cascading Prompts in HANA

Final Output:

Cascading Prompts in HANA
Cascading Prompts in HANA

When the final CV is executed we see a single IP being displayed which holds the values for Product Category, SubCategory & the Product Names. Thus making use of Hierarchy for Cascading selection in HANA prompts. Also since this is going to be linked with the transaction data , it becomes truly cascading at the modeling layer itself.

Got questions? Click here to get in touch.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!