As designers, developers, and creators of BI and analytics systems, the critical measure of our success is user engagement. If no one uses a system, it can provide no value.
This presentation looks at how you can use metadata to understand and enhance user engagement. Do you know who is using the system? Do end-users understand what the measures mean and where data comes from? If they don't, they may go straight to the source or use a different system.
The cornerstone of metadata management is a data dictionary. The data dictionary is to govern, publish, and share business definitions of data in the source systems, data warehouse, and OAC. This metadata can be enhanced by usage tracking, security audit, and lineage data to assist both end-users and the development teams better understand how metrics are calculated and the impact of any changes.
We will describe how you can use a combination of APEX, some advanced OAC scripting, and some good old SQL to provide a simple, robust, and extendable metadata solution. The objectives are:
1. describe how to metadata can increase the value of an analytics system;
2. talk through how to integrate APEX and OAC to provide a simple mechanism to store metadata
3. walk through using some OAC/OBIEE scripting to extract audit and security database to provide further visibility and governance of the system