Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dynamic Column selection in BI Answers/views based on Prompt selections
Dhamu
Rank 3 - Community Apprentice
Summary
Dynamic Column selection in BI Answers/views based on Prompt selections
Content
Hi,
I need to have a BI Dashboard where the columns(eg, Brand) or group of columns ( eg, Company, Company site) have to hide/show in dashboard based on check box selections with Brand and Company respectively. I am able to pass the column header and formula based on selection through Presentation Variable in Prompts, but stuck with hiding columns when the respective check box in unchecked.
Thanks in advance for any help on how to achieve/proceed further.
Note: Using thin client modeler for building model. And my requirement is similar to the blog here http://obieeil.blogspot.com/2015/04/obiee-selecting-columns-dynamically.html
Version
OAC 5.8
0