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.
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.
Like attribute view, analytic views can also be created from either the Quick Launch ...