Interview Questions.

Question 1. Why Do We Use Sap Lumira As Bi Tool?

Answer :

It permits you to are expecting destiny outcomes and forecast as in line with converting marketplace situations.
You can create statistics visualizations and memories from a couple of statistics resources.
It helps you to adapt records to organizational wishes to create tales with visualizations.
You can share the visualizations on one of a kind systems like SAP HANA, BO Explorer, Business Objects BI Platform, etc.
 

Question 2. Why Do We Use Custom Calculations In Data Set?

Answer :

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

Example : You have a “Salary” column within the statistics set, you may upload a new calculated column with name “Bonus” and can apply a calculation on Salary to get the fee of this column.

SAP BO Interview Questions
Question three. What Is The Use Of Different Tabs In Lumira?

Answer :

Prepare : This is used to import facts set in SAP Lumira. Data cleansing is completed and transformed into the correct measures or attributes for the reports. You can add new custom calculations here.

Visualize : This tab is used to feature graphs and charts at the information that has been imported and prepared in Prepare tab. You can add exclusive attributes and measures to Label axis.

Compose : This is used to create testimonies and presentation, along with heritage hues, titles, pictures, and textual content.

Share : This tab is used to put up your visualizations to specific systems or with exceptional set of users in BI Repository.

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

Answer :

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

Connect to SAP HANA
Download from SAP HANA
SAP BO Tutorial
Question five. What Is The Difference Between Two Options To Connection To Hana Modeling Views?

Answer :

By deciding on alternative - “connect to SAP HANA”. This will permit you to get entry to statistics in examine mode and you can visualize facts in charts.

Download from SAP HANA
This options lets in you to copy the data regionally and you can edit and manage the facts to visualize inside the charts.

SAP ABAP Interview Questions
Question 6. Can We Add Hidden Columns From An Excel Spreadsheets To Lumira Dataset?

Answer :

Yes, on Advance choice to select custom range. You can also consist of hidden rows and columns.

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

Answer :

Prepare : This is used to import records set in SAP Lumira. Data cleaning is completed and transformed into the best measures or attributes for the reviews.

SAP ABAP Tutorial SAP BW Interview Questions
Question eight. How Can You Acquire Data From An Infoprovider In Lumira Dataset?

Answer :

Add new dataset → hook up with SAP Business Warehouse

Question 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?

Answer :

To use SQL query to create dataset, visit record → New

Click on Query with SQL choice to download a dataset and click on on Next. JDBC drivers needs to be established for database middleware for the usage of SQL question. The get right of entry to driving force is .Jar documents you can download from supplier site and duplicate to driver folder in utility path.

Select SQL query, all queries in green presents drivers are mounted well for middleware. Select database middleware for goal database and click on on Next.

SAP HANA Interview Questions
Question 10. What Are The Different Connection Parameters That Can Be Configured While Using Query With Sql As Data Source?

Answer :

Connection Pool Mode: To hold connection lively
Pool timeout: Time period to hold connection active in minutes.
Array Fetch Size: to decide range of rows to fetch from target database.
Array Bind Size: Larger bind array, extra quantity of rows may be fetched.
Login Timeout: Time earlier than a connection attempts a timeout.
SAP BW Tutorial
Question 11. What Are The Different Panels In Prepare Tab For Data Cleansing And Applying Filters?

Answer :

Dimension and Measure Panel : It incorporates listing of all dimensions and measures obtained in records set. Number in the front of every object represents its records kind. You can use one of a kind tools on this panel to edit the records items and to add hierarchies.

Dataset Selector : You can choose between more than one datasets or you may also gather a new dataset using this option.

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

SAP BPC Interview Questions
Question 12. What Is Chart Canvas?

Answer :

This is used to create or alter a visualization. You can directly drag attributes and measures to chart canvas or can add to chart builder.You can add various equipment like

Sorted by means of Dimensions
Add or Edit a ranking with the aid of measures
Clear Chart
Fit chart to frame
Reprompt
Refresh
Settings
Maximize
Undo
Redo
SAP BO Interview Questions
Question 13. What Are The Different Chart Canvas Properties That You Can Set In Lumira?

Answer :

