I have noticed so many questions flowing around BusinessObjects Audit reporting and Metadata reporting for a quite long time in SCN. The intention of this blog is to explain the basics and the major difference between each of them.
To start with an introduction, Auditing is predominantly used to get the statistics about the BusinessObjects deployment by providing more insights on usage metrics of the system where as metadata reporting is used to get the real-time information about what is available in BusinessObjects repository.
Some of the metrics from Audit database
Metrics which you can get from CMS database using Query builder (Metadata reporting)
The below table could help you to distinguish the major differences
Category | Audit reporting | Metadata reporting |
---|---|---|
Nature of data | The information stored in Audit tables is historical in nature. | Repository tables contains real-time information about BI contents which is transactional (No history) in nature. |
Configuration | Audit database configuration is not mandatory during installation. We can continue to use the system even without auditing and It can be configured as on when it is required. | It is mandatory to Configure the CMS database during installation without which installation will not succeed. |
Direct SQL access | Data available with in Audit tables can be queried directly using traditional SQL. | Direct access to CMS tables is not recommended as they are encrypted. We need to use Query builder to get the required information. |
Universe and reports | Out of box and As-Is sample of universe & reports are available in BO 3.x and BI 4.x respectively | We need to develop the universe and associated reports from the scratch based on the requirement. |
Information availability | Data available within Audit tables is not real-time and is based on the parameter - “CMS Polling interval” | Data available in CMS tables are real-time in nature and they get updated as soon as the BI content gets added/modified/deleted. |
Data retention and purging | We can purge data available within Audit tables based on their age | Not possible. But the inconsistencies between CMS database and FRS can be removed using Repository Diagnostics Tool. |
Hope this blog is interesting.
References
BusinessObjects Query builder - Basics
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 |