SAP Lumira is a self-service data visualization and analytics tool that empowers business users to gain insights by exploring data in intuitive, interactive ways. One of the key strengths of Lumira is its ability to handle complex datasets and present them in a digestible, multi-level structure through hierarchical and drill-down views. These capabilities enable users to move from summary-level metrics to more granular, detail-level insights seamlessly.
A hierarchical view is a structured way of organizing data in levels, such as Region > Country > State > City or Year > Quarter > Month > Day. This structure mirrors how many businesses organize and analyze their operations.
Drill-down views allow users to interactively explore data by navigating from a higher-level summary to more detailed information. For example, a user might start with total sales by year and then drill down into quarters, then months, and finally into daily sales for a particular region.
Ensure that your dataset contains the necessary hierarchical dimensions. For example:
Load the dataset into SAP Lumira through supported sources such as SAP HANA, Excel, CSV, or SAP BW.
In the Prepare room of SAP Lumira:
This allows Lumira to recognize and structure the data accordingly for drill-down use.
In the Visualize room:
In the Compose room:
Publish your story to SAP Lumira Server, SAP BusinessObjects, or export it in PDF or HTML format. Shared stories retain drill-down functionality when accessed through supported platforms.
Hierarchical and drill-down views in SAP Lumira provide powerful ways to uncover insights within complex data. They enable users to intuitively explore data relationships, identify trends, and make informed decisions. By implementing these views effectively, organizations can unlock greater value from their data and foster a culture of data-driven decision-making.