Identity the three advantages of the BI Server metadata repository.
A.
Mapping of federated data sources to one logical object
B.
Ability to change physical sources without losing reports
C.
Little changes in the physical layer to shift from development to production environment
D.
Three layers support the highest level of security
Explanation:
A: OBIEE Federated Repository
Instead of moving data in to a single database, OBIEE BI Administration can access multiple
databases and create a single federated repository.OBIEE BI Answer uses this federated
repository and build the ad-hoc reports and dashboards.
D: Repository Metadata Consists of 3 Layers
* The Physical Layer (Schema)
* The Business Model and Mapping Layer
* The Presentation LayerNote:
B) is incorrect? What if the writeback is enabled within RPD?
repository security(data access) consists of below three parts:
(1)object permission : read, read/write, no access on the object of presentation and database
(2)row-level permission( data filter): filter row-level data on Presentation, BMM objects. filter row-level data on database can only be applied VIA FGAC.
(3)query limit : time duration restriction, max row returned, max time, write back on database.
presentation server security(BI function and BI object permission) consists of 3 channel
(1) VIA EM->manage policy and manage application role on weblogic domain: manage domain component privilege like repository building.
(2) VIA OBIEE REPORT-> administration -> manage privilege: manage bi component privilege like Sorecard builder
(3) VIA OBIEE REPORT-> catalog -> MORE option -> permission: manage catalog object privilege like analysis read/write/execute/delete
One typical story is: I create one application role “ChicagoSalesBIBuilder” which has the grant of “BIAuthor” during (1), and remove the ScoreCard creation privilege during (2), and remove the write execution of “Salary” analysis during (3)
A, C and D