Interview Questions.

Q1. How Do Use Universes As Data Source To Acquire Dataset In Sap Lumira?

Universes which can be created with .Unx extension the use of Information Design Tool/.Unv documents created in UDT and posted to BI repository may be used as data source in SAP Lumira.

Go to File → New → Click on Universe option to join and to download a dataset.

Q2. 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 upload measures as a measurement in SAP Lumira. To do that upload two or extra measures as dimensions inside the chart. This may be used to check how facts is spread over a couple of axis in a single chart.

Q3. What Is The Use Of Geography Charts In Sap Lumira? What Are Different Chart Types Under This Category?

It is used to give map of u . S . Or globe gift in the evaluation. Common chart types are:

Geo Bubble Chart

Geo Choropleth Chart

Geo Pie Chart

Geo Map

Q4. What Is The Use Of Filters?

Filters are used to restrict the facts in Lumira Visualizations. You can pass numerous clear out situations to restrict facts comes in visualizations and testimonies.

Q5. How Do You Append Datasets In Lumira?

To append datasets in Lumira, visit Data → Combine → Append

To use append, both tables have to include identical range of columns and well matched information sorts. Only well matched data kinds can be appended.

Q6. You Have Added Multiple Data Sets In Sap Lumira. How Do You Perform Merging Of Datasets?

You also can merge  dataset by using Join operator.

Go to Data pane at the top → Combine → Merge

Q7. Why Do We Use Custom Calculations In Data Set?

You can create custom calculations in Lumira facts Visualization which are not to be had in facts set or at database stage.

Example : You have a “Salary” column in the statistics set, you may upload a new calculated column with call “Bonus” and might observe a calculation on Salary to get the cost of this column.

Q8. What Are The Different Chart Canvas Properties That You Can Set In Lumira?

Chart Canvas Layout

Chart Style

Template

Font Zoom, and many others.

Q9. When You Publish A Dataset To Sap Hana, All The Visualizations That Are Created On Dataset Are Also Published?

Select the dataset to be posted. Once you pick the dataset you will see the alternatives to publish dataset to HANA. Only dataset is published to HANA server and not visualizations.

Q10. What Is Geography Hierarchy? How We Can Create Geography Hierarchy In Dataset?

When records is obtained, application seems for measurement containing region and present with an icon.

Click on alternative icon in the front of a measurement → Create a Geographic hierarchy → By Names (this feature is to be had simplest for string dimensions).

New window will open with call Geographical records → select the size to map to hierarchy and click on on Confirm.

Q11. What Is The Use Of Hierarchies?

Hierarchies are used to show statistics at unique granularity stage and you could drill up/down at exceptional tiers for better information of dating between gadgets.

Q12. What Is The Use Of Display Formatting Option In Prepare Tab?

You can set the below formatting for an characteristic or measurement −

Select a Value format

Choose a Display format

Prefix or suffix

Q13. What Is The Use Of Merge Type Option In Sap Lumira?

Merge kind defines the kind of be a part of. You can pick out from unique be part of sorts – Inner join, outer join, etc.

Q14. You Have Acquired Datasets With Different Number Of Columns And Different Data Types, When You Perform Append On These Datasets What Will Happen?

When you perform an append and both source and target dimensions are one-of-a-kind, message seems-Union can't appear.

Q15. 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 pick special styles of charts Left, Right, Bottom, Top, and so forth.

Q16. What Is The Difference Between Two Options To Connection To Hana Modeling Views?

By selecting option - “connect to SAP HANA”. This will will let you get entry to data in examine mode and you could visualize facts in charts.

Download from SAP HANA

This alternatives lets in you to duplicate the facts regionally and you can edit and manipulate the records to visualize in the charts.

Q17. What Are The Different Panels In Prepare Tab For Data Cleansing And Applying Filters?

Dimension and Measure Panel : It carries listing of all dimensions and measures received in data set. Number in front of each item represents its information kind. You can use one-of-a-kind gear in this panel to edit the records gadgets and to add hierarchies.

