SAP BI Blog

I recently had the opportunity to work on a dashboard project for a local Atlanta company. The scope of the project was simple, produce a report that allows users to compare key metrics within different levels of a single hierarchy. There were 5 different levels of the hierarchy and each level had to aggregate all values for that node. The data source was a well groomed corporate metrics mart. At first glance this appeared to be an easy task. There were no issues generating the SQL required for the metrics or KPIs. However, the volume of records that had to be projected into 16 different line charts, each having 10+ series, proved to be too much for flash and SAP Dashboards. Before you pass judgment, you should know that we used the most efficient design possible. Every record and column was used in the charts, no more, no less. In addition, Excel was not used to calculate anything. With that said, the render time…

View original post 822 more words

Categories: Uncategorized
  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: