Interview Questions.

Q1. What Is The Extension Of A Webi Document?

.Wid record

Q2. What Are The Different Application Modes That Can Be Used In A Web Intelligence Tool?

There are 3 one of a kind software modes that may be used to build the queries, create files and to analyze the reviews. When you open an present reports underneath modes are to be had −

Data Application Mode

Reading

Design
 

Q3. What Is Query Stripping?

Query stripping feature optimizes the query to fetch best DATA if you want to be without delay or in a roundabout way rendered or displayed to the User, hence reducing the reaction time and faster display of the file for the consumer. This function is only to be had for OLAP universes, and it is going to be greyed out while the usage of any RDBMS universe. It is used in Query panel.

Q4. How Do You Connect Sap Hana Database To Webi Document?

To use HANA tables for report creation, Use Universe Designer to create Universe the use of a Relational connection to HANA database.

Q5. In A Webi Report, You Want To Add Radio Buttons For End Users To Quickly View And Analyze The Data. Which Of The Webi Feature Support This?

Input Controls

Q6. Explain The Architecture Of Web Intelligence Tool?

It is 3 layered structure −

Database layer - This layer defines multiple SAP and non-SAP records assets.

Semantic Layer - This layer defines multidimensional facts model.

Presentation Layer - This layer defines in which facts is presented to stop users.

Various statistics resources can be used to create analytical and ad-hoc reports

Q7. How Do You Create A Hyperlink In The Web Intelligence Interactive Panel?

By using Create Hyperlink dialog box

Q8. What Is Context And How They Are Created?

Context defines a particular be a part of path between tables or a selected group of joins for a selected question. Any gadgets created on a table column which belong to specific contexts is obviously well suited with all different objects from same contexts.

Contexts can be created the usage of detect contexts characteristic or manually. They are usually created based on logical calculation and enterprise requirements, subsequently the locate context approach isn't very powerful. To manually create a context Go to Insert Context, provide the context name and pick out the joins that should be present inside the context. For a universe contexts need to be created in a way that each one joins(except shortcut joins) fall in at the least one context.

Q9. You Have Few Report Created In Older Versions Of Web Intelligence three.1 And Want To Upgrade To four.X, Which Tool You Should Use?

Using Upgrade Management Tool UMT

Q10. You Want To Use Queries From Different Data Sources In A Webi Document. How You Can Use This?

Using Query Merge. This alternative allows you to merge the facts from one of a kind data assets. Assume which you have created Query 1 and Query 2 in Query Panel. When you integrate both the queries in a single WebI report, objects from each the queries are shown in list of available gadgets.

Q11. How Do You Connect To Sql Server To Create A Universe To Use In A Webi Report?

Using a Relational connection created in Universe Designer

Q12. What Are The Different Data Sources That You Can Use To Create A New Webi Document?

Universe

Flat documents in .Csv or .Xls format

BEx queries

Analysis View

Q13. What Are The Different Save As Formats Supported For A Webi Report?

WID

PDF

Excel

Excel 2007

CSV Achieve

TXT File

Q14. What Are The Different Versions Of Business Objects That You Have Worked On?

BO XI R1

BO XI R2

BO XI R3

BO XI R3.1

BO XI R3.2

In yr 2011, BO XI 4.0 changed into added and contemporary model of the device is SAP BO 4.2.

Q15. What Is Difference Between Query And Report Filters?

Query filters are implemented in Query Panel and they may be used to restrict the range of rows from facts resources and to return the same in record.

Report filters are carried out at file degree on reports, tables, charts, and so on. These filters aren't used to restriction the data retrieval from the statistics source and only conceal certain values at report degree.

Q16. How Do You Migrate Deski To Webi Reports In Business Objects?

Using Report Conversion Tool

Q17. What Do You Understand By Input Controls? Can We Use Input Controls On Geography And Time Hierarchy?

Input controls are used to filter and analyze the document information. You define enter controls using textual content bins and radio buttons. Input controls are associated with file factors like tables and phase headers and use manage to apply clear out on file factors.

When you pick a fee of an enter manage, it filters the values in record element that is associated with input manage by selected fee.

Input Controls also can be used on hierarchical statistics.

Q18. What Are The Differences Between Personal, Shared And Secured Connections?

A Personal connection is created by one person and cannot be utilized by different users. The connection details are stored in PDAC.LSI document.

