Skip to Content
author's profile photo Former Member
Former Member

SAP HANA Views best practice

Questions I hope that can be answered quickly, is this best practice?

30 reports created on HANA Views, each report has been built directly on a single HANA View per report

There is a universe but this is not being used for reports (?)

Complex calculations and measures are held at report level, each report has any number of these and they are manually replicated across reports

Report variances have been created, new report for each version even though only location is different

My understanding is that this is not best practice, it is anything but, however need input from someone who knows more.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2018 at 12:19 PM

    SAP recommends that there should be WEBI reports on top of HANA Calculation View. The universe should not contain more than one HANA Calculation view. You can build any number of reports on top of that. Calculation view itself contains all complex level of calculations. Its always recommended that lower the complexity & number of calculations & variables in a WEBI report, better the performance.

    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.