Chart Canvas Layout
Chart Style
Template
Font Zoom, etc.
SAP HANA Tutorial
Question 14. Where Do You Define Properties For Chart Canvas?

Answer :

Go to File → Preferences → Charts
Here you may outline diverse residences for chart canvas.

Question 15. What Is The Use Of Compose Tab?

Answer :

You can create unique stories in SAP Lumira in presentation style report the usage of visualization, photos and other customizations that has been implemented to dataset.Once you go to compose tab you get a couple of options to pick an Infographic, Board or a Report.

SAP BODS Interview Questions
Question 16. What Are The Different Chart Types In Sap Lumira?

Answer :

Bar Chart
Column Chart
Radar Chart
Pie Chart
Donut Chart
Tree
Scatter Plot
Bubble Chart
Network Chart
And many greater
SAP BPC Tutorial
Question 17. Which Chart Types Are Best Suited To Show Correlation Between Different Values?

Answer :

Scatter Plot
Bubble Chart
Network Chart
Numeric Point
Tree
SAP BDC Interview Questions
Question 18. What Is The Use Of Geography Charts In Sap Lumira? What Are Different Chart Types Under This Category?

Answer :

It is used to provide map of u . S . A . Or globe gift inside the analysis. Common chart sorts are:

Geo Bubble Chart
Geo Choropleth Chart
Geo Pie Chart
Geo Map
SAP ABAP Interview Questions
Question 19. What Is Conditional Formatting?

Answer :

It is used to say vital facts points in a chart through extraordinary values assembly sure condition. Multiple conditional formatting regulations can be carried out on measures or dimensions.

SAP BODS Tutorial
Question 20. Which Chart Types Support Conditional Formatting In Sap Lumira?

Answer :

Conditional formatting can be implemented on:

Bar and Column charts (besides 3D column charts)
Pie chart
Donut chart
Scatter chart
Bubble chart
Cross tab
SAP BW on HANA Interview Questions
Question 21. Can You Add Multiple Data Sets In Sap Lumira?

Answer :

Yes, you can select among more than one datasets or you can additionally gather a brand new dataset the usage of this feature.

Question 22. What Is The Use Of Filters?

Answer :

Filters are used to limit the records in Lumira Visualizations. You can pass numerous filter conditions to restriction facts is available in visualizations and stories.

SAP BW on HANA Tutorial
Question 23. Can We Add Filters In Charts Under Visualize Tab?

Answer :

Yes, you can practice filter on a chart in Visualize tab. Click on Add filter and select aa dimension or a degree to feature a clear out to the chart.

Sap Bapi Interview Questions
Question 24. What Is The Use Of Display Formatting Option In Prepare Tab?

Answer :

You can set the under formatting for an characteristic or dimension −

Select a Value layout
Choose a Display layout
Prefix or suffix
SAP BW Interview Questions
Question 25. Can We Convert Data Types In Sap Lumira For Dataset?

Answer :

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

Question 26. What Is The Use Of Hierarchies?

Answer :

Hierarchies are used to display statistics at distinct granularity level and you can drill up/down at different degrees for better information of courting between items.

Sap Business One Interview Questions
Question 27. What Is Geography Hierarchy? How We Can Create Geography Hierarchy In Dataset?

Answer :

When records is acquired, software looks for size containing region and present with an icon.

Click on alternative icon in front of a size → Create a Geographic hierarchy → By Names (this selection is to be had most effective for string dimensions).

New window will open with call Geographical statistics → pick the dimension to map to hierarchy and click on on Confirm.

SAP HANA Interview Questions
Question 28. What Is The Meaning Of Green, Yellow And Red While Acquiring Data For A Hierarchy?

Answer :

Locations mapped exactly are marked with inexperienced.
Locations with a couple of possible suit (as an example, if multiple town named London turned into discovered) are marked with yellow.
Locations not determined in the geographic database are marked with Red.
Question 29. How Do Use Hierarchies In The Charts Added To Chart Canvas In Sap Lumira?

Answer :

When hierarchies are described on dataset, you can use drill up or drill down choice to circulate to next stage.

Sap Hana Modeling Interview Questions
Question 30. What Is A Custom Hierarchy?

Answer :

