Interview Questions.

Question 1. What Is Information Design Tool? Which All Reporting And Dashboard Tools You Have Used With Idt?

Answer :

IDT is called Business Objects layout tool that extracts the information from distinctive information assets using an OLAP and Relational connection to create Universes. There are exclusive Universe parameters that may be exceeded at time of Universe creation.

It may be used in below reporting and dashboard gear −

SAP Business Objects Web Intelligence (WebI)
SAP Business Objects Dashboard Designer (Earlier known as Xcelsius)
SAP Business Objects Crystal Reports
SAP Business Objects Explorer
Question 2. What Is The Difference Between Udt And Idt?

Answer :

In UDT, Universe are created with record extension as .Unv. In IDT, Universe file extension is changed to .Unx file.

To open unv report in IDT, it may’t be immediately opened but you may convert unv report to unx file to open in Information Design device.

You can’t open an IDT .Unx report in Universe Design device nor you could convert it to unv file.

Universe Design tool is unmarried source enabled but IDT is multi supply enabled manner you may extract the statistics from one of a kind information assets even as creating a Universe.

Universe Design Tool (UDT)

Universe record extension - .Unv
You can’t open .Unx record and additionally it could’t be transformed to unv to open in UDT
It is single source enabled 
It can’t be at once connected to Dashboard designer and Crystal Reports contemporary model
Information Design Tool (IDT)

Universe record extension - .Unx
You can open unv fileby converting unv report to unx record extension
It is multisource enabled
It can be immediately linked to Dashboard clothier and Crystal Reports modern day model
 

SAP BI Interview Questions
Question three. How Do You Convert Unv File To Unx File?

Answer :

Using UMT Upgrade Management supplied with BI four for earlier releases or in IDT you can do a direct conversion.

Question four. What Is The Data Foundation And Business Layer In Idt?

Answer :

Business Layer −

This layers incorporate all the classes and gadgets, you may take a look at dimensions and measures which can be defined in a Universe.

When you publish the enterprise layer in repository, this shows the of entirety of Universe creation.

You can take a look at the precis of Business Layer to peer variety of attributes, dimensions, measures, classes, LOV’s and so on.

Data Foundation Layer −

This layer is used to outline records basis - consists of tables from statistics supply, joins, and keys and many others.

SAP BI Tutorial
Question five. What Is Difference Between A Relational And An Olap Connection?

Answer :

The concept is essentially in case you need to access records from a desk and normal RDBMS then your connection ought to be a relational connection but if your source is an application and records is stored in dice (multidimensional like Info cubes, Information fashions) then you definately could use an OLAP connection.

Relational connection can best be created in IDT/UDT.

OLAP may be created in each IDT and CMC.

Another thing to note is relational connection (which include HANA) will constantly produce a SQL announcement to be fired from record whilst OLAP connection commonly create a MDX assertion.

SAP WM Interview Questions
Question 6. If You Are Using An Olap Data Sources, Do You Need To Create A Data Foundation?

Answer :

No, business layer reads the shape of the OLAP supply routinely.

Question 7. When You Perform A Conversion In Umt, Unv Files Are Converted To Unx Files?

Answer :

File extension stays same whilst you run over in UMT. You need to carry out a conversion in IDT to trade report extension from unv to unx.

SAP WM Tutorial SAP BO Interview Questions
Question 8. When You Convert A Unv File To Unx Files, Which Of The Features Are Not Supported?

Answer :

In IDT, it doesn’t convert OLAP universes created with previous releases. It is recommended to make a connection to OLAP supply to take dimensional modeling advantages.

You can’t convert universes primarily based on saved techniques using IDT.

Using IDT, you could convert linked universes but they're no longer supported in BI 4.

Question 9. What Do You Understand By Custom Hierarchies?

Answer :

They are used to carry out custom drill down on objects from equal or exclusive classes in Universe. To create a Custom hierarchy, visit Tools → Hierarchies.

SAP Netweaver Interview Questions
Question 10. What Is The Difference Between A Cnx And Cns File?

Answer :

.Cns - secured Repository connection

.Cnx - neighborhood unsecured connection. If you use this connection it will not can help you put up some thing to repository.

SAP BO Tutorial
Question 11. What Is Personal, Public And Secured Connection?

Answer :

A Personal connection is described as created via one consumer and can't be utilized by different customers.

A shared connection can be utilized by other customers via a shared server. You can’t post a Universe to repository the usage of a shared connection.

A secured connection overcomes the above barriers and you may use this to export Universe to the principal repository.

SAP BODS Interview Questions
Question 12. What Is Chasm Trap? How Do You Resolve This?

