Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Change formatting for Hidden Column in Pivot Table

Received Response
241
Views
24
Comments
Rank 4 - Community Specialist

I have created a pivot table and from pivot table options I have selected the attribute column to be hidden. Unfortunately it still has a small grey area that I can't hide or make it blank.

pastedImage_1.png

I have used a static text with html <style>.PTCC {background-color:white;border-top:white;border-bottom:white;border-left:white;border-right:white}</style> that helped "disappear" the header of the column as you can see but can't extend it to disappear all default formatting for the hidden attribute. Could anyone help me with this?

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.
«13

Answers

  • Rank 6 - Analytics Lead

    What does your pivot design look like? You could create a table view instead, creating 'pivotted' columns or buckets as i like to call them using a CASE WHEN construct.

    This will only be a realistic approach if you have a fixed and relatively small number of buckets that you want to include however.

    EDIT: And why is the column hidden in the first place?

  • Rank 4 - Community Specialist

    It is hidden just for cosmetic purposes, that's why I am asking if it is possible to hide it by code, as I tried all the possible built-in options with no result

    Yes, when I use the hidden option for an attribute in a normal table the column is disappeared together with every formatting but is this possible in a pivot table?

  • Rank 6 - Analytics Lead

    Not out-of-the-box afaik.

    If you want pixel perfect layout for printing you might want to consider using Custom Printing layouts / BI Publisher.

    See Creating Custom Print Layouts in OBIEE 11.1.1.7.0

  • Rank 8 - Analytics Strategist

    Could you not achieve what you need in a single column, without the need for a separate column?

  • Rank 4 - Community Specialist

    You mean to totally exclude the attribute from the table? No this is a totally different query unfortunately

  • Rank 8 - Analytics Strategist

    Now you have lost me - is it hidden because you have more than one analysis format; table, graph, pivot table; coming from the same data source?

    Or is it hidden because you are using it in the pivot table to give a sort order or a grouping, or it is part of logic in the non-hidden column?

    In short, can you explain why it is hidden?

    And also, can you explain why it would not suffice to put the column in question in the 'excluded' area rather than hiding it?

  • Rank 4 - Community Specialist

    If I put it in the "exluded" area then the results will be grouped and I don't want that. I want them to be split by the attribute.

    I want it to be hidden because for the requested report I had to split in 2 different tables and put them side by side and I don't want the attribute to be shown 2 times. I want the side by side tables to look like 1 even if they are not.

  • Rank 8 - Analytics Strategist

    Okay, but why can't you achieve it all in one analysis?

    Two reports might work today but they have a habit of getting slightly out of kilter and then the whole effect is ruined.

  • Rank 4 - Community Specialist

    Long story short because I have to apply different filters in two reports and I don't want to customise each measure by filtering it with 10 different filters because it kills the performance

  • Rank 6 - Analytics Lead
    Dimitris Karydis wrote:I want it to be hidden because for the requested report I had to split in 2 different tables and put them side by side and I don't want the attribute to be shown 2 times. I want the side by side tables to look like 1 even if they are not.

    Why can't you do it in one view? If you need to show measures side by side in the same analysis then your model should accommodate for such requirements. e.g. combining facts using conformed dimensions

Welcome!

It looks like you're new here. Sign in or register to get started.