SAP Lumira

0
116

SAP Lumira – Overlook at

SAP Lumira is belowstandn as a visual intelligence tool to make and visualize stories on dataset. It was earrestr belowstandn as Visual Intelligence tool where you could visualize data and make stories to provide graphical details of the data.

Data is entecrimson in Lumira as data set and you can apply filters, hierarchies, calculated columns to make documents on Lumira. You can select various charts like Bar charts, Pie charts, etc. to visualize the data effectively.

Example

You can place multiple charts on a story page to make presentation and can add images and text fields in these pages.

These stories can end up being published to other platforms using the publish option in the application −

  • SAP Business Object BI Platform
  • SAP Business Object Explorer
  • SAP Lumira Server
  • SAP HANA
  • SAP Commdevicey Ne2rk(SCN)

Features of Lumira

The key features of Lumira are as follows −

  • It permit’s you to pcrimsonict future away presently therecomes and forecast as per the changing market situations.

  • You can make data visualizations and stories from multiple data sources.

  • It helps you to adapt data to body organizational needs to make stories with visualizations.

  • You can share the visualizations on various platforms like SAP HANA, BO Explorer, Business Objects BI Platform, etc.

Key Terms of SAP Lumira Data Set

Data is entecrimson in Lumira as dataset and it contains Attributes/Dimensions and Measures.

  • Measure − Measures are degreatd as numerical data kinds. Example − Quantity sold, Rworkuallyue, Unit Price, Average cost, etc.

  • Attributes/Dimensions − Data containing details abaway presently there the measures is calintroduced Attributes or Dimensions in dataset. This represents the object on which analysis is done. Example − Customer, Product, Order, Time, Region, etc.

  • Hierarchies − Hierarchies are used for drilling the data to sub levels and degreats a mother or father-kid relationship. Example − Time Hierarchy, Region hierarchy.

  • Custom Calculations − You can make 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 brand new calculated column with name "Bonus" and can apply a calculation on Salary to get the value of this particular particular column.

SAP Key Terms

SAP Lumira – User Interface

When you login to Lumira Data visualization tool, presently there are four tabs at the top −

Prepare

Prepare is used to imslot data set in SAP Lumira. Data is thoroughly thoroughly cleansed and converted into appropriate measures or attributes for the reslots. You can add brand new custom calculations here.

Visualize

Visualize tab is used to add graphs and charts on the data thead wear has end up beingen imsloted and body organised in Prepare tab. You can add various attributes and measures to the Laend up beingl axis.

User Interface

Compose

The Compose tab is used to make stories and presentations, including background colours, titles, pictures, and text.

Share

The Share tab is used to publish your visualizations to various platforms or with various set of users in the BI Repository.

SAP Lumira – Data Sources

You can use various data sources with SAP Lumira to make a data set. A data source can end up being an Excel file, text file, cliptable, HANA Information Models, Universe maked in IDT/UDT, SQL query, connected to a BEx Query or an info provider.

Once you open up up SAP Lumira, go to File → New Data set

New Data Set

You can select from various Data sources to make a brand new data set.

Data Sources

SAP Lumira – Data Acquisition

The key steps in Data acquisition are as follows −

  • For data acquisition in SAP Lumira, make a brand new document thead wear will contain the data and visualization of acquicrimson data.

  • Next is to connect to a data source, which contains data for visualization.

  • Acquire the data to make a data set.

  • Data acquisition can end up being done from multiple compatible data sources to use in a single visualization or data analysis.

  • Once data is acquicrimson, it comes below the Prepare tab.

Data Acquisition

  • Select a Data Source. Enter the system details from where the data is to end up being acquicrimson and click Next.

Select Data Source

Connect Sap Hana

  • Select a Data source like SAP HANA View and click Next.

Select Sap Hana

  • Select Dimensions and Measures and click Create.

Select Dimensions Measures

Select Dimensions Measures1

SAP Lumira – Editing Acquicrimson Data

Let us find away how to edit the acquicrimson Data. Follow the steps given end up beinglow.

Step 1 − To edit data in SAP Lumira, go to the Data tab and click Edit Data Source from the menu.

Edit Data Step1

Step 2 − It will get you to Edit Data Source window, where you can again select Measures and Dimension.

Step 3 − You can check or uncheck any kind of kind of of the attributes and measures to add to data set and click the OK button.

Edit Data Step3

SAP Lumira – Viewing Connections

In SAP Lumira, you can check all the connections for an existing application and document bumociated with every connection and you can modify the data source for an existing connection.

To look at existing connections, near up all the data set.

Step 1 − Click New and near up the Add brand new data set window. In the left pane, it will show you the Connections option.

Viewing Connections Step1

Step 2 − A brand new window will open up up with a list of all the existing connections and bumociated documents. Click a connection and you can modify the target data source.

Viewing Connections Step2

SAP Lumira – Working With Excel Files

You can use an Excel file to make data set in SAP Lumira.

