Oracle Communities

Oracle Analytics and AI

Child Item

Ability to hide a column in Data Visualization

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): DTCC

Description (Required): Unable to hide a column in Data Visualization

Use Case and Business Need (Required): Business want to hide certain columns in the data visualizations to be hidden and they will unhide it on need basis.

Enhancement Request / Service Request: Enhancement

Find more posts tagged with

Delivered

Analysis and Data Visualization

Status: Delivered

Comments

Branden Pavol

I also have scenarios where I have an "ID" field that I need in the table for Data Actions but they don't need to be displayed in the view. In OBIEE, I would just add the column to the table and just hide it. I know this functionality exists because if you convert an OBIEE report to DV, it will do it but it can't be done on its own.

Jahnavi-Oracle

I have also faced situations while testing the analysis which can get the data from aggregate or detailed table depending on the column selected. So in order to force the analysis to hit the detail table but still show data at higher level, this feature of hiding would really be of good use.

Aleksander Miler

It's also useful when one wants to sort some table members by some hidden key but don't want to present that key (and use it for non standard sorting). There are many such situations (e.g. financial balance report when some report members must be presented in predefined order - in OBI EE we could add some additional column, fill it with sort number, sort table based on that column and then hide).

Bret Grinslade - Oracle Analytics-Oracle

If the value is a measure, have you tried using a tool tip to see if this gives you the sorting you need? While you may still want to hide it, it might help.

user13369048

https://community.oracle.com/products/oracleanalytics/discussion/comment/35949#Comment_35949

Totally agree

Marcelo Finkielsztein

This is what i do:

1) Modify the Data Font to size=1 (you need to *type* the "1", it will not be on the list of values)

2) Modify the Data Font colors to white over white (#ffffff over #ffffff)

3) Modify the column Display Header from "Auto" to "Custom" and replace its default title by a "k". (to make it narrower)

Results: there still is a column showing up; but more discrete than before.

HTH,

Marcelo Finkielsztein

Benjamin Arnulf-Oracle

Excellent idea. Added my vote.

Molly P

Hello, was this idea implemented? If not, when can we expect this? This is a need for our business as well.

Avinash Krishnaram-Oracle

Hello,

This is an active project in development currently scheduled for a 1H CY2025 release target.

Thanks,

Avinash

Gabby Rubin-Oracle

This one is currently planned for ~~November~~ January.