Dataset Selector : You can select between a couple of datasets or you could also gather a new dataset using this feature.

Filter Bar : This represents clear out implemented to any measurement in dataset. To add a clear out click on the icon in front of dataset and click on Filter.

Q18. How Do You Use Measures As Dimensions In Sap Lumira Charts?

Go to Settings and click on use Measures as dimensions option. Once you pick out this feature, measures are displayed as new degree size in Dimension panel.

Q19. Can We Convert Data Types In Sap Lumira For Dataset?

You can also convert statistics kind into every other. In Prepare tab → Go to column heading → Options

Q20. How Do Use Hierarchies In The Charts Added To Chart Canvas In Sap Lumira?

When hierarchies are defined on dataset, you may use drill up or drill down option to circulate to next stage.

Q21. What Are The Different Data Sources You Can Use In Lumira To Acquire Dataset?

You can use under statistics sources in SAP Lumira

Excel document as a facts source

Working with CSV documents

Clipboard

Connecting SAP HANA views

Universe as a records source

Using Query with SQL

Using SAP BW InfoProvider as facts supply

Q22. Is It Possible To Ass Custom Charts In Sap Lumira?

You can use SAP Lumira software development package SDK. You can add custom charts in SAP Lumira using VizPacker and these charts may be delivered to listing of available charts in canvas.

Q23. What Is Chart Canvas?

This is used to create or adjust a visualization. You can at once drag attributes and measures to chart canvas or can upload to chart builder.You can upload numerous tools like

Sorted through Dimensions

Add or Edit a ranking with the aid of measures

Clear Chart

Fit chart to frame

Reprompt

Refresh

Settings

Maximize

Undo

Redo

Q24. What Are The Different Chart Types In Sap Lumira?

Bar Chart

Column Chart

Radar Chart

Pie Chart

Donut Chart

Tree

Scatter Plot

Bubble Chart

Network Chart

And many greater

Q25. What Is A Custom Hierarchy?

You can create hierarchies the use of any to be had aggregate of dimensions in received dataset.

Q26. Which Chart Types Support Conditional Formatting In Sap Lumira?

Conditional formatting can be carried out on:

Bar and Column charts (besides 3-d column charts)

Pie chart

Donut chart

Scatter chart

Bubble chart

Cross tab

Q27. What Is Conditional Formatting?

It is used to say important information factors in a chart through extraordinary values meeting positive circumstance. Multiple conditional formatting rules may be carried out on measures or dimensions.

Q28. Is It Possible To Create Customize 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 testimonies, you can add distinct sorts of pages in a tale. To upload a web page click on Add Page and choose a page you need to add to story.

Drag the Visualization from left panel to the story. You also can upload photos from local system. Go to Pictures and click on on + sign.

Q29. How Do You Create Custom Hierarchies In Sap Lumira? How Do You Define Level In A Custom Hierarchy?

Let us say you need 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 alternative dimensions to add to subsequent stages and click on Create. Arrows may be used to exchange the extent.

Q30. What Is The Meaning Of Green, Yellow And Red While Acquiring Data For A Hierarchy?

Locations mapped exactly are marked with green.

Locations with a couple of feasible fit (as an instance, if multiple town named London became discovered) are marked with yellow.

Locations now not found inside the geographic database are marked with Red.

Q31. When You Acquire A Data Set, It Comes Under Which Of The Tab To Perform Data Cleansing And Editing?

Prepare : This is used to import records set in SAP Lumira. Data cleaning is performed and converted into the precise measures or attributes for the reports.

Q32. How Do You Connect Sap Lumira To Hana Modeling Views?

You can connect to SAP HANA Modeling perspectives in SAP Lumira. You have 2 alternatives −

Connect to SAP HANA

Download from SAP HANA

Q33. Can We Add Hidden Columns From An Excel Spreadsheets To Lumira Dataset?

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

Q34. What Is The Different Between Combine And Append Datasets In Lumira?

Merge is used to apply different joins on datasets.

