O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

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

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 ...

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