You can create hierarchies the use of any to be had mixture of dimensions in acquired dataset.

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

Answer :

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 choose the alternative dimensions to add to next ranges and click on Create. Arrows may be used to alternate the extent.

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

Answer :

It lets in you to open multiple datasets in a single document and you could add dataset to a record.

Go to Data pane at the pinnacle → Add new Dataset

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

Answer :

You can also merge  dataset by way of the usage of Join operator.

Go to Data pane on the pinnacle → Combine → Merge

SAP BPC Interview Questions
Question 34. To Perform A Merge On Multiple Datasets, What Are The Conditions To Perform A Merge?

Answer :

To merge :

They need to have same key column.
Column with same facts type can be merged.
All columns may be merged.
Question 35. What Is The Use Of Merge Type Option In Sap Lumira?

Answer :

Merge type defines the form of be part of. You can choose from specific be a part of kinds – Inner join, outer be a part of, and so forth.

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

Answer :

Merge is used to apply one of a kind joins on datasets.
You can use Union operator to append  datasets.
SAP BODS Interview Questions
Question 37. How Do You Append Datasets In Lumira?

Answer :

To append datasets in Lumira, visit Data → Combine → Append
To use append, each tables have to contain equal range of columns and well matched records kinds. Only well suited statistics types may be appended.
Question 38. You Have Acquired Datasets With Different Number Of Columns And Different Data Types, When You Perform Append On These Datasets What Will Happen?

Answer :

When you perform an append and each source and goal dimensions are special, message seems-Union can not show up.

Question 39. If You Want To See How Data Is Spread Over Multiple Axis In A Single Chart, Which Option You Can Use In Lumira?

Answer :

You also can upload measures as a size in SAP Lumira. To do that add two or more measures as dimensions inside the chart. This may be used to test how information is unfold over multiple axis in a unmarried chart.

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

Answer :

Go to Settings and click on use Measures as dimensions option. Once you pick this selection, measures are displayed as new measure dimension in Dimension panel.

SAP BDC Interview Questions
Question forty one. Is It Possible To Ass Custom Charts In Sap Lumira?

Answer :

You can use SAP Lumira software program development package SDK. You can add custom charts in SAP Lumira the usage of VizPacker and those charts can be delivered to list of available charts in canvas.

Question 42. How Do You Create Stories In Sap Lumira In Left, Right, Top And Bottom Slide Show Formats In Compose Tab?

Answer :

To create a slide show, visit Compose → Board → Create. You can select exclusive styles of charts Left, Right, Bottom, Top, and so forth.

SAP BW on HANA Interview Questions
Question 43. Is It Possible To Create Customize Stories In Sap Lumira? How You Can Add Company Logos, Custom Images To Lumira Presentations?

Answer :

You also can create personalize tales in SAP Lumira. To create personalize memories, you could upload distinctive sorts of pages in a tale. To upload a page click on on Add Page and choose a page you want to feature to story.

Drag the Visualization from left panel to the tale. You can also add snap shots from local gadget. Go to Pictures and click on on + sign.

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

Answer :

There are in-built pics that may be used in a tale. Go to Pictogram on left side and it will display you all the to be had pictograms that may be used in a tale.

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

Answer :

You can keep dataset as .Csv or. Xls file.

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

Question forty six. Is It Possible To Print The Visualizations? How Can We Print The Visualizations In Sap Lumira?

Answer :

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

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

Answer :

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

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

Answer :

Yes, you can export a visualization to a printer or can also send in an e mail to a person. Go to options in a Visualization and click on on Send via mail.
Choose an Export Size-

Small, Medium, Large
Question forty nine. What Are The Different Data Sources You Can Use In Lumira To Acquire Dataset?

Answer :

You can use beneath records sources in SAP Lumira

Excel document as a facts supply
Working with CSV files
Clipboard
Connecting SAP HANA views
Universe as a statistics source
Using Query with SQL
Using SAP BW InfoProvider as records supply
Question 50. How Do Use Universes As Data Source To Acquire Dataset In Sap Lumira?

Answer :

Universes which are created with .Unx extension the usage of Information Design Tool/.Unv documents created in UDT and published to BI repository can be used as statistics supply in SAP Lumira.

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