Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Dynamic Column selection in BI Answers/views based on Prompt selections
Summary
Dynamic Column selection in BI Answers/views based on Prompt selectionsContent
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