nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

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

Find more posts tagged with

pivot

Reporting

OTBI

Customizing Reports

Sample Reports

Comments

Rajasekhar Bandaru-Oracle

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

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: FDI Security & Deep Dive into GL Segment Security. We are revisiting FDI Security - a top topic requested by our Office Hours attendees. We will begin with an overview of key security concepts and how security is managed in FDI. We will then dive deeper into GL Segment Security across Fusion and FDI…
OCI Enterprise AI - Product Roadmap Update October 2026
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…