Answer :

When you be a part of a dimension desk with two fact tables with one to many courting, while you drag a dimension together with measure from both the truth tables, price of measures are inflated. This is referred to as Chasm trap.

This may be solved using Context by means of developing  distinct contexts.

Other way is to go to Universe parameters and pick the check container → Multiple SQL statements for each measure

SAP BI Interview Questions
Question thirteen. What Is Fan Trap? How Do You Resolve This?

Answer :

In a Universe, if you have 3 tables in shape and primary table is joined with one to many dating with 2d desk which is related with one to many courting with third desk and whilst you drag a measure from 2d desk and dimension from 3rd desk, price of degree is inflated, this situation is called Fan trap.

You can remedy this by growing an alias of the 2nd table and defining contexts in order that regular desk is joined simplest with the first desk, even as the alias is joined with each the 1st and the third table. We would take second table’s degree handiest from the ordinary desk and other dimensions of the second desk from the alias table.

SAP Netweaver Tutorial
Question 14. What Is Aggregate Awareness? How Do You Use This?

Answer :

Using combination focus, you can use pre-aggregated facts in tables in the database. It is used to enhance question overall performance with the aid of processing much less wide variety of rows.

When you add an combination conscious object in question, query generator retrieves the facts from table with highest aggregation stage.

Example −

Consider a Sales Fact desk where sales is aggregated via according to month. If your query asks for sales in line with month, query generator will retrieve the data from aggregated desk.

Question 15. How To Set Up Aggregate Awareness?

Answer :

To use combination attention, first the aggregated desk must be loaded to database and then add the table to Data Foundation.

Define aggregate conscious items. These are objects within the enterprise layer for that you want queries to use the combination tables while possible in place of performing aggregation using non-aggregate tables.

In the SQL expression for the item, define the SELECT announcement to apply the @Aggregate_Aware function −

@Aggregate_Aware(sum(aggr_table_1), …, sum(aggr_table_n))

SAP Webi Interview Questions
Question sixteen. What Is Index Awareness?

Answer :

Index recognition in a Universe determines which values in a filter out conditions of the queries constructed from the universe, are changed by their corresponding indexes or surrogate keys. Values in filter comes from dimensions desk and you need a be a part of with the fact desk to get this price.

SAP BODS Tutorial
Question 17. What Is The Use Of Query Panel?

Answer :

You can use query panel to create or preview queries on a Business Layer or at the pinnacle of Universe posted in repository.

Query panel allows you to add items within the question and to preview the query effects.

SAP Web Dynpro Interview Questions
Question 18. What Is A Derived Table And Why Do You Use It?

Answer :

A derived table is a virtual table in the facts foundation that mixes different tables the use of calculations and functions.

You can use derived tables for below motive −

To create a table with columns from different tables. The column definitions can include complex calculations and capabilities.
To create a single table that combines two or more tables.
To create a desk that contains a selection of columns from different tables.
To Insert Derived desk, Select table header → proper click on → Insert → Derived desk.
SAP WM Interview Questions
Question 19. How You Can Access A Derived Table From Other Derived Table?

Answer :

By the use of derived desk function

@derived_table(Derived Table Name)

SAP Webi Tutorial
Question 20. What Is An Alias Table And Why Do We Use It In Universe?

Answer :

An Alias desk is known as connection with a trendy desk in Data Foundation. The facts in Alias table is completely same as the unique desk.

Alias tables are used to break loops in Join route in Data Foundation layer. An Alias desk also can be used to rename a table.

SAP BDC Interview Questions
Question 21. What Are The Different States In Context?

Answer :

In a context, there are 3 states described for a Join −

Included joins − In part of the schema this is ambiguous, the context solves the loop by means of defining a route with the covered joins.

Excluded joins − In part of the schema this is ambiguous, the excluded joins outline the route that context will by no means take.

Neutral joins are in part of the schema that isn't ambiguous, and are always protected in the question course of the context. Any join that is not explicitly covered or excluded is impartial.

A Context may be defined manually or by way of clicking discover Context choice.

Question 22. When You Use An Olap Connection To Build A Business Layer, What Happens To Objects?

Answer :

Objects inside the enterprise layer are inserted mechanically primarily based on the dice. You can add below features to decorate features in Business Layer −

Using analytical dimensions, hierarchies, and attributes.
Named sets
Calculated individuals
Insert measures
Pre-described filters (mandatory or optional) to restriction information again in queries
Parameters with optional prompts
Lists of values to be associated with a spark off
SAP Web Dynpro Tutorial
Question 23. What Is Difference Between Lov’s And Prompt In A Query Panel Filter?

