Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 5 · OTBI and subject areas
Security in OTBI: it is already applied
Lesson 50 of 177 · 2 min
OTBI honours data security automatically. The subject area applies the reader's own ledger, business unit and organization access, and it does so without you writing anything. That is its main advantage over a hand-written query, and it is worth stating in those terms when somebody asks why the analysis was not built in BI Publisher. One analysis, shared with forty people, showing each of them exactly their own rows — and no possibility of a filter being forgotten, because the filter is not yours to forget. AND IT IS THE REASON TWO USERS LEGITIMATELY SEE DIFFERENT NUMBERS. This arrives as a defect report roughly once per implementation: two managers open the same dashboard, get different totals, and conclude the system is broken. It is working exactly as designed, and the answer is a sentence about data security rather than an investigation. Say it BEFORE the dashboard is published, not after.…
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