OBIEE Group Columns on report

User_4ITW9

Hi guys.

Recentrly I've been doing some analysis on the reports our client has. And I found the following report behaviour and I really couldn't find how it was created.

Maybe you can give me some tips:

We have the following report:

On the criteria tab we have this:

That is a column group. I cant edited or check how it is created.

When we click on one of the weeks on the first image, the report displays two more fields. Giving more detail to it.

I couldn't find how to replicate this behavior and It would be great if some of you could point me to some direction.

Thank you guys.

Christian Berg-0racle

1.) "Analysis". Not "Report". A "report" is a BI Publisher object. Different technology.

2.) Which exact version?

3.) The "click on week" is called a drill-down which means that you drill down to the next - in this case lowest - level, which seems to be the day. That's standard functionality for any attribute column that's part of a dimensional hierarchy.

User_4ITW9

Sorry,  Analysis, you are right.

The drill down is a known functionality,  but what about the Group Column I described above?. The version is 11.1.1.7.1

Regards

Gianni Ceresa

Your "Groupo de columnas" is created because you have a column selector view in your analysis.

When you add a column selector to an analysis and enable it on a column, that given column is replaced in the "Criteria" tab by an column named 'Column Group (Default: <default column>)'.

The click behaviour is just as Christian said: your hierarchies in the RPD defines the drill down on a column.

That's exactly what you are dealing with, and the documentation cover it: https://docs.oracle.com/middleware/12211help/biee/es/bi.12211/e73374/GUID-E13B96B8-B8E5-47A5-9ECE-CCBAF28C5AF5.htm#biee0…  (it's the 12.2.1.1.0 doc, but it's the first one I found in Spanish explaining what the column selector view is and how it behave).

User_4ITW9

Great Gianni, thank you. I'll check it out.

Guillermo Bueno

I was intrigued about this and I found a blog that might help:

(es una verision diferente pero a mi me ayudo ver como se hace en esa version)

http://obieetraining11.blogspot.com/2012/08/obiee-11g-creating-column-selector-and.html

Christian Berg-0racle

Column selector and dimensional hierarchies are two different things. A column selector is just a visual tool which let's you change the column that's being used to render an analysis. Yes, you can change the granularity of the query with it, but dimensional hierarchies and drill-downs will still work as normal. Meaning when you display a week and you click on it, it will drill down to day. When you display a month and you drill down it goes to week and so on

User_4ITW9

This could be use full. Thank you!