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

New Events

Analytics & AI Data Platform- Oracle AI and Analytics Leaders Meeting
Customers are encouraged to join this quarterly virtual meeting to hear the latest updates from Oracle Product Strategy and Product Management. There will be time at the end to network with your peers and connect with other customers who are turning their data into actionable insights with Oracle Analytics and Oracle AI…
Oracle AI Data Platform - Turn enterprise data into AI-driven business value with Oracle and Vertice
Register today! Description: Enterprise AI initiatives need more than a promising use case. They need trusted data, the right business context, and governance from the start. Join Oracle and Vertice to explore how organizations can bring these elements together to move AI use cases into production In this webinar, Oracle…
Analytics - Fusion Data Intelligence HCM Release 26R3
Join the FDI HCM Product Management Team in this live webinar to go over the topics related to Release 26R3 Agentic Capabilities Fusion Agents & Agentic Apps FDI MCP Tools OAC Data Agents delivered via FDI Content Library Workforce Scheduling - New Subject Area Learning - Analytical Currency, E-learning,…