In the latest release of Lumira, 1.29, there are many options to use for your source data. This blog will focus connecting to a Universe to create a new dataset. First ensure that the Universe Query Panel extension has been automatically installed after you install Lumira 1.29 Desktop edition. Click File > Extensions. You should see the following extension:
On the Home page, when you click Create New Document, you will be prompted to select your source for the data set. Select SAP Universe Query Panel and click Next. This connection is used to specifically access UNX universes.
The Universe connection pictured at the bottom of this screenshot is used for UNV universes. This operates in the traditional way by selecting the dimensions, measures and pre-filters from the universe. You cannot use the Query Panel with this method.
Using the Universe connection instead of the Universe Query Panel limits your ability to create advanced queries. An advantage when using the Query Panel is that you are able to filter the data on the database rather than in the application, thus improving the performance of your Lumira document. You can see here that using the Universe connection does not allow for you to limit the data (other than using predefined universe filters) that is returned from your query. It will return all data for the dimensions and measures that are used.
Continue with the SAP Universe Query Panel connection and click next. Enter your login credentials as pictured below:
You will then see a menu of available universes to connect to in your environment. For this demonstration I am going to use the STS Southeast Demo UNX universe.
The query panel appears allowing you to build the query you would like to utilize for your Lumira story. Here you can build complex queries including combined queries and sub queries. You also have the ability to preview your data by clicking the Refresh button prior to executing the query. Click Finish to execute the query.
You can then begin to create your visualization. In this example I am creating a simple Sales by Product chart. You have the option to drag the available dimensions/measure into their respective areas for the chart. Additionally you can click in the field, and a menu will show the available dimensions or measures for that particular field as pictured here.
I then limited the result set to only those products with Net Sales greater than $70M by clicking the filter symbol in the top left of the visualization. Note the options to apply the filter to the entire dataset or to limit it only to the current chart.
Once you have finished creating your visualization you can then save this to BI Platform. Click File à Save As and select SAP BI Platform. Connect to the platform and then save.
As you are probably aware, updates and additions are being made at a rapid pace with SAP Lumira. Please be sure to check back to see the next blog that discusses scheduling a Lumira document as well as additional features set to be added with the next version.
Read More about Lumira in these recent Blogs
- Linked Analysis in Lumira Discovery Welcome to the next blog …
- Utilizing a Union, Ranking, and Subquery in SAP's New BI …
- Hidden Analytics Gems You Already Own, but Nobody Told You …
- What the Tools Do and Which is Right for You …