Interview Questions.

Q1. What Do You Understand By Custom Hierarchies?

They are used to carry out custom drill down on gadgets from identical or one of a kind instructions in Universe. To create a Custom hierarchy, go to Tools → Hierarchies.

Q2. What Is An Alias Table And Why Do We Use It In Universe?

An Alias desk is referred to as connection with a popular table in Data Foundation. The facts in Alias table is completely identical because the original desk.

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

Q3. What Is The Use Of Query Panel?

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

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

Q4. What Is Docking/undocking Concept In Dashboard Designer?

It is also possible to transport item browser, components browser, Query browser and houses panel from the default locations. To dock a factor, you need to click on on pinnacle of panel and drag it to docking icon. To move a aspect, you have to first dispose of auto hiding.

Q5. How You Can Access A Derived Table From Other Derived Table?

By the usage of derived table function

@derived_table(Derived Table Name)

Q6. What Is The Difference Between Udt And Idt?

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

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

You can’t open an IDT .Unx document in Universe Design tool nor you could convert it to unv document.

Universe Design tool is unmarried supply enabled but IDT is multi supply enabled way you may extract the statistics from extraordinary statistics sources whilst developing a Universe.

Universe Design Tool (UDT)

Universe report extension - .Unv

You can’t open .Unx file and also it could’t be transformed to unv to open in UDT

It is unmarried supply enabled 

It can’t be without delay connected to Dashboard clothier and Crystal Reports present day model

Information Design Tool (IDT)

Universe document extension - .Unx

You can open unv fileby changing unv document to unx report extension

It is multisource enabled

It can be immediately related to Dashboard fashion designer and Crystal Reports modern day version
 

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

Objects within the business layer are inserted mechanically primarily based on the dice. You can upload below functions to beautify features in Business Layer −

Using analytical dimensions, hierarchies, and attributes.

Named sets

Calculated individuals

Insert measures

Pre-defined filters (obligatory or non-compulsory) to restrict statistics lower back in queries

Parameters with non-compulsory prompts

Lists of values to be related to a prompt

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

Alerts are used to set notifications for data values, if values are suitable or require interest. To permit indicators, click on the check container.

You can set Alert Thresholds, allow auto colour, and so forth.

Q9. What Is Aggregate Awareness? How Do You Use This?

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

When you upload an aggregate aware object in question, query generator retrieves the statistics from desk with highest aggregation stage.

Example −

Consider a Sales Fact desk in which income is aggregated through in keeping with month. If your query asks for income consistent with month, question generator will retrieve the facts from aggregated desk.

Q10. How Do You Convert Unv File To Unx File?

Using UMT Upgrade Management furnished with BI 4 for prior releases or in IDT you can do an instantaneous conversion.

Q11. What Do You Understand By Resource Dependency In Universe?

In a Universe there may be many objects that are dependent on every different and shifting, deleting a resource can impact different sources that relies upon on that useful resource.

To take a look at the dependency among different resources, you could pick out show neighborhood dependency.

Q12. What Are The Options Under Component Browser?

Category

List

Tree

Q13. What Is A Derived Table And Why Do You Use It?

A derived desk is a virtual desk in the records basis that mixes different tables using calculations and features.

You can use derived tables for below motive −

To create a desk with columns from different tables. The column definitions can include complex calculations and features.

To create a single table that mixes  or more tables.

To create a table that includes a selection of columns from distinct tables.

To Insert Derived desk, Select table header → right click → Insert → Derived desk.

Q14. What Are The Default Template Categories In Dashboard Data Model?

To create new models, you may use template as starting point. Template additionally offers an concept how one-of-a-kind thing works and you could upload them to canvas to construct a brand new version.

It shows you list of template beneath that class.

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

When you upload objects the usage of a question, you have got alternatives to select −

Refresh before components are loaded

Refresh each time length

Q16. How Do You Hardcore Values In A Data Model In Dashboard?

By manually coming into values in cells in Spreadsheet after which binding those cells to factor label and values under Properties.

Q17. What Is Selector Component? What Are The Different Types Of Selector Component?

Selector factor allows customers to pick out specific alternatives at run time. Selector can be used to configure item’s row, price, position and label into embedded spreadsheet.

You can add selectors from Component browser in Dashboard fashion designer.

Check container

Combo box

Filter

Q18. What Are The Different Output Formats In Dashboard?

Power factor

Word

Attach in email

PDF

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

You can set shade for each detail of a aspect in data model. Colors can be described in Appearance tab underneath Properties pane.

There are extensive variety of colours to be had and you could additionally create your own custom colours.

To outline colour for every detail, choose the element → Go to Color Selector for each element. You can select below sections in color dialog box −

Theme Color : To define colour of modern subject matter.

Standard Color: These are institution of simple colorations.

