OBIEE nesting

mmajdana1

Hi,

i hope i will be able to explain my issue.

I am using OBIEE 12 c and this is what I need to do.

I create pivot table and drag rows and columns, however i need to have a bit detailed column under my column that is already there depending on a value from fact table.

But not for every value from my column, just some of the values.

Measure is count. For example ,  every value count is 3, i need to separate only value2 by its groups.  I know i can do it by drill or some other way in another report, but sadly this is the way they want it if is anyway possible.

I will try to write it down under this post,.

                       

               COLUMN.value 1                             COLUMN.value2                                                  COLUMN.value3

               COLUMN.value 1          detailvalue2    detailvalue2  detailvalue2                                COLUMN.value3

ROW 1           3                                  1                      1                      1                                                   3

Martin van Donselaar

Not sure if I understand your problem correctly but I think you might want to use hierarchical columns?

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-3383503F-FBDA-4EB4-99B6-C2E7C3B5F24B.htm#create_manage_dim

https://www.rittmanmead.com/blog/2010/07/obiee-11gr1-hierarchical-columns-and-enhancements-to-pivot-table-views/

[Deleted User]

Probably one of those "Excel requirements" again

Martin van Donselaar

My thoughts exactly :-)

Robert Angel

I am not following your precise requirement either, but if hierarchical columns is not what you are looking for with its asymmetric 'drilling' then possibly you might want to look into using 'Bins' or case logic to create groupings for your purpose, and have the custom grouped analysis as the target of your drill.

Robert Angel

Also - if this 'Bombay mix' grouping is a genuine corporate business need (sic) then I would create it as a new dimension in the business model / presentation layers and keep the case logic in the rpd.