Skip to Content
avatar image
Former Member

Tables Vs. Attribute Views

I have to create an analytical view which has to be linked to 10 different dimensional tables. My question is should I use the dimensional tables directly or should I create attribute views for each dimension and then use them in the view. Do we have any performance gain in choosing one over another?

Thanks.

Purnima

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 14, 2015 at 01:49 AM

    Dear Purnima,

    Joins in the Attribute is executed in the OLAP engine of the HANA database. In order to make attibute reusual with other Analytical view you should keep them independent. You should join them at the logical view.

    Hope this should help!!!!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Purnima,

      Using attribute view will be help you in an clean approach and will be more performance effective.

      Hope this further clarifiies.

  • avatar image
    Former Member
    Oct 15, 2015 at 01:57 PM

    hi Purnima Sharma


    We can use 10 dimension tables directly in analytic view or we can use attribute views directly in analytic view. The analytic view supports both master data(i.e.,dimension data) and as well as transaction data.

    Generally an, Analytic views are the multidimensional views or OLAP cubes using analytic view you analyze values from a single fact table that is based on the related attributes from the data foundation and attribute views.

    Attribute view also support 10 dimension tables directly.


    Regards

    khaga

    Add comment
    10|10000 characters needed characters exceeded