Follow the steps given end up beinglow.

Step 1 − Go to File → New (Create a data set).

File New

Step 2Select a Source − Load an Excel worksheet as a dataset and click the Next icon at the bottom part level.

Excel Worksheet

Step 3 − Bseriesse the path of .xls file. You have an option to select the initial series as column names. You can hide a particular column from .xls simply simply by selecting the Select All option.

Step 4 − You can click the Advance option to select a custom range. You can furthermore include hidden seriess and columns. Once appropriate options are selected, click the make button at the bottom part level.

Advance Option

Step 5 − All the data with integer values appear below Measures and all the columns appear below Dimensions. This data will come below the Prepare tab.

Prepare

Step 6 − Go to the Visualize tab at the top to make the visualization on top of the data set.

Visualize

SAP Lumira – Working with CSV Files

You can use a Text file as a data set like .csv file, .txt file, .log file, .prn file, .tsv file.

The following steps exeasy how to use a text file as a data set.

Step 1 − Go to File → New → Add New Dataset → Next.

Working CSV Files Step1

Step 2 − Select the path of csv file, for example an Excel file. You can set the initial series as column names. Select the separator as comma, tab, etc.

The Advance option can end up being used to select the Numend up beingr and Date format. Click the Create button to enter the data in the Prepare tab.

Working CSV Files Step2

Working CSV Files Steps

SAP Lumira – Connecting SAP HANA Views

You can connect to SAP HANA Modeling Views in SAP Lumira. This can end up being done in the following 2 ways −

  • Connect to SAP HANA
  • Download from SAP HANA

Connect to SAP HANA

step 1 − Go to File → New

Connect Sap Hana Step1

Step 2 − It will show you all the HANA Modeling Views thead wear have end up beingen currently used. Click the Next command button after selecting the option "Connect to SAP HANA". This will permit you to access the data in read mode and you can visualize the data in the form of charts.

You ought to belowstand the details of HANA system i.e. Host Name, Port Numend up beingr, User Name and Pbumword.

Step 3 − Click the Connect button.

Connect Sap Hana Step3

Step 4 − Select a SAP HANA look at and then Click Next.

Connect Sap Hana Step4

Step 5 − Select Measures and Dimensions you want to add to the data set and click the Create option.

Connect Sap Hana Step5

Step 6 − The data will end up being added to the Prepare tab.

SAP Lumira – Download from SAP HANA

The SAP Lumira – Offrange option permit’s you to duplicate the data locally and edit and manipulate the data to visualize in the charts.

Step 1 − Go to File → New

The Add brand new Dataset window will open up up. On the appropriate pane, the majority of currently used HANA Views, in Lumira data set, will end up being displayed.

Download From Sap Hana Step1

Step 2 − You ought to belowstand the details of HANA system i.e. Host Name, Port Numend up beingr, User Name and Pbumword. Click Connect.

Download From Sap Hana Step2

Note − You can connect via SSO. Select the Authenticate simply simply by Operating System (SSO) check package and click Connect.

Step 3 − Select a SAP HANA View and Click Next.

Download From Sap Hana Step3

Step 4 − Select Measures and Dimensions you want to add to the data set and click Create.

Download From Sap Hana Step4

The data will end up being added to the Prepare tab in SAP Lumira for visualization.

Specifying values for SAP HANA variables and inplace parameters

If you have used inplace variables while creating HANA Modeling Views thead wear will end up being imsloted to Lumira data set, you can specify a constant value for user parameter or a range of values.

SAP Lumira – Universe as a Data Source

You can use SAP Business Objects Universe as data source in Lumira. The various Universe thead wear are maked with .unx extension using Information Design Tool and .unv files maked in UDT and published to BI repository can end up being used as data source in SAP Lumira.

Connecting to a Universe Data Source

The following steps demonstrate how to connect to a Universal Data Source.

Step 1 − Go to File → New. Select the option Universe to connect to and download a dataset.

Connecting Universe Data Source Step1

Step 2 − Enter the Ccrimsonential details for Universe i.e. Host name, User Name, Pbumword, Authentication Type. Click the Connect command button.

Connecting Universe Data Source Step2

Step 3 − It will show you all Universe maked in Information Design Tool. Select the Universe you want to use as a dataset in Lumira and click Next.

Connecting Universe Data Source Step3

Step 4 − A brand new window will open up up. In this particular particular window, you can add the result objects and filters, which can end up being apprestd on the dataset as shown end up beinglow. Click the Next button at the bottom part level. If you want to depermite any kind of kind of of the object, click the mix icon in front part of the object.

Connecting Universe Data Source Step4

Step 5 − Acquicrimson dataset will come below Prepare tab in SAP Lumira with Dimensions and Measures degreatd at the Universe level.

Connecting Universe Data Source Step5

SAP Lumira – Using Query with SQL

SAP Lumira permit’s you to make dataset simply simply by using SQL query for target data source, manually. You can specify the source tables, columns, procedures, and functions to acquire data in SAP Lumira.

