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
300 Views Asked by Dhamu At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in OBIEE
- Oracle BI (OBIEE) - Wildcard search for numeric values only
- OBIEE Master and Detail relationship
- Is it possible to set the content level for all logical table sources?
- Error with import BAR-File from OBIEE 12.2.1.0.0 to 12.2.1.2.0
- ORA-00904 when trying to query data via OBIEE
- Automated website login through powershell script
- What is a good way to handle hierarchies in dimension tables
- OBIEE case statement check on non excistence
- How to clear OBIEE cursor cache (presentation server)
- Not seeing the complete resultset from LISTAGG in EVALUATE_AGGR
- Oracle BI Publisher multiple select parameters
- correct query design? cross joins driving ad-hoc reporting interface
- How can I incrementally count the values of an sql result set column in the same result set?
- Summing by Column
- Replace a Space with Special characters in a SELECT
Related Questions in BI-PUBLISHER
- BI publisher - chart error in Oracle APEX output excel by using rtf template layout
- How to dynamically show field in RTF template based on the position of another field
- Oracle BI Publisher multiple select parameters
- BI Publisher in Word buttons don't work
- Oracle BI - publisher error "unable to extend table APPLSYS.FND_CONC_PP_ACTIONS"
- How to call a BI publisher report from SOAP UI
- How to remove column header in csv output in BI publisher?
- Bi Publisher date format not working in RTF template
- How do I use an xdoxslt variable inside xsl code, in BI Publisher?
- need help formatting a date parameter in Oracle BI Publisher RTF template
- Oracle BI publisher for each group alternate colors rtf
- Bi Publisher - Report with 2 different Datasources
- Clarification regarding this line in the Oracle BI Publisher report designer guide?
- Request Sets, request groups, concurrent programs... what is the relationship between all these?
- oracle bi publisher excel template report error- output failed
Related Questions in ORACLE-BI
- BI Tool(information builders vs oracle BI
- I am not able to add columns in XML Publisher report
- How Can i change Lexicals in Oracle BI publischer 12c with a Parameter
- Dynamic Column selection in BI Answers/views based on Dashboard prompt selections
- How to get dollar($) sign in grand total in OBIEE 12c?
- OBIEE: I can't schedule reports. Unauthorized Access: please contact the administrator
- In Oracle BIEE - Trying to Subtract Number from a Prompt Variable on a Filter
- OTBI analytical function to get Yes or no for an employee according to another column value
- OTBI analytic to function value is not null in any one of the columns for a particular employee
- Report framework for Angular 6
- Do not apply for a visualisation "use as filter" from the other visual - oracle OAS/DV
- How to put 0 instead of blank in rtf template
- Oracle Analytical Desktop Variable Prompt issue
- Retrieve more than 200 rows in data model in BI publisher
- Oracle BI report consistency
Related Questions in ORACLE-ANALYTICS
- Oracle analytic function - using FIRST_VALUE to remove unwanted rows
- How could I connect Power BI to Oracle Cloud Analitics?
- Dynamic Column selection in BI Answers/views based on Dashboard prompt selections
- Hiding a column in pivot table if the column is null in Oracle OBIEE
- Is it possible to import Excel file into OBIEE or OAS and use it with other subject areas?
- How to achieve string concatentation of entries in column having same id in Oracle Analytics Cloud Professional Edition?
- OBIEE RPD: Snowflaked table not showing up as a fact table in the BMM layer
- Oracle Analytical Desktop Variable Prompt issue
- Merging workbooks in OAD (Oracle Analytics Desktop)
- see physical SQL in oracle analytics cloud reports
- How to find the sum of each group which is grouped by another group?
- Oracle remove rows from a query set based on sum
- SQL query : How to retrieve minimum value from top to that row in Oracle
- Bringing records from separate rows into one
- Difference between the values of multiple rows in SQL
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)
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?
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.