Creating attribute views

Attribute views are similar to dimensions, but the only difference is that attribute views are reusable components as they are object-oriented throughout the information modeling. In simple terms, these are views on one or multiple tables that can be reused for multiple purposes.

For example, the attribute view Customers can show Customer Code, Customer Name, Customer City and other Customer master data. This attribute view can be used in both analytic and calculation views based on the relevance. Generally, attribute views represent the dimension data (master data). But technically, there are no limitations or restrictions as it's definitely possible to create attribute views on transactional data. This recipe explains how to create attribute views.

Getting ready

In order to create attribute views, we must have a database table readily available. We must also possess the MODELER role and SELECT authorization on the schema from which we are accessing the tables. In...