Blogs / Business Intelligence / Data Discovery / SAP Lumira / Data Preparation in SAP Lumira Discovery

Data Preparation in SAP Lumira Discovery

Sep 11, 2017

SHARE

This is part of the SAP Lumira Discovery blog series.

SAP Lumira Discovery provides lot of data preparation options when you import the data.

Upon acquisition, SAP Lumira Discovery converts the data into a flat file structure (rows and columns). This makes it easier to combine data across multiple sources.

Once you complete the data acquisition, select the DataView option.

Data Preparation in SAP Lumira Discovery

Here, you would see the tabular data with following options:

Data Preparation in SAP Lumira Discovery
  1. Save – Save the document to the local repository or the BI Platform
  2. New Dataset – Ability to Import a combination of different data sources
Data Preparation in SAP Lumira Discovery
Note: Live connections have been disabled as data preparation options are available only for ‘imported’ data

3. Refresh – Perform a manual data refresh
4. Undo – Same as the generic Undo function
5. Redo – Same as the generic Redo function
6. Create Calculations – Option to create custom measures and dimensions
7. Merge Datasets – Perform simple joins (inner or left outer join) by adding columns
8. Append Datasets – Perform simple union by adding more rows of data
9. Link Datasets – Perform data blending
10. Grid – Detailed row level information
11. Facet – Summarized view of the information
12. Export as File – Option to export data as Excel or CSV
13. Measures – List of numeric field that can be aggregated. Upon right clicking a measure, we would get the following options as shown.

Data Preparation in SAP Lumira Discovery


14 .Dimensions – Fields in the columns which can be character, numeric, geo, date or time fields. Upon right clicking a dimension, we would get the following options (changes a bit based on the data type)

Data Preparation in SAP Lumira Discovery

15. Data Sources – List of all data sources

16. Dataset – List of all the measures and dimensions

17. Summary – Summary view of the data

In the subsequent series of SAP Lumira Discovery blogs, we shall see how to combine data from multiple sources, concatenate strings, build hierarchies, define custom groups, derive custom dimensions and measures, use formulae and more.

Interested to learn how to leverage SAP Lumira for your enterprise. Write to us by clicking here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!