Skip to Content
avatar image
Former Member

Best Practice - Creating HANA Views and Webi reports

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

30 reports created on HANA Views, most reports have been built directly on a single HANA View per report.

There are 12 universes but these are not being used for all reports (?), in some instances, one universe per report.

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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 01, 2018 at 03:09 AM

    Regarding Point 1 & 2, I believer this will depend on the requirement of the report

    Point 3. If possible, complex calculations need to pushed at the DB level as much as possible. If the calculation is going to be used in more than once, then its best done at the DB level - this saves development effort and also helps in report performance

    Point 4. For this you can suggest for creation of prompt for 'Location' and re-use same report, saving on development & maintenance efforts and storage space for the reports.

    - Sujit

    PS. to answer your core question - the activities you have listed are definitely not the best practice for WebI/HANA development. thanks.

    Add comment
    10|10000 characters needed characters exceeded