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 all analysis of 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. Note than I'm using OACv5.8. Thanks in advance for any help on how to achieve/proceed further.
Dynamic Column selection in BI Answers/views based on Dashboard prompt selections
303 views Asked by Dhamu At
1
There are 1 answers
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in OBIEE
- OBIEE not able to connect with Mongo Database
- SQL Case When Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected CHAR got DATE at OCI call OCIStmtExecute. (HY000)
- How to display Grand Total for only one column in pivot table in Oracle Analytics Server?
- Convert MongoDB Schema generated using 8.0 driver version to 8.1 driver version
- How do I put a search in the text box in a report view with Microsoft Report builder?
- RTF template Pagetotal + Brought/Carried Forward
- Where can I see .atr files in OBIEE
- OBIEE 12c Last Modified is not updated when we unarchive file
- Why there are some hidden files in OBIEE12c catlog
- How to speed up a writing and reading speed from data mart via splitting it into multiple parts in data warehouse and use it in OBIEE?
- OBIEE 12 c RCU installation stuck on DB connection
- OBIEE Migration
- How can I add outer markup to OBIE
- Reverse display in a pie chart in obiee
- OAS - Sum of 2 parent agg from different levels
Related Questions in BI-PUBLISHER
- BI Publisher Report Runs slow but running in SQL Developer is fast
- How to remove the decimal point from a string
- BIP Excel Bursting issues
- BIP Excel output removing zeros from decimal
- BIP Report Layout - Chart Values rounding up and showing as K (thousands)
- How to exclude column names from csv output in Oracle BI publisher
- In RTF BIP word template, need to change the background color of the table based on a field where background color is also a field
- How to retrieve BAi2 bank statement files after processing from oracle fusion
- Missing Keyword Error in Oracle BIP Report when Using Case statement in where clause - Oracle fusion grants management query
- How to sum distinct values within the same transaction number in RTF using BI Publisher?
- BI Publisher - How to get rows to repeat in a table w/ dynamic column on RTF template
- Error exporting RTF BI Publisher template to PDF when I change a table design in Microsoft Word
- How to control dimensions(Width and Length) of an image within a BIP report specifically when generating an output in Excel format (oracle EBS R12)
- XML OUTPUT IN ORACLE APEX
- How Can i change Lexicals in Oracle BI publischer 12c with a Parameter
Related Questions in ORACLE-BI
- BI Report - Bursting - Not generating output file
- Oracle OTBI Fusion:Wanted a query to fetch last day of previous year to use in OTBI
- How Can i change Lexicals in Oracle BI publischer 12c with a Parameter
- Reverse display in a pie chart in obiee
- Oracle BIP parameter - Missing Right Parenthesis error
- Oracle sql to find the next monday from the stop time in the query
- Is there a way to generate a QR code with multiple lines of text in Oracle BI Publisher report?
- Oracle BI Publisher Scheduled Report to FTP File Name
- Change Catalog Type in Oracle BI Publisher 12.2.1.0.0
- Oracle Analytical Desktop Variable Prompt issue
- How to put 0 instead of blank in rtf template
- Do not apply for a visualisation "use as filter" from the other visual - oracle OAS/DV
- How install Marketing Segmentation in Oracle Business Intelligence Enterprise Edition 12c
- BI publisher, Issue with repeating field in PDF template
- OTBI analytic to function value is not null in any one of the columns for a particular employee
Related Questions in ORACLE-ANALYTICS
- BIP Report Layout - Chart Values rounding up and showing as K (thousands)
- How could I connect Power BI to Oracle Cloud Analitics?
- Oracle OAS 6.4 - Working with measures in diagrams
- OAS - Sum of 2 parent agg from different levels
- Is any option to move Oracle Analytics Cloud in Azure?
- SELECT query over an interval of 1 day and use analytic functions LEAD()
- see physical SQL in oracle analytics cloud reports
- Merging workbooks in OAD (Oracle Analytics Desktop)
- Oracle Analytical Desktop Variable Prompt issue
- Bringing records from separate rows into one
- SQL query : How to retrieve minimum value from top to that row in Oracle
- Is it possible to import Excel file into OBIEE or OAS and use it with other subject areas?
- How to find the sum of each group which is grouped by another group?
- Please help combining with clause scans into one
- How to update security credentials in Oracle BI
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Why don't you use standard, out-of-the-box functionality like column selectors or show/hide sections?
Instead pf playing with presentation variables and trying to fiddle around.