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

How to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard

Sravan Komminedi

Hi Team,

We are building a custom OTBI analysis in Fusion, need to know how to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard.

Please share any info. if anyone worked on the same requirement.

Regards,

Sravan

Find more posts tagged with

Oracle Fusion Analytics

Accepted answers

All comments

Rich Merkel

I have quite a bit of experience reconciling PPM vs GL. I'd be happy to setup some time with you over teams. Please send me a message with some of your availability. I work in EST timezone.

I found that we were able to achieve by using DFF's on projects that relate to the GL dimension in summary level as start. We can also further drill down to actual projects and then transactional data along with discrepancies/etc.

For example on our project/task we create DFF that relates to our secondary balancing segment. I use OTBI analysis (using both GL transactional balances and Project Revenues/Costs subject areas). I filter GL side as of a period, using a filter for net position accounts and P&L accounts (to represent running balance in GL). You can also do a comparison by month too.

ITD Balance (2).catalog

I'm attaching an analysis that I use. Please note that I'm sharing so you can see the design for a high level summary. But as I mentioned it is dependent on the project organization and project DFF's that may not be same at your organization.

Also the measure for revenue minus cost from the project subject area is based on the accounting periods in our system (they do differ in each year, so I need case formula). This case formula also handles where GL adjustment period is 14 and we need to look at GL as of adjustent period 14 vs project module ITD as of June.

Simliar method using multiple subject area you can also reconcile by transaction/etc

Raw Cost Difference Detail.catalog

Upcoming Event

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…

Top Leaders