I have a requirement, I need to create a WebI Report on top of a HANA View, but the HANA View has cascade prompts and when I try to create the report in Webi, these cascade prompts are not working as expected. Prompts just show the values without filter out any previous value. These cascade prompts are working fine in HANA (HANA Studio).
The hierarchy prompts are working fine but these cascade prompts don't.
Can you help me to understand what is missing?
I'm using SAP BusinessObjects BI Platform 4.2 Support Pack 7 Patch 5