Universes that are created with .unx extension using Information Design Tool/.unv files created in UDT and published to BI repository can be used as data source in SAP Lumira.
Go to File → New → Click on Universe option to connect and to download a dataset.
You can also add measures as a dimension in SAP Lumira. To do this add two or more measures as dimensions in the chart. This can be used to check how data is spread over multiple axis in a single chart.
It is used to present map of country or globe present in the analysis. Common chart types are:
Filters are used to limit the data in Lumira Visualizations. You can pass various filter conditions to restrict data comes in visualizations and stories.
You can also merge two dataset by using Join operator.
Go to Data pane at the top → Combine → Merge
You can create custom calculations in Lumira data Visualization which are not available in data set or at database level.
Example : You have a “Salary” column in the data set, you can add a new calculated column with name “Bonus” and can apply a calculation on Salary to get the value of this column.
Select the dataset to be published. Once you select the dataset you will see the options to publish dataset to HANA. Only dataset is published to HANA server and not visualizations.
When data is acquired, application looks for dimension containing location and present with an icon.
Click on option icon in front of a dimension → Create a Geographic hierarchy → By Names (this option is available only for string dimensions).
New window will open with name Geographical data → select the dimension to map to hierarchy and click on Confirm.
Hierarchies are used to display data at different granularity level and you can drill up/down at different levels for better understanding of relationship between objects.
You can set the below formatting for an attribute or dimension −
Merge type defines the type of join. You can select from different join types – Inner join, outer join, etc.
When you perform an append and both source and target dimensions are different, message appears-Union cannot happen.
To create a slide show, go to Compose → Board → Create. You can select different types of charts Left, Right, Bottom, Top, etc.
By selecting option - “connect to SAP HANA”. This will allow you to access data in read mode and you can visualize data in charts.
This options allows you to copy the data locally and you can edit and manipulate the data to visualize in the charts.
Dimension and Measure Panel : It contains list of all dimensions and measures acquired in data set. Number in front of each object represents its data type. You can use different tools in this panel to edit the data objects and to add hierarchies.
Dataset Selector : You can select between multiple datasets or you can also acquire a new dataset using this option.
Filter Bar : This represents filter applied to any dimension in dataset. To add a filter click on the icon in front of dataset and click on Filter.
Go to Settings and click on use Measures as dimensions option. Once you select this option, measures are displayed as new measure dimension in Dimension panel.
You can also convert data type into another. In Prepare tab → Go to column heading → Options
When hierarchies are defined on dataset, you can use drill up or drill down option to move to next level.
You can use below data sources in SAP Lumira
You can use SAP Lumira software development kit SDK. You can add custom charts in SAP Lumira using VizPacker and these charts will be added to list of available charts in canvas.
This is used to create or modify a visualization. You can directly drag attributes and measures to chart canvas or can add to chart builder.You can add various tools like
You can create hierarchies using any available combination of dimensions in acquired dataset.
Conditional formatting can be applied on:
It is used to mention critical data points in a chart by different values meeting certain condition. Multiple conditional formatting rules can be applied on measures or dimensions.
You can also create customize stories in SAP Lumira. To create customize stories, you can add different types of pages in a story. To add a page click on Add Page and select a page you want to add to story.
Drag the Visualization from left panel to the story. You can also add images from local machine. Go to Pictures and click on + sign.
Let us say you want to create a custom hierarchy on Category → Product
Select Category → Options → Create a Custom hierarchy
New window will open. Enter the name of hierarchy and select the other dimensions to add to next levels and click on Create. Arrows can be used to change the level.
Prepare : This is used to import data set in SAP Lumira. Data cleansing is done and converted into the appropriate measures or attributes for the reports.
You can connect to SAP HANA Modeling views in SAP Lumira. You have 2 options −
Yes, on Advance option to select custom range. You can also include hidden rows and columns.
It allows you to open multiple datasets in a single document and you can add dataset to a document.
Go to Data pane at the top → Add new Dataset
To use SQL query to create dataset, go to file → New
Click on Query with SQL option to download a dataset and click on Next. JDBC drivers has to be installed for database middleware for using SQL query. The access driver is .jar files you can download from vendor site and copy to driver folder in application path.
Select SQL query, all queries in green presents drivers are installed properly for middleware. Select database middleware for target database and click on Next.
There are inbuilt images that can be used in a story. Go to Pictogram on left side and it will show you all the available pictograms that can be used in a story.
Yes, To Print a Visualization, go to Share tab → Select Visualizations and you will get an option to Print Visualization at the top.
Yes, you can export a visualization to a printer or can also send in an email to a user. Go to options in a Visualization and click on Send by mail.
Choose an Export Size-
Prepare : This is used to import data set in SAP Lumira. Data cleansing is done and converted into the appropriate measures or attributes for the reports. You can add new custom calculations here.
Visualize : This tab is used to add graphs and charts on the data that has been imported and organized in Prepare tab. You can add different attributes and measures to Label axis.
Compose : This is used to create stories and presentation, including background colors, titles, pictures, and text.
Share : This tab is used to publish your visualizations to different platforms or with different set of users in BI Repository.
Add new dataset → connect to SAP Business Warehouse
You can create different stories in SAP Lumira in presentation style document using visualization, graphics and other customizations that has been applied to dataset.Once you go to compose tab you get multiple options to select an Infographic, Board or a Report.
Yes, you can apply filter on a chart in Visualize tab. Click on Add filter and select aa dimension or a measure to add a filter to the chart.
You can save dataset as .csv or. xls file.
To do this go to Share tab and select the dataset from left panel. Go to File → Export As
To merge :
Yes, you can select between multiple datasets or you can also acquire a new dataset using this option.
Go to File → Preferences → Charts
Here you can define various properties for chart canvas.