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

SantoshKumarBhairi

@Sravan Komminedi, try these

1. pick-up a measure from your summary report
2. navigate to its column properties / interaction / value 'Primary Interaction'
3. select Action Links / click + / select your detailed/drill-down reports
4. make sure measure from (1) is set to 'is prompted' and the rest of the filters/prompts should be the same in both the summary and Drilldown reports.

Sravan Komminedi

Hi Santosh,

My requirement was to show supplier wise count of invoices which are on hold and not on hold.(see this as Master Dashbaord)

need to apply Drill on the counts so once user clicks those, we need to show respective Hold or not on hold invoices and their details(see this as Detail Dashboard).

Regards,

Sravan

SantoshKumarBhairi

correct; you can easily achieve that with the steps mentioned earlier.

Sravan Komminedi

Hi Santosh,

I applied the same way, but not working as expected.

Expectation - To see only 10 invoice details.

Actual - Getting total 11 invoice details instead of 10.

Regards,

Sravan

SantoshKumarBhairi

can you double-check the parameters/filters in both the summary and drill-down? they have to be the same.

Sravan Komminedi

Yes Both are same!

SantoshKumarBhairi

your summary has two extra filters, the last two.

Sravan Komminedi

Yes, I have set those two(measure columns) as per your comment!

1. "make sure measure from (1) is set to 'is prompted' and the rest of the filters/prompts should be the same in both the summary and Drilldown reports."

Sravan Komminedi

Hi Santosh,

Any more inputs for me.

Regards,

Sravan