Change formatting for Hidden Column in Pivot Table

Dimitris Karydis

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.

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

Martin van Donselaar

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?

Dimitris Karydis

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?

Martin van Donselaar

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

Robert Angel

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

Dimitris Karydis

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

Robert Angel

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?

Dimitris Karydis

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.

Robert Angel

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.

Dimitris Karydis

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

Martin van Donselaar

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