we are creating a pivot table in OBIEE, we need to hide columns from the pivot table if those columns are null. Is there any implicit way of doing this in Oracle OBIEE? Thanks in advance
Hiding a column in pivot table if the column is null in Oracle OBIEE
680 Views Asked by Raghu R 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 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?
No you can't. For the very simple reason that a pivot is a cross-table and does intersections of data so you quite literally can never be sure that a whole "column" as you call it retrieves only NULLs. It simmply doesn't make sense.