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 ...
Get SAP HANA Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
