Skip to Content

Analytic view or Calculation view

Dear Experts,

I have a scenario where we used 2 analytic views A,B and on top of them there are 2 calculation views C(on top of A) and D(on top of B).

Calculation views are created just for aggregation purpose.

In re-designing above scenario, Will it be good to use only calculation view including all the things from Analytic view and use aggregation as in previous calculation view?

Is there any additional benefit in terms of performance or etc. if we build Calculation view on top of Analytic view just for Aggregation purpose?

Thank you for your help.

Regards,

Raghavendra.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2015 at 06:04 PM

    Hi Raghavendra,

    Analytic View itself is an OLAP objects which means it doesn't allow you to activate it with out having measures defined. When you have measures, based on the attributes you select the measure values will be aggregated with the aggregation type you choose in semantics.

    If you have created calculation view just for aggregation purpose I would say you don't need calculation view.Look at the calculation view and identify what thing has been applied ans see if you can achieve everything in Analytic view, then go for just analytic view.

    Coming to which one performs better, it again depends.Based on my experience I would say Analytic View, however you can create both and see which one is performing better.

    Regards,

    Venkat N

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2015 at 12:44 PM

    Dear Raghavendra,

    I would recommend you to read the blog: The SAP HANA Engines?! . As Venkat explained above explore of the option of trying to achieve your outcome in Analytic view itself.

    Rgds,

    Mat.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.