You can use JDBC dwaters for typical databases like Oracle, SQL Server, IBM DB2, Sybase, Teradata.

Database JDBC Dwater Name
Oracle ojdbc14.jar
Microgentle SQL Server sqljdbc4.jar
Teradata terajdbc4.jar and tdgssconfig.jar
Sybase jconn4.jar
IBM DB2

db2jcc.jar or db2cc.jar and

db2jcc_license_cu.jar for versions earrestr than 9.5

IBM Netezza nzjdbc.jar

Connecting to a Query with SQL Data Source

To connect to a database using SQL query to acquire data, you ought to have a great belowstanding of your database and great command over SQL.

You ought to have appropriate database dwaters instalintroduced for your middlebattlee, which permit the crestnt application to connect to middlebattlee and to database.

JDBC dwaters have to end up being instalintroduced for database middlebattlee for using SQL query. The access dwater is the .jar file. You can download this particular particular file from the vendor site and duplicate to the dwater folder in application path.

Given end up beinglow are the steps to connect to a query with SQL Data Source.

Step 1 − To use SQL query to make dataset, go to File → New.

Select the option Query with SQL to download a dataset and click Next.

Connecting to Query Step1

Step 2 − Select SQL query. All queries in green represent the dwaters, which are instalintroduced properly for middlebattlee.

Step 3 − Select database middlebattlee for target database and click Next.

Connecting to Query Step3

Step 4 − Enter the Login Ccrimsonentials, like host name, Instance numend up beingr, User name and Pbumword and click Connect as shown end up beinglow.

Connecting to Query Step4

Step 5 − In the left pane, it will show you all the Schemas and tables in the target database.

Select the target table and add to the Query panel. You can click the Prelook at option to see the data prelook at.

Connecting to Query Step5

Step 6 − You can use the SELECT statement only in the SQL editor to acquire data from database tables. Click Create to add the dataset to the Prepare tab. You can furthermore use “Select All” option, if you want to use all the columns or uncheck the package to remove any kind of kind of columns to dataset. Click Create.

Connecting to Query Step6

Specifying Query with SQL connection properconnects

Using SQL Query option furthermore permit’s you to make your own data provider, simply simply by manually entering the SQL for a target data source to acquire table data.

While using Query with SQL, connection information for the target database ought to end up being entecrimson and various connection properconnects can end up being used.

  • User Name − To connect with target database

  • Pbumword − To connect with target database

  • Server and Port name − of the target database

  • Database − Name of the database

You can select Advance options like −

  • Connection Pool Mode − To maintain connection workive

  • Pool timeaway presently there − Time duration to maintain connection workive in moments.

  • Array Fetch Size − to figure away numend up beingr of seriess to fetch from target database.

  • Array Bind Size − Larger bind array, more numend up beingr of seriess will end up being fetched.

  • Login Timeaway presently there − Time end up beingfore a connection attempts a timeaway presently there.

JDBC Dwater Properconnects

JDBC Dwater Properconnects

These are various connection properconnects, which can end up being degreatd while using query with SQL option in creating Lumira dataset.

SAP Lumira – Working Modes

You can use SAP Lumira for data visualization, creating charts and stories. Visualizations thead wear are maked in Lumira can end up being kept as private or you can furthermore share with others.

The following functions can end up being performed in SAP Lumira, once the dataset is maked −

  • Prepare the data for visualizations

  • Visualize data as charts and stories

  • Share visualizations and data sets

We will talk about these pages in the next three subsequent chapters.

SAP Lumira – Prepare Phase

Once data set is acquicrimson, it appears in Prepare tab. This data needs to end up being formatted end up beingfore charting and visualizations. Different kinds of formatting can end up being done on acquicrimson data set −

  • Data Cleansing
  • Create New Measures
  • Create Formula
  • Add New Dataset

Prepare tab has various panels thead wear can end up being used to perform these functions.

Prepare Tab Functions

Dimension and Measure Panel

It contains a list of all the dimensions and measures acquicrimson in the data set. The numend up beingr in front part of every object represents it’s data kind.

You can use various tools in this particular particular panel to edit the data objects and to add hierarchies.

Dimension Measure Panel

Dataset Selector

You can select end up beingtween multiple datasets or you can furthermore acquire a brand new dataset using this particular particular option.

Dataset Selector

Filter Bar

This represents filter apprestd to any kind of kind of dimension in dataset. To add a filter click on the icon in front part of dataset and click on Filter.

Filter Bar

How to add a brand new Calculated Measure

Go to the following screen, as shown here.

Add New Calculated Measure

  • Enter the brand new Measure name.
  • Enter the formula
  • Use function, if requicrimson, and click OK.

New Calculated Measure

New Calculated Measure will get added below measures tab in dimension and measure panel.

SAP Lumira – Visualize Phase

This is used to make various kind of charts and visualizations on the dataset available in Prepare tab. Main areas below Visualize tab are −