You can use Union operator to append  datasets.

Q35. How You Can Open Multiple Dataset In A Single Lumira Document?

It permits you to open multiple datasets in a single document and you could add dataset to a report.

Go to Data pane on the top → Add new Dataset

Q36. Why Do We Use Sap Lumira As Bi Tool?

It allows you to predict future effects and forecast as in line with converting marketplace conditions.

You can create records visualizations and memories from multiple information resources.

It helps you to adapt records to organizational needs to create testimonies with visualizations.

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

Q37. 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 question to create dataset, visit document → New

Click on Query with SQL option to down load a dataset and click on on Next. JDBC drivers must be established for database middleware for the use of SQL query. The get right of entry to motive force is .Jar documents you could down load from dealer web page and replica to driver folder in utility route.

Select SQL query, all queries in inexperienced gives drivers are set up nicely for middleware. Select database middleware for goal database and click on Next.

Q38. What Are The Different Connection Parameters That Can Be Configured While Using Query With Sql As Data Source?

Connection Pool Mode: To hold connection lively

Pool timeout: Time period to preserve connection lively in minutes.

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

Array Bind Size: Larger bind array, extra variety of rows may be fetched.

Login Timeout: Time earlier than a connection tries a timeout.

Q39. To See The Available Built In Images To Add To Lumira Presentations, Where You Can Add These To Stories?

There are in-built snap shots that can be utilized in a tale. Go to Pictogram on left aspect and it's going to show you all the to be had pictograms that may be utilized in a tale.

Q40. Is It Possible To Print The Visualizations? How Can We Print The Visualizations In Sap Lumira?

Yes, To Print a Visualization, visit Share tab → Select Visualizations and you'll get an choice to Print Visualization on the pinnacle.

Q41. Can You Send Visualization In Email To Other Users? What Are The Different Export Sizes That Can Be Used?

Yes, you may export a visualization to a printer or can also ship in an e-mail to a person. Go to options in a Visualization and click on Send through mail.

Choose an Export Size-

Small, Medium, Large

Q42. What Is The Use Of Different Tabs In Lumira?

Prepare : This is used to import information set in SAP Lumira. Data cleaning is achieved and transformed into the suitable 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 prepared in Prepare tab. You can upload one-of-a-kind attributes and measures to Label axis.

Compose : This is used to create tales and presentation, inclusive of history hues, titles, photographs, and textual content.

Share : This tab is used to submit your visualizations to special platforms or with one of a kind set of customers in BI Repository.

Q43. How Can You Acquire Data From An Infoprovider In Lumira Dataset?

Add new dataset → connect with SAP Business Warehouse

Q44. What Is The Use Of Compose Tab?

You can create extraordinary testimonies in SAP Lumira in presentation style file the use of visualization, graphics and different customizations that has been applied to dataset.Once you visit compose tab you get multiple alternatives to choose an Infographic, Board or a Report.

Q45. Can We Add Filters In Charts Under Visualize Tab?

Yes, you could apply filter out on a chart in Visualize tab. Click on Add clear out and select aa size or a degree to feature a clear out to the chart.

Q46. What Are The Different Formats You Can Export Your Data Sets In Sap Lumira?

You can shop dataset as .Csv or. Xls record.

To do that go to Share tab and choose the dataset from left panel. Go to File → Export As

Q47. To Perform A Merge On Multiple Datasets, What Are The Conditions To Perform A Merge?

To merge :

They have to have identical key column.

Column with identical data kind can be merged.

All columns could be merged.

Q48. Can You Add Multiple Data Sets In Sap Lumira?

Yes, you can pick out among multiple datasets or you may also collect a new dataset the use of this feature.

Q49. Where Do You Define Properties For Chart Canvas?

Go to File → Preferences → Charts

Here you may define numerous properties for chart canvas.

Q50. Which Chart Types Are Best Suited To Show Correlation Between Different Values?

Scatter Plot

Bubble Chart

Network Chart

Numeric Point

Tree