Home > Design Studio, HANA > Persisting Data to Optimize Dashboard Performance

Persisting Data to Optimize Dashboard Performance


Design Studio leverages the speed of HANA and the flexibility of HTML5 to produce intuitive dashboards that cater to the user experience. One hurdle that can detract from that experience is sluggish load times. While HANA can process large amounts of data relatively quickly, the query execution times aren’t always negligible when implemented in a front-end analysis application.

A solution that can solve the problem of large query execution times is the Metric Mart. By storing the output of a query in a custom table and building a simple projection HANA model on top of it, we can reduce the load times by orders of magnitude. The solution is easy to implement and is completely automated once it has been configured.

Preparation
Start by creating a new package structure to store and organize the components of the solution. The five components required for the Metric Mart are:

1. Schema (.hdbschema)
2. Structure (.hdbdd)
3. Analytic View (HANA Model)
4. Stored Procedure (.hdbprocedure)
5. Scheduled Job (.xsjob)

To download full PDF and to Continue Reading…

Narjit About Narjit Aujla

Narjit is a business intelligence consultant specializing in dashboard development  and data  modeling. Narjit delivers customized SAP BusinessObjects solutions for  customers across all  industries. With Decision First Technologies, Narjit utilizes Web  Intelligence, Design Studio,  HANA Studio, and Information Design Tool.

Categories: Design Studio, HANA
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: