Tag Archives: SAP Lumira Interview Questions For End Users

SAP Lumira Interview Questions and Answers

Our experts providing  SAP Lumira interview questions & Answers/Faqs can develop your carrier & knowledge to find the right job in a good MNC’s, doesn’t matter what kind of company you’re hired.

1.Why do we use SAP Lumira as BI tool?

It allows you to predict future outcomes and forecast as per changing market situations.

You can create data visualizations and stories from multiple data sources.

It helps you to adapt data to organizational needs to create stories with visualizations.

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

2.Why do we use custom calculations in data set?

You can create custom calculations in Lumira data Visualization which are not available in data set or at database level.


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.

3.What is the use of different tabs in Lumira?


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.


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.


This is used to create stories and presentation, including background colors, titles, pictures, and text.


This tab is used to publish your visualisations to different platforms or with different set of users in BI Repository.

4.How do you connect SAP Lumira to HANA Modelling views?

You can connect to SAP HANA Modelling views in SAP Lumira. You have 2 options –

Connect to SAP HANA
Download from SAP HANA

5.What is the difference between two options to connection to HANA Modelling views?

By selecting option – “connect to SAP HANA”. This will allow you to access data in read mode and you can visualise data in charts.

Download from SAP HANA

This options allows you to copy the data locally and you can edit and manipulate the data to visualise in the charts.

6.Can we add hidden columns from an excel spreadsheets to Lumira data set?

Yes, on Advance option to select custom range. You can also include hidden rows and columns.

7.When you acquire a data set, it comes under which of the tab to perform data cleansing and editing?


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.

8.How can you acquire data from an InfoProvider in Lumira data set?

Add new dataset ? connect to SAP Business Warehouse

9.When you use query with SQL option to acquire data set, you can see few of the connections in red and green. What is the meaning?

To use SQL query to create data set, 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 middle-ware 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 middle-ware. Select database middle-ware for target database and click on Next.

10.What are the different connection parameters that can be configured while using Query with SQL as data source?

Connection Pool Mode: To keep connection active

Pool timeout: Time duration to keep connection active in minutes.

Array Fetch Size: to determine number of rows to fetch from target database.

Array Bind Size: Larger bind array, more number of rows will be fetched.

Login Timeout: Time before a connection attempts a timeout.

JDBC Driver Properties

11.What are the different panels in Prepare tab for data cleansing and applying filters?

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.

Data set Selector

You can select between multiple data sets or you can also acquire a new data set using this option.

Filter Bar

This represents filter applied to any dimension in data set. To add a filter click on the icon in front of data set and click on Filter.

12.What is chart canvas?

This is used to create or modify a visualisation. You can directly drag attributes and measures to chart canvas or can add to chart builder.

You can add various tools like

Sorted by Dimensions
Add or Edit a ranking by measures
Clear Chart
Fit chart to frame
Re prompt

13.What are the different chart canvas properties that you can set in Lumira?

Chart Canvas Layout
Chart Style
Font Zoom, etc.

14.Where do you define properties for Chart Canvas?

Go to File ? Preferences ? Charts

Here you can define various properties for chart canvas.

15.What is the use of compose tab?

You can create different stories in SAP Lumira in presentation style document using visualisation, graphics and other customisation that has been applied to data set.

Once you go to compose tab you get multiple options to select an Info graphic, Board or a Report.

16.What are the different chart types in SAP Lumira?

Bar Chart
Column Chart
Radar Chart
Pie Chart
Donut Chart
Scatter Plot
Bubble Chart
Network Chart
And many more

17.Which chart types are best suited to show correlation between different values?

Scatter Plot
Bubble Chart
Network Chart
Numeric Point

18.What is the use of Geography charts in SAP Lumira? What are different chart types under this category?

It is used to present map of country or globe present in the analysis. Common chart types are –

Geo Bubble Chart
Geo Choropleth Chart
Geo Pie Chart
Geo Map

19.What is Conditional formatting?

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.

20.Which chart types support conditional formatting in SAP Lumira?

Conditional formatting can be applied on –

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

21.Can you add multiple data sets in SAP Lumira?

Yes, you can select between multiple data sets or you can also acquire a new data set using this option.

22.What is the use of filters?