Recent Color: This indicates recently used hues.

Q20. What Is The Use Of Single Value Component? What Are The Different Styles Of Single Value Component?

Single value additives are used for adding interactivity to statistics models. You can use them to feature more interest to essential parameters.

Single value additives may be utilized in different styles −

Horizontal Progress Bar

Vertical Progress Bar

Dual Slider

Dual Slider 2

Dial

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

Business Layer −

This layers contain all the training and objects, you can take a look at dimensions and measures which are defined in a Universe.

When you put up the commercial enterprise layer in repository, this suggests the of completion of Universe introduction.

You can check the summary of Business Layer to peer wide variety of attributes, dimensions, measures, instructions, LOV’s and so forth.

Data Foundation Layer −

This layer is used to define records foundation - includes tables from records source, joins, and keys etc.

Q22. What Is Web Connectivity Components? What Are The Different Component Types?

These additives can help you join your data model to net. Apart from this, you can also use facts 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 allows you to connect to reporting offerings server and pick out a file to apply in statistics version.

Slide Show: This allows you to create a slide display of URL based pix and SWF files.

SWL loader: This lets in you to load SWF documents from a URL and also you don’t should import the files. It is much like slide display aspect however it gives better reminiscence management.

Connection Refresh Button: This lets in user to refresh the connection manually whilst you hyperlink to it.

Q23. What Is The Use Of Sap Bo Dashboard?

Dashboards dressmaker is SAP Business Objects facts visualization device this is used to create interactive dashboards from unique information assets. Dashboard dressmaker lets in BI builders to create custom dashboards and evaluation that meet the business requirement in an corporation.

Dashboards can include one-of-a-kind graphs, charts and gauge which might be based on the records supplied by facts sources. Dashboards are used by Senior Management that offers updated statistics to statistics to organisation CEO’s and VP’s.

Q24. If You Are Using An Olap Data Sources, Do You Need To Create A Data Foundation?

No, enterprise layer reads the structure of the OLAP source robotically.

Q25. What Is Difference Between A Relational And An Olap Connection?

The idea is basically if you need to get entry to information from a table and ordinary RDBMS then your connection have to be a relational connection but in case your source is an software and records is stored in dice (multidimensional like Info cubes, Information fashions) then you could use an OLAP connection.

Relational connection can simplest be created in IDT/UDT.

OLAP may be created in each IDT and CMC.

Another component to observe is relational connection (which includes HANA) will continually produce a SQL declaration to be fired from file whilst OLAP connection usually create a MDX assertion.

Q26. How To Set Up Aggregate Awareness?

To use aggregate cognizance, first the aggregated table has to be loaded to database after which add the table to Data Foundation.

Define mixture aware gadgets. These are objects in the enterprise layer for which you need queries to apply the combination tables while possible rather than appearing aggregation using non-combination tables.

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

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

Q27. When You Convert A Unv File To Unx Files, Which Of The Features Are Not Supported?

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

You can’t convert universes based totally on stored approaches the use of IDT.

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

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

In SAP Dashboard Designer, under statistics 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 utility as Flash Island

Q29. What Is Chasm Trap? How Do You Resolve This?

When you join a measurement desk with  truth tables with one to many courting, whilst you drag a measurement along side measure from each the reality tables, price of measures are inflated. This is referred to as Chasm lure.

This may be solved the use of Context with the aid of developing  exclusive contexts.

Other way is to visit Universe parameters and pick out the check box → Multiple SQL statements for each degree

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

You can outline various get entry to levels of an object −

Private

Public

Controlled

Restricted

Confidential

When you outline an item as public, all users can get right of entry to the object. If an item is defined as limited, users that are granted access degree of constrained or higher can get right of entry to. To define get right of entry to stage of items −

Select the object in Business layer for that you want to outline the get admission to degree. You can use CTRL key to pick more than one objects. Right click on item → Change Access Level.

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

Using subject matters, you could observe identical format, look and formatting to facts models whilst you want all fashions with equal look. Theme offers you with a color scheme but you may customize it as according to requirement.

To apply a subject matter, go to Format → Theme

Q32. What Is A Container Component? What Are The Different Types Of Container?

Container aspect may be nested to create multilayer models. You can use canvas container inside fundamental canvas to preserve one or extra additives. You can upload, move, delete or trade additives in panel container.

You can use different sorts of bins −

Panel Container

Tab Set

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

File extension remains equal whilst you run over in UMT. You want to perform a conversion in IDT to trade document extension from unv to unx.

Q34. What Is Query Refresh Or Query Prompt Under Universe Component?

These components can be used with queries on Universe.

Query Refresh Button: This permits person to refresh the statistics at runtime. You can encompass Universe or BEX query to allow users to request a query refresh at run time.

