hi Angela,
As a followup to this, I am looking for similar functionality with having dynamic prompts and the cube on the same page. I understand that for dynamic prompts with data driven from the cube, we can go with a custom approach using stored process but I am wondering if we can have the cube on the same page ? Thanks
I was also looking how to build a cascading prompt with OLAP. When I couldn't find the answer I thought of a very simple solution that does the trick for me. I just created a hierarchy of the two dimensions that I wanted to cascade, after that you can create a prompt on this hierarchy without having to customize anything.
Maybe this will work for you too.
Regards,
Just
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.