Answer :

LOV’s allows you to choose a couple of values from list of available values.

Prompt permits you to select a fee at run time.

Question 24. What Are The Different Access Levels Of An Object? Where Do You Define Access Level?

Answer :

You can outline diverse get admission to stages of an item −

Private
Public
Controlled
Restricted
Confidential
When you outline an item as public, all customers can access the item. If an object is described as restrained, customers that are granted get right of entry to stage of constrained or higher can get right of entry to. To define get admission to level of gadgets −

Select the item in Business layer for which you want to outline the get right of entry to level. You can use CTRL key to select multiple gadgets. Right click on object → Change Access Level.

SAP BO Interview Questions
Question 25. What Do You Understand By Resource Dependency In Universe?

Answer :

In a Universe there can be many items which are depending on every other and moving, deleting a resource can effect other resources that relies upon on that resource.

To test the dependency between extraordinary sources, you may select display local dependency.

Question 26. What Is Repository Dependency On An Object In A Local Project?

Answer :

To see based resources in Repository for a specific resource underneath Local mission, proper click and click on on display Repository Dependency.

Enter the session information in which assets are posted and click on on log in. It will display you listing of posted Universes in repository which might be based on selected aid below Local Project.

Question 27. What Is The Use Of Sap Bo Dashboard?

Answer :

Dashboards dressmaker is SAP Business Objects statistics visualization device this is used to create interactive dashboards from different statistics sources. Dashboard clothier permits BI developers to create custom dashboards and analysis that meet the commercial enterprise requirement in an organization.

Dashboards can consist of extraordinary graphs, charts and gauge which might be primarily based at the records provided by statistics sources. Dashboards are used by Senior Management that gives updated data to information to enterprise CEO’s and VP’s.

SAP Netweaver Interview Questions
Question 28. What Are The Different Dashboard Versions You Have Worked On?

Answer :

BOXI three.1 well suited Dashboard is referred to as Xcelsius 2008.
BOXI 4.0 compatible Dashboard is known as Dashboard four.Zero.
BOXI four.1 like minded Dashboard is called Dashboard four.1.
Question 29. Have You Heard About Design Studio? How It Is Different From Dashboard Designer?

Answer :

Chart Types:  There are 22 charts of 16 kinds-34 charts of 12 types
Selectors:  18 Selectors of sixteen sorts-10 Selectors of 10 Types
Containers:  7 Containers of 3 Types-five Container of five Types
Maps:  For one hundred Countries-No Maps
Calendar:  Calendar is to be had as desk-Calendar is available as enter area
Filter Panel:  No filter out Panel-Drilling and Filtering Capabilities
What-If Component:  6 additives-No components
Visualization Engine:  Adobe Flash with HTML5 help-Native HTML with CSS
Design and Color Schemes:  Multiple themes, customize using GUI-Basic subject matters, customized the use of CSS
Question 30. What Are The Options Under Component Browser?

Answer :

Category
List
Tree
Question 31. How Would You Connect Sap Ecc System To Dashboard Designer?

Answer :

There are exceptional methods −

You can use SLT method for information replication to HANA and then create a Universe on the top of HANA database. Universe can be fed on in Dashboard using question browser.

You can directly create a Universe on the top of transaction device.

Using temporary company, you can join ECC to load records to BW and question browser may be used to hook up with BW.

Question 32. How Can You Add Data From A Universe/idt To Dashboard?

Answer :

Using question browser, you may click on Add query → Universe as facts source

Select the posted Universe and to feature objects, you may use Query panel.

When question is added, you may do mapping of gadgets to spreadsheet and later to Dashboard additives.

Question 33. Is It Possible To Link A Webi Report To A Dashboard? How?

Answer :

You can put up Webi file block as a BI service and may be fed on at once in Dashboard.

SAP BODS Interview Questions
Question 34. To Insert Large Amount Of Data In Dashboard Designer, We Can Use Spreadsheet To Map The Objects From Query?

Answer :

Spreadsheets are preferred whilst the variety of rows are much less in Dashboard. It is by way of default set to 512 rows however you may edit this setting by means of going to Preferences.

Question 35. What Is Docking/undocking Concept In Dashboard Designer?

Answer :

It is likewise possible to transport object browser, additives browser, Query browser and houses panel from the default locations. To dock a thing, you have to click on on pinnacle of panel and drag it to docking icon. To pass a aspect, you have to first eliminate vehicle hiding.

Question 36. Is It Possible To Set Dashboard To Refresh After A Specific Time Period? How?

Answer :

When you add gadgets using a query, you've got options to select −