Query Prompt Selector: This allows user to select values from BEX or Universe question activates at run time. As consistent with prompt type, consumer can pick out a single cost to use as filter out parameter or can select choice objects.

Q35. What Is Personal, Public And Secured Connection?

A Personal connection is described as created by one consumer and can not be used by other users.

A shared connection may be used by different users via a shared server. You can’t submit a Universe to repository using a shared connection.

A secured connection overcomes the above limitations and you can use this to export Universe to the primary repository.

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

Using query browser, you can click on on Add question → Universe as information source

Select the published Universe and to feature gadgets, you can use Query panel.

When question is delivered, you can do mapping of objects to spreadsheet and later to Dashboard additives.

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

You can post Webi file block as a BI provider and may be consumed without delay in Dashboard.

Q38. What Are The Different States In Context?

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 via defining a course with the blanketed joins.

Excluded joins − In part of the schema this is ambiguous, the excluded joins outline the path that context will in no way take.

Neutral joins are in part of the schema that is not ambiguous, and are usually included inside the query route of the context. Any be a part of that isn't explicitly included or excluded is impartial.

A Context may be described manually or by means of clicking stumble on Context alternative.

Q39. How Would You Connect Sap Ecc System To Dashboard Designer?

There are exceptional methods −

You can use SLT technique for information replication to HANA and then create a Universe on the top of HANA database. Universe may be consumed in Dashboard the usage of question browser.

You can immediately create a Universe at the pinnacle of transaction gadget.

Using brief provider, you could join ECC to load records to BW and question browser may be used to connect with BW.

Q40. What Is The Difference Between A Cnx And Cns File?

.Cns - secured Repository connection

.Cnx - local unsecured connection. If you operate this connection it's going to no longer allow you to publish something to repository.

Q41. Where Do You Define Behavior, Insertion And General Properties Of A Component?

Select the element → proper click Properties tab

On proper facet, you get options to define diverse properties of a element in dashboard model.

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

To see dependent sources in Repository for a specific useful resource beneath Local task, right click and click on display Repository Dependency.

Enter the consultation info wherein sources are posted and click on on log in. It will show you listing of posted Universes in repository which might be primarily based on decided on useful resource underneath Local Project.

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

IDT is called Business Objects design device that extracts the statistics from one-of-a-kind information assets using an OLAP and Relational connection to create Universes. There are different Universe parameters that can be handed at time of Universe advent.

It can be utilized in under reporting and dashboard tools −

SAP Business Objects Web Intelligence (WebI)

SAP Business Objects Dashboard Designer (Earlier known as Xcelsius)

SAP Business Objects Crystal Reports

SAP Business Objects Explorer

Q44. What Are The Different Dashboard Versions You Have Worked On?

BOXI 3.1 well matched Dashboard is referred to as Xcelsius two hundred@

BOXI four.Zero well suited Dashboard is known as Dashboard 4.@

BOXI 4.1 well matched Dashboard is referred to as Dashboard 4.@

Q45. What Is Fan Trap? How Do You Resolve This?

In a Universe, when you have three tables in shape and primary desk is joined with one to many dating with 2nd table which is linked with one to many relationship with 0.33 table and while you drag a measure from 2nd desk and measurement from 3rd table, value of measure is inflated, this situation is called Fan entice.

You can clear up this by using creating an alias of the 2d desk and defining contexts so that ordinary table is joined most effective with the first desk, while the alias is joined with each the 1st and the 3rd table. We would take second table’s degree most effective from the everyday desk and other dimensions of the 2nd desk from the alias desk.

Q46. To Insert Large Amount Of Data In Dashboard Designer, We Can Use Spreadsheet To Map The Objects From Query?

Spreadsheets are favored whilst the wide variety of rows are less in Dashboard. It is by default set to 512 rows however you may edit this putting via going to Preferences.

Q47. What Is Index Awareness?

Index cognizance in a Universe determines which values in a clear out conditions of the queries constructed from the universe, are changed by means of their corresponding indexes or surrogate keys. Values in filter comes from dimensions desk and you want a join with the reality table to get this price.

Q48. Have You Heard About Design Studio? How It Is Different From Dashboard Designer?

Chart Types:  There are 22 charts of sixteen types-34 charts of 12 sorts

Selectors:  18 Selectors of 16 sorts-10 Selectors of 10 Types

Containers:  7 Containers of 3 Types-5 Container of five Types

Maps:  For one hundred Countries-No Maps

Calendar:  Calendar is available as desk-Calendar is available as enter discipline

Filter Panel:  No filter Panel-Drilling and Filtering Capabilities

What-If Component:  6 components-No additives

Visualization Engine:  Adobe Flash with HTML5 assist-Native HTML with CSS

Design and Color Schemes:  Multiple subject matters, personalize the usage of GUI-Basic themes, custom designed using CSS