Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 5 · OTBI and subject areas
Calculations, bins and hierarchies
Lesson 48 of 177 · 2 min
A derived column has to stay correct when the data changes shape, and that is the whole difficulty. Write calculations against MEASURES, not against displayed values. A margin percentage computed as one displayed column divided by another is correct on the row and wrong on the total, because the total of a ratio is not the ratio of the totals. Compute the ratio from the aggregated measures instead — sum divided by sum — and it is right at every level. This single mistake accounts for most "the total does not match" complaints in OTBI. Guard every division. A denominator that is zero or null on one row produces an error or a blank that propagates through the analysis, and it will happen the first month a new cost centre exists with no activity. Bins turn a continuous measure into readable bands — ageing buckets, size ranges — and the…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.
In this module: Module 5 · OTBI and subject areas
- 1What a subject area is
- 2Finding the right subject area
- 3Building an analysis
- 4Joins across subject areas, and when you cannot
- 5Calculations, bins and hierarchies
- 6Dashboards and prompts
- 7Security in OTBI: it is already applied
- 8Real-time versus reported figures
- 9Performance and the analysis nobody can run
- 10When OTBI is the wrong answer
- 11Lab briefing · An analysis and a dashboard