Visualize Phase

Dimensions and Measures Panel

On the left aspect, you have the dimensions and measures acquicrimson in the dataset and are available to make visualizations.

You can immediately drag the objects from this particular particular panel to the chart pane to make the charts on X and Y axes. At the top, you have Horizontal and Vertical Orientation to modify the display of objects in this particular particular panel.

Visualizations Dimensions Measures

Chart Canvas

This is used to make or modify a visualization. You can immediately drag attributes and measures to chart canvas or can add to chart makeer.

You can add various tools like −

  • Sorted simply simply by Dimensions
  • Add or Edit a ranking simply simply by measures
  • Clear Chart
  • Fit chart to frame
  • Reprompt
  • Refresh
  • Settings
  • Maximize
  • Undo
  • Redo

Chart Canvas

Visualization Tools

Let us see the various tools used for visualization.

Step 1 − Go to File → Preferences → Charts → Charts Canvas Layaway presently there

Visualization Tools

Step 2 − You can select Chart Style, Template, Font Zoom, etc.

Chart Picker

You can select various kinds of chart from this particular particular panel. You have an option to select various kinds of charts in Lumira.

Chart Picker

Chart Shelves

Chart Shelves are used to add measures and dimensions to a visualization.

Chart Shelves

SAP Lumira – Compose Phase

You can make various stories in SAP Lumira, in a presentation-style document using visualization, graphics and other customizations thead wear have end up beingen apprestd to the dataset.

You have to customise the compose tab once and you get multiple options to select an Infographic, Board or a Reslot.

Enter the name of the Story and click Create. You have various panels in Compose tab as shown in the screenshot.

Compose Phase

Content Panel

The left panel contains various kinds of content thead wear you can add to the story page. You can select any kind of kind of item and drag it to a section on the story page.

  • Dataset Selector
  • Story Selector
  • Prelook at
  • Filter Bar
  • Add Page and Depermite Page
  • Page Settings, Etc.

Content Panel

SAP Lumira – Share Phase

Once you are done with datasets, visualizations and stories, presently there is an option to exslot, print or publish all of all of them.

You have the following options to exslot datasets.

  • Exslot as File: you can save dataset as .csv or. xls file.

  • Publish to SAP HANA.

  • Publish to Explorer.

  • Publish to BI platform.

Exsloting Stories

You can exslot a story in PDF format.

Exsloting Stories

Exsloting Visualizations

You can exslot to a printer or can furthermore send in an email to a user.

SAP Lumira – New Document

Let us see how a document is maked and saved in SAP Lumira.

To make a brand new document, go to File → New.

Creating New Document

Select a Source to acquire the dataset or from currently used and click Next.

Saving Documents

After creating datasets, visualizations and stories in SAP Lumira, you can save a document locally. When you save a document, all the objects are saved with the document.

You can furthermore save a document to Lumira Cloud, SAP Lumira Edge server or SAP BI platform.

To save a document follow the steps given end up beinglow.

Step 1 − Go to File → Save As.

Saving Documents

Save Options

SAP Lumira – Creating Charts

In SAP Lumira, a chart can end up being maked simply simply by dragging measures and dimensions to the Chart Canvas in the central area below the Visualize tab.

To make a chart, presently there ought to end up being at minimumern one measure. When a dimension is added to the chart, it shows values based on the measures.

Adding a chart in Chart makeer

Follow the steps to add a chart.

Step 1 − In the Visualize tab, go to Chart Builder.

Step 2 − Select a chart kind thead wear you want to use in the Chart Builder. Bar Chart is the default chart kind, but you can select any kind of kind of chart from the list.

Creating Charts Step2

Step 3 − The next step is to select a measure and drag it to an axis on the Chart Canvas. You can check in chart where to add dimensions and measures.

Step 4 − You can click on ‘+’ sign to add a dimension or measure to a chart.

Step 5 − Select a dimension and drag it to the Chart Canvas. The text in the chart body guides you to the appropriate axis for the dimension.

Creating Charts Step5

Step 6 − You can furthermore add a filter to chart simply simply by clicking on filter option at the top.

Creating Charts Step6

Step 7 − Select the dimension on which you want to apply a filter and click OK.

Creating Charts Step7

SAP Lumira – Chart Types

There are various kinds of charts available in Lumira.

Comparison − These chart kinds are used to compare the difference end up beingtween values. Common comparison-kind charts are −

  • Bar Chart
  • Column Chart
  • Radar Chart
  • Area Chart
  • Heat map

Percentage − These are used to show percentage of parts in a chart. Common Percentage-kind charts are −

  • Pie Chart
  • Donut Chart
  • Tree
  • Funnel Chart

Correlation − These are used to show the relationship end up beingtween various values. Common chart kinds are −

  • Scatter Plot
  • Bubble Chart
  • Ne2rk Chart
  • Numeric Point
  • Tree

Trend − These are used to show the data patterns or achievable patterns. Common chart kinds are −

  • Line Chart
  • Waterfall Chart
  • Box Plot
  • Parallel Coordinates Chart

Geographic − These are used to present the map of a counattempt or gloend up being present in the analysis. Common chart kinds are −

  • Geo Bubble Chart
  • Geo Choroppermith Chart
  • Geo Pie Chart
  • Geo Map

Chart Types

SAP Lumira – Conditional Formatting

It is used to mention the critical data points in a chart simply simply by various values meeting specific condition. Multiple conditional formatting rules can end up being apprestd on measures or dimensions.

Conditional formatting can end up being apprestd on −

  • Bar and Column charts (other than 3D column charts)
  • Pie chart
  • Donut chart
  • Scatter chart
  • Bubble chart
  • Cross tab

Creating a Conditional Formatting Rule

To degreat a conditional formatting in a chart, it ought to have a measure value added to it.

The procedure is given end up beinglow.

  • Click the brand new Conditional formatting icon. It will open up up the rule editor package. Enter the name of rule editor.

  • Select Based on list to add a measure or a dimension. You can set multiple conditional formatting rules on a single measure or dimension.

  • The next step is to select an operator and add one or more values for condition.

Saving Charts

You can save a chart simply simply by clicking the Settings button. The available options are displayed.

Saving Charts

The various options available are −

  • Copy to Cliptable
  • Send simply simply by Mail
  • Duplicate

Copy to Cliptable − You can use the duplicate to cliptable option. Select the Exslot dimension and click OK.

Copy to Cliptable

You can paste this particular particular chart in any kind of kind of Document file, Paint, etc.

Send simply simply by mail − Select an Exslot dimension → OK. It will attach the chart in the mail and you have to enter the recipient email id.

Send simply simply by mail

Duplicate option will make a duplicate of the chart in same Visualization tab.

SAP Lumira – Preparing Data in Prepare Tab

Once data set is acquicrimson, it appears in Prepare tab. This data needs to end up being formatted end up beingfore charting and visualizations. Different kinds of formatting can end up being done on acquicrimson data set −

  • Data Cleansing
  • Create New Measures
  • Create Formula
  • Add New Dataset

Prepare tab has various panels thead wear can end up being used to perform these functions −

Prepare Tab

Dimension and Measure Panel

It contains a list of all the dimensions and measures acquicrimson in the data set. The numend up beingr in front part of every object represents it’s data kind.

You can use various tools in this particular particular panel to edit the data objects and to add hierarchies.

Dimension and Measure Panel List

Dataset Selector

You can select end up beingtween multiple datasets or you can furthermore acquire a brand new dataset using this particular particular option.

Select Multiple Datasets

Filter Bar

This represents a filter apprestd to any kind of kind of dimension in dataset. To add a filter, click the icon in front part of the dataset and select the option Filter.

Add Filter

How to add brand new Calculated Measure?

Step 1 − To add a brand new Calculated Measure, Select New Calculated Measure.

Calculated Measure Step1

Step 2 − brand new Measure name.

Step 3 − Enter the formula.

Step 4 − Use a function if requicrimson and click OK.

Calculated Measure Step2

A brand new Calculated Measure will end up being added below the measures tab in dimension and measure panel.

SAP Lumira – Editing Data

Go to the options tab in front part of every object and select the Edit option you want to perform.

Edit Data

Filtering Data in Columns and Charts

To filter a value in the Prepare tab, you can click the Options tab in front part of any kind of kind of object.

Step 1 − Go to Filter.

Filter Data Step1

Step 2 − In the filter option, you can select maintain only or Exclude values for a particular value.

Filter Data Step2

Step 3 − Here, only one value is selected. Accordingly, the visualization modifys below the Visualize tab.

Filter Data Step3

Step 4 − Once filter is apprestd, it will come in filter panel in the Prepare tab.

Filter Data Step4

Step 5 − It can end up being removed simply simply by clicking the x button in front part of the filter. In a similar way, you can apply filter on a chart in Visualize tab.

Step 6 − Click Add filter and select a dimension or a measure to add a filter to the chart. (No maintain only or Exclude values option while applying filters in a chart).

Filter Data Step6

SAP Lumira – Formatting Numend up beingrs & Dates

You can display numend up beingrs, date, time and various data kinds in multiple formats in SAP Lumira. You can furthermore add a custom symbol as prefix or suffix to any kind of kind of object.

To set the numend up beingrs and date follow the steps given end up beinglow −

Step 1 Go to Prepare tab → Dimension and Measure Panel → Options → Display formatting

Display formatting

You have multiple options −

  • Select a Value format
  • Choose a Display format
  • Select a Custom Symbol

Multiple Options

Step 2 − In case of prefix or suffix, maximum numend up beingr of charworkers is 256. You can furthermore convert data kind into one more.

Step 3 − In Prepare tab → Go to column minding → Options.

Column Heading Options

