Creating analytic views
An analytic view is a modeling view in which the dimension tables are joined with the fact table that contains transaction data; that is, measures. Variables can be created in these analytic views. When a fact table is joined with dimension tables, it forms a cube-like structure, so analysis gives us meaningful joined data.
Getting ready
Similar to the attribute views, in order to create analytic views, we should have fact tables loaded with data in a schema. The _SYS_REPO user must have the SELECT authorization on the table with the GRANT option. Otherwise, the activation of the analytic view fails with an authorization error.
How to do it…
Like attribute view, analytic views can also be created from either the Quick Launch screen or the Navigator Pane. In this section, we will see how to create an analytic view from the Navigator Pane:
- Right-click on the package in the Navigator view and go to New | Analytic View as shown in the following screenshot:
- Provide a...
