How to Build an Analytical Dashboard with SAP Lumira Based on SAP CATS Data

  • by Paulo Vitoriano, Freelance SAP Solution Architect
  • Sergei Peleshuk, SAP BI and HANA Architect
  • September 30, 2014
Walk through a number of practical steps for setting up a simple analytical dashboard with SAP Lumira. Learn how to complete visualizations in SAP Lumira for a number of real Cross-Application Time Sheet (CATS) key performance indicators (KPIs). Analyzing proper business performance indicators on an analytical dashboard helps you make appropriate business decisions faster. The approach described for setting up a dashboard on CATS KPIs can be applied to any other business area with SAP or non-SAP data sources.
Learning Objectives

By reading this article, you will learn how to:

  • Use SAP Lumira to set up KPIs into an analytical dashboard
Key Concept

An analytical dashboard provides a view on the key performance indicators (KPIs) of a particular business area. It focuses on gaining insights from a volume of data collected over time to understand what happened, why, and what changes should be made in the future to optimize processes and improve performance.

The time-reporting process with SAP Cross-Application Time Sheet (CATS) is a relatively simple exercise if viewed from a technical perspective. However, that process is only a tip of the iceberg for an organization’s project management team when it embarks on a "simple" time-writing project journey. Any organization that operates with a critical mass of business users involved in the time-writing process soon realizes many more challenges, such as a constant need to maintain the data quality, the discipline of business users, availability of well-documented procedures, and change management.

Based on our experience, the critical number of CATS time reporters that can force the business organization to switch from manual controls to automated controls via a number of developed key performance indicators (KPIs) is around 1,000 business users. If the internal or external rotation in the organization is high, that only complicates the overall picture. By internal rotation, we mean people moving between departments in the same legal entity (or country), whereas external rotation in a global organization is about people moving between countries. In addition, you have general rotations such as hiring new employees and employees leaving companies. The number of new hires or terminated employees also affects the master data maintenance workload.

Paulo Vitoriano

Paulo Vitoriano started his consulting career with Arthur Andersen Business Consulting in 1997. Since then, he has helped many global clients on SAP implementation projects, including DHL, Carlsberg, Nestle, Shell, AXA, Electrolux, and Maersk. During the last 18 years he has covered more than 10 end-to-end SAP implementations working on-site in 16 different countries. He has project experience with seven different oil and gas companies, and his current focus is on SAP IS-Oil and system integration. 

See more by this author

Sergei Peleshuk

Sergei Peleshuk has more than 15 years of experience implementing BI technologies for global clients in retail, distribution, fast-moving consumer goods (FMCG), oil, and gas industries. He has helped clients to design robust BI reporting and planning capabilities, leading them through all project phases: from analysis of requirements to building BI roadmaps, technical architecture, and efficient BI teams. Sergei is an expert in modern BI tools and technologies available on the market, including SAP Business Warehouse (SAP BW), SAP HANA, BusinessObjects, and SAP Lumira. Sergei maintains a business intelligence portal at

Sergei will be presenting at the upcoming SAPinsider HANA 2017 conference, June 14-16, 2017, in Amsterdam. For information on the event, click here.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.