Refresh earlier than additives are loaded
Refresh each time length
SAP Webi Interview Questions
Question 37. Where Do You Define Behavior, Insertion And General Properties Of A Component?

Answer :

Select the issue → proper click Properties tab

On right aspect, you get alternatives to outline diverse residences of a thing in dashboard model.

Question 38. If You Want To Set Notifications For Data Values If They Are In Acceptable Limit Or Needs Some Attention?

Answer :

Alerts are used to set notifications for statistics values, if values are perfect or require attention. To permit alerts, click the take a look at box.

You can set Alert Thresholds, allow vehicle shade, and so on.

Question 39. Where Can You Define Color Setting For A Component In Data Model? What Ae The Options In Color Dialog Box?

Answer :

You can set coloration for each element of a issue in data version. Colors may be defined in Appearance tab beneath Properties pane.

There are extensive variety of colors available and you can also create your personal custom shades.

To define coloration for each detail, pick the detail → Go to Color Selector for each detail. You can pick out underneath sections in color conversation box −

Theme Color : To define shade of cutting-edge subject matter.

Standard Color: These are organization of basic colorings.

Recent Color: This shows these days used colours.

Question forty. What Are The Different Output Formats In Dashboard?

Answer :

Power point
Word
Attach in email
PDF
SAP Web Dynpro Interview Questions
Question 41. What Is A Container Component? What Are The Different Types Of Container?

Answer :

Container element can be nested to create multilayer models. You can use canvas box within foremost canvas to preserve one or greater additives. You can upload, pass, delete or alternate additives in panel box.

You can use special styles of containers −

Panel Container
Tab Set
Question 42. What Is Selector Component? What Are The Different Types Of Selector Component?

Answer :

Selector element lets in customers to pick out unique options at run time. Selector may be used to configure object’s row, fee, position and label into embedded spreadsheet.

You can add selectors from Component browser in Dashboard designer.

Check box
Combo box
Filter
SAP BDC Interview Questions
Question forty three. What Is The Use Of Single Value Component? What Are The Different Styles Of Single Value Component?

Answer :

Single cost components are used for adding interactivity to facts fashions. You can use them to add more attention to vital parameters.

Single cost components may be utilized in unique styles −

Horizontal Progress Bar
Vertical Progress Bar
Dual Slider
Dual Slider 2
Dial
Question 44. What Is Web Connectivity Components? What Are The Different Component Types?

Answer :

These components assist you to connect your statistics version to web. Apart from this, you could also use information supervisor to configure net connectivity.

URL button: When user clicks at run time, a button links to a relative or absolute URL.

Reporting Service Button: This permits you to hook up with reporting services server and choose a record to apply in records model.

Slide Show: This permits you to create a slide show of URL primarily based pics and SWF files.

SWL loader: This permits you to load SWF files from a URL and you don’t have to import the files. It is similar to slide display aspect but it presents higher memory management.

Connection Refresh Button: This allows user to refresh the connection manually whilst you link to it.

Question 45. What Is Query Refresh Or Query Prompt Under Universe Component?

Answer :

These additives may be used with queries on Universe.

Query Refresh Button: This lets in consumer to refresh the records at runtime. You can consist of Universe or BEX question to permit customers to request a query refresh at run time.

Query Prompt Selector: This lets in consumer to pick values from BEX or Universe question activates at run time. As in keeping with set off kind, consumer can pick out a unmarried value to apply as clear out parameter or can choose selection gadgets.

Question forty six. What Are The Default Template Categories In Dashboard Data Model?

Answer :

To create new fashions, you can use template as starting point. Template also offers an concept how distinct component works and you can add them to canvas to build a new version.

It suggests you listing of template underneath that category.

Question 47. If You Want To Use Same Layout, Appearance For All The Data Models In Dashboard Designer, How You Can Do This?

Answer :

Using issues, you can practice equal format, look and formatting to records fashions whilst you want all fashions with identical appearance. Theme gives you with a color scheme but you may customise it as per requirement.

To observe a subject, go to Format → Theme

Question 48. What Are The Different Data Connections That Are Supported In Dashboard Designer?

Answer :

In SAP Dashboard Designer, underneath information connections are supported −

Query as a Web provider (QWAAS)
Web Service Connection
SAP NetWeaver BW connection
XML Data
Crystal Report Data Consumer
Live cycle Data Services
External Interface Connection
Live Office Connections
Web Dynpro application as Flash Island
Question 49. How Do You Hardcore Values In A Data Model In Dashboard?

Answer :

By manually coming into values in cells in Spreadsheet after which binding these cells to thing label and values below Properties.