Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Cloud and Server

How to Pivot the record and dynamically include the columns

Question

Views

Comments

User_C0O9W Rank 1 - Community Starter

July 2022 edited August 2024 in Oracle Analytics Cloud and Server

Hi,

Am BI resource and new to Oracle. I have a requirement to create a view for reporting.

1.png

2.png

3.png

View column template is attached. Product and Item level records are stored in row level in DB tables. But for reporting, I need to display the Product and Item level at Column level (From column E) and based on Product count and Item count, the column should get included dynamically in view. Please suggest to achieve this logic.

Thank you!

Tagged:

Oracle Analytics Cloud and Server

Welcome!

Quick Links

Categories

How to Pivot the record and dynamically include the columns

Welcome!