Skip to Content
avatar image
-1
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.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 02 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 comment
    10|10000 characters needed characters exceeded