A shared connection may be used by other customers via a shared server. The connection details are saved in SDAC.LSI record inside the Business Objects installation folder. However one can not set rights and securities on items in a shared connection. Neither can a Universe to exported to repository the usage of a shared connection.

A secured connection overcomes these barriers. Through it rights may be set on objects and documents. Universes can be exported to the vital repository simplest through a secured connection. The connection parameters in this situation are stored within the CMS.

Q19. Can You Attach A Webi Document In Mail?

Yes, by the usage of ship by using email attachment alternative

Q20. What Are The Query Filters?

Query filters are used to limit the rows back in a WebI report. Query filters can help you cover the facts that you don’t want to show to particular people and also limit the dimensions of .Wid report. When you run a question, it handiest returns the rows that meet the query clear out definition.

Below are the key functions utilized in Query filter out −

You can retrieve statistics as in step with specific commercial enterprise requirement.

You can disguise the facts which you don’t want unique customers to see in a WebI file.

Limit the size of WebI report of network and subsequently provides performance optimization.

Example − Being an Area Sales Manager for NY, you need to see margin values on your place and Sales universe includes information from all the areas in United State. Also you handiest need to look information from the stores in NY where sales margin is extra than 100K USD in 2nd Quarter Q2 2015.

Q21. To Allow Sync Between Two Queries In Query Merger, You Use A New Variable To Add It To Report. What Re Properties That You Need To Define To Enable Sync?

Enter the Variable name, Qualification as “Detail” and it'll upload a new discipline Associate Dimension. In Associate size, pick out the precise item from the identical question.

Q22. What Is The Use Of Subquery?

Subqueries affords you a greater bendy option to clear out the statistics compared to an everyday query filter out. Using Subqueries you can restriction the values lower back with a WHERE clause. You can also evaluate the values of objects in a subquery with the other items.

Using Subqueries, you could implement complicated common sense to restriction the size of records which are not feasible to apply with simple query filters.

Q23. You Want To Add A New Column In The Report Based On An Existing Fact Value. How You Can Add This Functionality?

Using New Variable

Q24. What Is The Use Of Nofilter() Function?

To override a file filter or a ranking

Q25. Which Connection You Can Use To Import All Olap Functionalities From An Infocube In Sap Bw?

BICS Business Intelligence Consumer Service. BICS connectivity is the advocated way for BI tools to hook up with Business Explorer (BEx) queries on the SAP NetWeaver BW server.

Q26. You Use The Minus Operator To Combine Queries, What Would Be The Result?

All statistics that suit the primary query circumstance and no longer the second situation.

Q27. How You Can Add Multiple Query Filters In Query Panel?

By the use of AND/OR operators

Q28. What Is Difference Between Break And Sections?

Section breakup the records into more than one cells which can be referred to as Section headers and Each Section header contains a fee for size and statistics similar to dimension fee.

Break is used divides the data up into one block and every column carries size, attributes and measures and those values are repeated for every different row values inside the block.

Q29. What Is The Use Of Conditional Formatting In Webi Report?

Conditional Formatting is used to highlight some unique values within the report. If you need you can display particular low or high values with a few particular colors. Conditional formatting may be applied to below factors −

Rows in horizon tables

Columns in Vertical tables

Cells in paperwork and pass tables

Sections

Free Holding Cells

Condition formatting may be used to make those formatting changes −

Text Color

Size and Style

Cell Border

Color

Size and Style

Cell backgrounds

Q30. What Is Difference Between Members And Named Set In Hierarchies?

Members are defined at distinctive stage of hierarchies in a records source.

Example: Consider a Geography hierarchy incorporate participants – “India” at us of a stage and “Haryana” at State stage.

You can also encompass person individuals in question from hierarchy if you don’t want to feature all of the members. Named set can be used to outline set of contributors.

A named set is described as named expression and results a set of contributors. You can define named set at Universe level or a relational or OLAP database stage.

Q31. What Are The Key Differences Between Boxi R3 And Sap Bo four.X?

Deski isn't to be had in BO 4.X

IDT is delivered to aid a couple of information assets

Import Wizard is no longer available in BO four.X

Bo 4.X is 6 layered architecture in comparison to BOXI R3 five layer structure.

Q32. To Add, Delete Objects In A Report, Applying Conditional Formatting, Applying Formulas In Report, Creating Variables, You Should Open Webi Document In Which Of The Following Mode?

Design mode with Data

Q33. What Are Classes And Subclasses?

Classes are used to organization similar objects in a document. A elegance can comprise one or more subclasses.