Filters are used to limit the data in Lumira Visualisations. You can pass various filter conditions to restrict data comes in visualisations and stories.

23.Can we add filters in charts under Visualise tab?

Yes, you can apply filter on a chart in Visualise tab. Click on Add filter and select aa dimension or a measure to add a filter to the chart.

24.What is the use of display formatting option in Prepare tab?

You can set the below formatting for an attribute or dimension –

Select a Value format
Choose a Display format
Prefix or suffix

25.Can we convert data types in SAP Lumira for data set?

You can also convert data type into another. In Prepare tab ? Go to column heading ? Options

26.What is the use of hierarchies?

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.

27.What is geography hierarchy? How we can create geography hierarchy in data set?

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.

28.What is the meaning of Green, yellow and red while acquiring data for a hierarchy?

Locations mapped exactly are marked with green.

Locations with more than one possible match (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.

29.How do use hierarchies in the charts added to chart canvas in SAP Lumira?

When hierarchies are defined on data set, you can use drill up or drill down option to move to next level.

30.What is a custom hierarchy?

You can create hierarchies using any available combination of dimensions in acquired data set.

31.How do you create custom hierarchies in SAP Lumira? How do you define level in a custom hierarchy?

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.

32.How you can open multiple data set in a single Lumira document?

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 Data set

33.You have added multiple data sets in SAP Lumira. How do you perform merging of data sets?

You can also merge two data set by using Join operator.

Go to Data pane at the top ? Combine ? Merge

34.To perform a merge on multiple data sets, what are the conditions to perform a merge?

To merge

They should have same key column.

Column with same data type can be merged.

All columns will be merged.

35.What is the use of Merge type option in SAP Lumira?

Merge type defines the type of join. You can select from different join types – Inner join, outer join, etc.

36.What is the different between combine and Append data sets in Lumira?

Merge is used to apply different joins on data sets.

You can use Union operator to append two datasets.

37.How do you append data sets in Lumira?

To append data sets in Lumira, go to Data ? Combine ? Append

To use append, both tables should contain same number of columns and compatible data types. Only compatible data types can be appended.

38.You have acquired data sets with different number of columns and different data types, when you perform append on these data sets what will happen?

When you perform an append and both source and target dimensions are different, message appears-Union cannot happen.

39.If you want to see how data is spread over multiple axis in a single chart, which option you can use in Lumira?

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.

40.How do you use measures as dimensions in SAP Lumira charts?

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.

41.Is it possible to ass custom charts 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.

42.How do you create stories in SAP Lumira in left, right, top and bottom slide show formats in compose tab?

To create a slide show, go to Compose ? Board ? Create. You can select different types of charts Left, Right, Bottom, Top, etc.

43.Is it possible to create customise stories in SAP Lumira? How you can add company logos, custom images to Lumira presentations?

You can also create customise stories in SAP Lumira. To create customise 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 Visualisation from left panel to the story. You can also add images from local machine. Go to Pictures and click on + sign.

44.To see the available built in images to add to Lumira presentations, where you can add these to stories?

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.

45.What are the different formats you can export your data sets in SAP Lumira?

You can save data set as .csv or. xls file.

To do this go to Share tab and select the data set from left panel. Go to File ? Export As

46.Is it possible to print the visualisations? How can we print the visualisations in SAP Lumira?

Yes, To Print a Visualisation, go to Share tab ? Select Visualizations and you will get an option to Print Visualization at the top.

47.When you publish a data set to SAP HANA, all the visualisations that are created on data set are also published?

Select the data set to be published. Once you select the data set you will see the options to publish data set to HANA. Only data set is published to HANA server and not visualisations.

48.Can you send visualisation in email to other users? What are the different export sizes that can be used?

Yes, you can export a visualisation to a printer or can also send in an email to a user. Go to options in a Visualisation and click on Send by mail.

Choose an Export Size-

Small, Medium, Large

49.What are the different data sources you can use in Lumira to acquire data set?

You can use below data sources in SAP Lumira

Excel file as a data source
Working with CSV files
Connecting SAP HANA views
Universe as a data source
Using Query with SQL
Using SAP BW InfoProvider as data source

50.How do use Universes as data source to acquire data set in SAP Lumira?

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 data set…..For more  Click Here

For Course Content  Click Here

Top ↑