OTBI_PIVOT_INDEX

melek cinar

Hi,

If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help.

Thank you.

Regards,

Melek

Rajasekhar Bandaru-Oracle

HI

Please review the given documentation link about the Pivot table in OTBI

https://docs.oracle.com/cd/E12096_01/books/AnyUser/PivotView.html

Nathan CCC

Hi Melek,

E12096 is the document for the very much older version 10 OBI.

In OTBI you are using version 12 OBI.

https://docs.oracle.com/middleware/12213/bisuite/docs.htm

The functionality may not have changed all that much but better to use the correct documents otherwise you may miss out on some of the great features that were introduced in 11g and 12c.

For example

Oracle® Fusion Middleware
User's Guide for Oracle Business Intelligence Enterprise Edition
12.2.1.3.0
E80922-02
November 2017

Editing Table and Pivot Table Views

https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-843DD4CA-B575-4752-82DE-831768C1215D.htm#biee0233