SAP Lumira – Enriching Data

Creating Hierarchies

This option can end up being used if the acquicrimson dataset contains data thead wear can end up being converted to hierarchies like Time hierarchy or Region hierarchy.

Hierarchies are used to display data at various granularity level and you can drill up/down at various levels for end up beingtter belowstanding of relationship end up beingtween objects.

Creating a Geography hierarchy

When the data is acquicrimson, the application looks for dimension containing location and present with an icon.

Step 1 − Click the icon in front part of a dimension. From the available options, select Create a Geographic hierarchy → By Names (this particular particular option is available only for string dimensions).

Creating Geography Hierarchy Step1

Step 2 − A brand new window will open up up with the name Geographical data → select the dimension to map to hierarchy. Click Confirm.

Example

Counattempt Cust_Name QTY PROD State
India Jack 1 Phone Haryana
England Jone 3 Tab Durham
India Andy 5 Phone Punjab
India Ana 2 Watch Chennai
England Tim 6 Tab Kent

Step 3 − If Region does not apply to the dataset, select None from the list.

Creating Geography Hierarchy Step3

Step 4 − It will show you, a list of all the analyzed values, Solved and Not Found. For all the solved values, it will make a hierarchy. Click Done.

Creating Geography Hierarchy Step4

You will observe the following −

  • Locations mapped exworkly are marked with green.

  • Locations with more than one achievable complement (for example, if more than one city named London was found) are marked with yellow.

  • Locations not found in the geographic database are marked with Red.

  • Hierarchy will end up being added below Geographical data.

Adding Hierarchy

Step 5 − To use this particular particular chart, select any kind of kind of Geo chart like Geo Bubble chart.

Step 6 − Add Counattempt to Geography and Measure to the chart. Select the value in the chart and you will get a drill option to the next level.

Creating Geography Hierarchy Step6

Step7 − If you click the Drill option, you will go to the next level and so on.

Creating Geography Hierarchy Step7

In a similar way, you can apply Time hierarchy.

Creating a Custom Hierarchy

You can make hierarchies using any kind of kind of available combination of dimensions in acquicrimson dataset.

Example

Category → Product Line → Product

Counattempt Cust_Name QTY PROD PROD Category
India Jack 1 Samsung Note 4 Phone
England Jone 3 XOLOQC800 Tab
India Andy 5 Apple6s Phone
India Ana 2 Titan Watch
England Tim 6 Lenovo A1000 Tab

Follow the steps given end up beinglow −

Step 1 − Select Category → Options → Create a Custom hierarchy

Creating Custom Hierarchy Step1

Step 2 − A brand new window will open up up. Enter the name of the hierarchy and select the other dimensions to add to the next levels. Click Create. The arseriess can end up being used to modify the level.

Creating Custom Hierarchy Step2

Step 3 − The Product hierarchy will end up being added below the Dimensions tab.

Creating Custom Hierarchy Step3

Step 4 − Add a Bar chart and then Add Category and QTY to measures.

Creating Custom Hierarchy Step4

Once you click the Category option, you will get an option to drill down to the next level (PROD).

Category Option

SAP Lumira – Working with Datasets

Adding Datasets

You can open up up multiple datasets in a single document and add dataset to a document.

The following steps will exeasy you how to add a data set.

Step 1 − Go to the Data pane at the top and select Add brand new Dataset.

Adding Datasets Step1

Step 2 − A brand new Dataset window will open up up. Select a Source and click Next.

Adding Datasets Step2

Step 3 − Click the Create button to add the dataset. To switch end up beingtween the dataset, Click the fall down button and select the dataset you want to work on.

Adding Datasets Step3

Merging Dataset

You can furthermore merge 2 datasets simply simply by using the Join operator.

Step 1 − Go to the Data pane at the top → Combine → Merge.

Merging Dataset Step1

To merge, note thead wear −

  • They ought to have the same key column.
  • Column with the same data kind can end up being merged.
  • All columns can end up being merged.

Step 2 − Once you click on Merge, it will show brand new window and compatible data kind. Select Merge kind and click Merge.

Merging Dataset Step2

All the columns will end up being merged and added to the measure and dimension panel.

SAP Lumira – Appending Datasets using Union Operator

You can use a Union operator to append 2 datasets.

Step 1 − Go to Data → Combine → Append.

Append Dataset Step1

Step 2 − A brand new window will open up up with Append data. To use append, both the tables ought to contain the same numend up beingr of columns and compatible data kinds. Only compatible data kinds can end up being appended.

Step 3 − Select various source dimension to apply a Union with target dimension.

Append Dataset Step2

If the selected dimension contains compatible data kind, the dimension can end up being appended. If both, the source and the target dimensions are various, a message appears, “Union cannot happen”.

Step 4 − Once you click Append, both the datasets are combined and this particular particular combined dataset contains the name of the very first dataset.

SAP Lumira – Visualizing Data

Creating Charts

