SAP Lumira Interview Questions and Answers

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.

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 colours, 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.

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 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.

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

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.

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

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

• Chart Canvas Layout
• Chart Style
• Template
• Font Zoom, etc.

Go to File → Preferences → Charts

Here you can define various properties for chart canvas.

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.

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

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

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

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.

Conditional formatting can be applied on −

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

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 set the below formatting for an attribute or dimension −

• Select a Value format
• Choose a Display format
• Prefix or suffix

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.

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.

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.

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

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

Merge is used to apply different joins on datasets.

You can use Union operator to append two datasets.

To append datasets 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.

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 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.

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

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

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.

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- Small, Medium, Large

You can use below data sources in SAP Lumira

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

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.