OBIEE 11g : RPD Consistency Check

Consistency Check is a feature of the Administration Tool that checks whether a repository has met certain requirements, such as the following:

•  All logical columns are mapped directly or indirectly to one or more physical columns.
•  All logical dimension tables have a logical key.
•  All logical tables have a logical join relationship to another logical table.
•  There are at least two logical tables in the business model: a logical fact table and a logical dimension table. Both can map to the same physical table.
•  There are no circular logical join relationships.
•  A subject area exists for the business model.

You can check consistency for the entire repository or for a single object:

For entire repository: select File > Check Global Consistency.
For an individual repository object: select the object and then select Tools > Show Consistency Checker, or right-click the object and select Check Consistency. You can select multiple objects and check their consistency.

You can save a repository in offline mode even though the business models may be inconsistent.

Using the validaterpd Utility to Check Repository Consistency :

You can use the Oracle BI Server utility validaterpd to check the validity of all metadata objects in a repository on any platform supported by the Oracle BI Server. Running this utility performs the same validation checks as the Consistency Check Manager in the Administration Tool. Please note, don't forget to run bi-init.cmd / bi-init-sh before running this utility.

UtilityLocation: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

How to Run: validaterpd -R repository_name -O output_file_name [-P repository_password]

Here repository_password is optional, generally not recommended. Check output_file_name file for messages.

--Asif Pathan