In SAP Lumira, a chart can end up being maked simply simply by dragging measures and dimensions to the Chart Canvas in the central area in Visualize tab.

To make a chart, presently there ought to end up being at minimumern one measure. When a dimension is added to the chart, it shows values based on the measures.

Adding a chart in Chart makeer

To add a chart follow the steps given end up beinglow.

Step 1 − In the Visualize tab, go to Chart Builder.

Step 2 − Select a chart kind thead wear you want to use in the Chart Builder. Bar Chart is the default chart kind, but you can select any kind of kind of chart from the list.

Adding Chart Step2

Step 3 − The next step is to select a measure and drag it to an axis on the Chart Canvas. You can check in chart where to add dimensions and measures. You can click on ‘+’ sign to add a dimension or measure to a chart.

Step 4 − Select a dimension and drag it to the Chart Canvas. Text in the chart body guides you to the appropriate axis for the dimension.

Adding Chart Step4

Step 5 − You can furthermore add a filter to the chart simply simply by clicking the Filter option at the top.

Adding Chart Step5

Step 6 − Select the dimension to which you want to apply a filter and click OK.

Adding Chart Step6

Creating a Chart Directly using Chart Builder

In Lumira, you can fastly make a chart simply simply by dragging the objects immediately to chart area. To make a chart, the dataset ought to contain at minimumern one measure value.

When you make a chart in SAP Lumira, it can end up being used in compose and Share tab for the current session.

Step 1 − If you want to save the chart as document to use it permanently you have to go to File → Save.

Step 2 − Go to Visualize tab → Select a chart kind from the list of available charts and add to chart makeer.

Creating Chart Step2

Step 3 − Drag the Measures and Dimensions on axis of the chart. The text maked in the chart helps you to find away presently there which object is to end up being dragged to which axis.

Creating Chart Step3

Plotting Measures as a Dimension in a Chart

You can furthermore add measures as a dimension in SAP Lumira. To do this particular particular, add 2 or more measures as dimensions in the chart. This can end up being used to check how data is spread over multiple axis within a single chart.

Step 1 − Go to Visualize tab → drag measure to measure panel.

Plotting Measures Step1

Step 2 − Go to Settings and click use Measures as dimensions option.

Plotting Measures Step2

Once you select this particular particular option, measures are displayed as brand new measure dimension in Dimension panel.

Plotting Measures Steps

Step 3 − Now you see the Dimension axis, measures will end up being added to the dimensions panel.

Plotting Measures Step3

Example

Let us add a dimension to this particular particular chart and see how it works.

Visualize Chart

Now, if you go to settings and select measures as dimension option as mentioned above, it will divide the measures as per dimensions in separate charts.

Measures Dimensions

SAP Lumira – Legend Colors

You can modify the colour of charts in SAP Lumira. Follow the steps given end up beinglow.

Step 1 − To modify the colours, Go to File → Preferences.

Step 2 − A brand new window will open up up. Go to charts and you can select various colours as per the requirement.

Lumira Preferences Step2

Step 3 − You can furthermore modify the font zoom and template attribute as shown in the screenshot end up beinglow. Once you comppermite all the settings, click Done and the relevant modifys will end up being apprestd to the chart in Chart makeer.

Lumira Preferences Step3

Adding Custom Charts

To add custom charts in SAP Lumira, you can use SAP Lumira gentlebattlee makement kit SDK. You can add custom charts in SAP Lumira using VizPacker and these charts will end up being added to list of available charts in canvas.

SAP Lumira – Creating Stories

You can make various stories in SAP Lumira in presentation-style document using visualization, graphics and other customizations thead wear have end up beingen apprestd to the dataset.

You have to customise the compose tab once and you get multiple options to select an Infographic, Board or a Reslot.

Enter the name of the Story and click Create. You have various panels in Compose tab as shown in the screenshot.

Compose Tab

Content Panel

The left panel contains various kinds of content thead wear you can add to the story page. You can select any kind of kind of item and drag it to a section on the story page.

  • Dataset Selector
  • Story Selector
  • Prelook at
  • Filter Bar
  • Add Page and Depermite Page
  • Page Settings, Etc.

Left Content Panel

Creating Stories with Charts and Data

Step 1 − To make stories using chart, go to Compose and select a Blank Infographic. Click the Create button as shown in the screenshot end up beinglow.

Creating Stories Step1

In the left panel, you will get options to add Visualizations, Text, pictures, pictograms, etc.

Step 2 − To add multiple visualizations in a story, simply click on the + sign at the bottom part level pane.

Creating Stories Step2

Step 3 − Drag a chart you want to add, to the story.

Creating Stories Step3

Step 4 − Suppose you want to add 2 charts in your Lumira story. One simply simply by the Customer and other simply simply by the item. Drag one chart to Story area.

Step 5 − You can furthermore do page settings, Back ground colour, etc.

Step 6 − To add one more chart, go back to the Visualize tab and make modifys to the Chart Dimension and measure panel.

