O'Reilly logo

Oracle Business Intelligence Enterprise Edition 12c - second Edition by Haroun Khan, Christian Screen, Adrian Ward

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Additional data

The preceding tables are all you need to store the usage, but to create effective dashboards of the actually usage, you will need additional data, for example, a date table, a table of time, a table of dashboards, pages, and of users.

The W_USAGE_TRACKING table is nearly identical to the capture table, except that we add extra fields. One of these fields is DATE_WID. This is so that the table can be linked to our standard W_DATE_D table. We add indexes to the table, on the date_wid field, and on the fields that will be filtered, such as USER_NAME and SAW_DASHBOARD. An additional task could be to create a day-level summary table that calculates performance measures for the day and will be joined to the W_DATE_D table, therefore enabling ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required