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
683 Views Asked by Raghu R At
1
There are 1 best solutions below
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 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
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 # Hahtags
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.