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
@Sravan Komminedi, try these
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).
correct; you can easily achieve that with the steps mentioned earlier.
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.
can you double-check the parameters/filters in both the summary and drill-down? they have to be the same.
Yes Both are same!
your summary has two extra filters, the last two.
Yes, I have set those two(measure columns) as per your comment!
Any more inputs for me.
Hi We have requirements to Link both PPM Cost Transactions including Payables & Cost Management sources and reconcile the balances with GL balances. But we are unable to link CCID between GL & PPM transactions. Pl let us know if any one worked on OTBI with PPM & GL Reconciliations and share the details please
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