Subclasses includes further subcategory of gadgets in top degree of a category.

Classes are used to prepare objects in some logical way. While creating queries on Universe you can discover the records on objects that you have to use in question.

Q34. What Are The Different Report Filters Operators?

Equal To

Not Equal To

Different From Operator

Greater Than

Greater Than or Equal To

Less Than

Less Than or Equal To

Between

Not Between

In List

Not In List

Is Null

Is Not Null
 

Q35. To Publish A Webi Report Created On The Top Of Universe In Bo Repository, It Should Be Created On Which Connection?

Secured connection posted to Repository

Q36. Why Do We Use Prompts? Where Do We Apply Prompts To Use In Webi Report?

Prompt is defined as unique clear out for users which permits them to go into a value whenever statistics is refreshed within the document.

Using activates, you have multiple users viewing one document to show unique sub set of statistics in database. Prompts permit you to retrieve the statistics from database and reduce the time.

Prompts are created in Query Panel

Q37. Explain The Difference Between Query Filter, Report Filter And Block Filter?

A question filter out limits the information returned from the database.

A block filter lets in decided on statistics to show in a single block and hides the other data.

A report filter allows selected statistics to show in a web page and hides the opposite information. The file filter out applies to all facts blocks at the page.

Q38. What Is Bi Launchpad?

BI Launchpad is a Java or HTML based totally interface of Business Objects tool to perform analytical reporting and data analysis. You can set the preference on your BI Launchpad which determines which device interface is released thru Launchpad.

Using Web or Internet Application to get admission to WebI interface via BI Launchpad, you could perform the underneath duties −

Create, edit and refresh all the reports in Web Intelligence.

Create and edit all the queries in no information source (Universes) but now not BEx queries in Web application.

Q39. Where Do You Define Hierarchies To Use In Webi Report?

Universe degree

Q40. How Do You Use Infocubes In Sap Bw To Connect To Webi Document?

You can create Webi documents based totally on BEx (commercial enterprise Exchange Queries) created by using BEx Query Designer that's primarily based on Info Cube in SAP BW gadget. You can connect with a BEx query in WebI with use of BICS BI customer carrier connection. You need no longer to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are routinely mapped in WebI document.

Q41. What Do You Understand By Hierarchical Data?

Hierarchical information is described a information with Parent-infant dating and you can analyze the records at unique degrees of hierarchy.

All the measures that are associated with hierarchical records are aggregated as according to object degree in hierarchy.

Q42. What Is Use Of String Concatenation?

Lastname+ “, “ + Firstname

Q43. When You Synchronize Two Queries From Different Data Sources, What Rules Must You Respect?

Respect the following regulations

Object names can vary.

The facts kind for the merged objects need to be the identical.

Data must have the equal case because the facts company is case-sensitive.

You can simplest synchronize on dimensions.

You can simplest display measures with synchronized dimensions. When you operate them for every other reason, reproduction values appear.

Q44. You Have Saved A Webi Report .Wid File And Send It To Other User To Make Changes. He Is Not Able To Open It And Getting Access Error. How You Can Resolve This?

When you operate Save as choice, on proper aspect you get many options – Refresh on open, Permanent Regional formatting, Save for all customers, Remove record Security.

Select Save for all customers’ choice whilst saving the record.

Q45. What Is A Query Panel?

You can pick out from listing of available gadgets as according to your access permissions. You may not be capable of use few of the objects cos of permission.

In query panel, you have Universe define in left pane and Result gadgets, question filters, records preview panels in principal pane.

Q46. What Is The Extension Of Universes Created In Information Design Tool And Udt?

.Unx- File created with Information Design Tool

.Unv- File created in Universe Design Tool

Q47. What Is An Input Context?

The enter context is the listing of dimensions which might be included inside the calculation itself.

Q48. What Are The Different Chart Type In Webi Tool?

Bar

Box

Column

Line

Map

Radar

Pie

Waterfall

Q49. What Is Aggregate Awareness Function? Why Do We Use It?

Aggregate awareness characteristic is utilized in situations wherein we have same truth tables in exclusive grains. Using this function we are able to define most effective one item for the measures inside the truth tables.

Aggregate_aware(highest_level,decrease degree)

We also want to outline dimensions for associated granularities and outline their incompatibilities with the corresponding statistics through the aggregate navigation. This is accesses through Tools → Aggregate Navigation.

Use: They are used to decorate the performance reports with the aid of using arrogate tables to be had at database and are applied at Universe level as characteristic.