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

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Optimize FDI Workbook Performance Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in mind from the start. As a special…
AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…