Step 7 − Go to Compose tab and select the next chart to end up being added. All Visualizations in Visualize tab will end up being shown below the left panel. You can make multiple visualizations to make stories.

Creating Stories Step7

Step 8 − At the top, you have an option to prelook at the story in desktop prelook at, tabpermit prelook at and mobile device. Click the Prelook at icon. To go back, click the Prelook at icon again.

Creating Stories Step8

SAP Lumira – Slideshows

You can furthermore make slideshows in SAP Lumira. To make a slide show follow the steps given end up beinglow.

Step 1 − Go to Compose → Slide Show → Create. You can select various kinds of charts Left, Right, Bottom, Top, etc.

Creating Slideshows Step1

Step 2 − Once you select the Slide show, it will add all the Visualizations in slide show automatically. You can furthermore drag the Visualization from left panel and add to the slide show.

Step 3 − On the appropriate aspect, you can do Page settings like background colour, background Image, etc.

Creating Slideshows Step3

Step 4 − You can click the Prelook at tab to see the prelook at or Add Page to add a page to this particular particular story.

Creating Slideshows Step4

SAP Lumira – Customizing Stories

You can furthermore make customised stories in SAP Lumira. To make customised stories, you can add various kinds of pages in a story.

Step 1 − To add a page click Add Page and select a page you want to add to story.

Step 2 − Drag the Visualization from left panel to the story. There are inbuilt images thead wear can end up being used in a story.

Step 3 − Go to Pictogram on the left aspect and it will show you all the available pictograms thead wear can end up being used in a story.

Create Customized Stories Step3

Step 4 − You can furthermore add images from local machine. Go to Pictures and click the + sign.

Step 5 − Select Imslot from local. Add the path of the image you want to imslot and click Open.

Create Customized Stories Step5

Lumira – Charts, Stories & Datasets

Once you are done with the datasets, visualizations and stories, presently there is an option to exslot, print or publish all of all of them.

Exslot Dataset as File

Step 1 − You can save dataset as .csv or. xls file.

Step 2 − To do this particular particular, go to the Share tab and select the dataset from the left panel. Go to File → Exslot As.

Exslot Dataset

You will get an option to save it as a .xls or .csv file.

Exsloting Stories

You can exslot a story in PDF format. You can furthermore select all pages to exslot or numend up beingr of pages in range option.

Exslot Story

Exsloting Visualizations in Email or Print

You can exslot to a printer or can furthermore send in an email to a user.

Step 1 − Go to options in a Visualization and click on Send simply simply by mail.

Exsloting Visualizations Step1

Step 2 − Choose an Exslot Size, Small, Medium or Large and Click OK.

Exsloting Visualizations Step2

Step 3 − To Print a Visualization, go to the Share tab → Select Visualizations and you will get an option to Print Visualization at the top.

Exsloting Visualizations Step3

Step 4 − You will get options below Printer like PDF, Send to One Note, etc.

Step 5 − You can furthermore select the Copies, Page, Size, Orientation and Layaway presently there below Print Visualization.

Exsloting Visualizations Step5

SAP Lumira – Publishing Datasets

To publish datasets to SAP HANA follow the procedure given end up beinglow.

Step 1 − Go to the Share tab and select the dataset to end up being published. Once you select the dataset, you will see all the options as shown in the screenshot given end up beinglow.

Publishing Datasets Step1

Step 2 − To publish to HANA, you have to note thead wear the only dataset is published to HANA server and not visualizations. Enter the details of HANA system i.e. Server, Instance, User Pbumword and click Connect.

You have an option to select a brand new Package and a View.

Publishing Datasets Step2

The dataset is published as brand new Analytic look at.

Publishing to the SAP Lumira Cloud

Step 1 − Go to Compose → Select the Dataset → Publish to SAP Lumira Cloud.

Publishing SAP Lumira Cloud Step1

Step 2 − Enter the user name and compalloweword and click Next.

Publishing SAP Lumira Cloud Step2

Publishing to the SAP Lumira Server

Step 1 − Go to Compose → Select the Dataset → Publish to SAP Lumira Server.

Publishing SAP Lumira Server Step1

Step 2 − Enter the Lumira Server Details i.e. User name and compalloweword and click Next.

Publishing SAP Lumira Server Step2

Publishing Datasets to Explorer

Step 1 − Go to Compose → Select Dataset from Left panel → Publish to Explorer.

Publishing Datasets Explorers Step1

Step 2 − Enter the details such as CMS server, User name and compalloweword and click Connect.

Publishing Datasets Explorers Step2

Publish to SAP Stream work

Step 1 − Go to Compose → Select Dataset from Left Panel → Publish to SAP Stream work.

Publishing SAP Stream Work Step1

Step 2 − Enter email and compalloweword and Click the login button.

Publishing SAP Stream Work Step2

SHARE
Previous articleAssembly
Next articleJenkins

NO COMMENTS

LEAVE A REPLY