Interview Questions.

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

A Personal connection is created via one user and cannot be utilized by different customers. The connection info are stored in PDAC.LSI record.

A shared connection can be used by different users via a shared server. The connection details are stored in SDAC.LSI report within the Business Objects set up folder. However one cannot set rights and securities on gadgets in a shared connection. Neither can a Universe to exported to repository the usage of a shared connection.

A secured connection overcomes these boundaries. Through it rights can be set on objects and documents. Universes may be exported to the significant repository most effective via a secured connection. The connection parameters in this example are stored in the CMS.

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

WID

PDF

Excel

Excel 2007

CSV Achieve

TXT File

Q3. 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

Q4. 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

Q5. What Is The Use Of Subquery?

Subqueries offers you a extra bendy option to clear out the records compared to an ordinary query clear out. Using Subqueries you may restriction the values lower back with a WHERE clause. You also can evaluate the values of items in a subquery with the alternative items.

Using Subqueries, you could put in force complicated common sense to restriction the scale of data which are not feasible to use with simple query filters.

They are used in Query panel

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

Input controls are used to clear out and examine the report records. You outline input controls the usage of textual content packing containers and radio buttons. Input controls are associated with document elements like tables and section headers and use control to use clear out on file factors.

When you choose a value of an input manage, it filters the values in file detail that is associated with input manipulate via selected price.

Input Controls also can be used on hierarchical facts.

Q7. 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 use Save as option, on proper facet you get many options – Refresh on open, Permanent Regional formatting, Save for all customers, Remove report Security.

Select Save for all customers’ alternative whilst saving the report.

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

You can create Webi documents based on BEx (enterprise Exchange Queries) created by means of BEx Query Designer which is primarily based on Info Cube in SAP BW machine. You can hook up with a BEx query in WebI with use of BICS BI patron carrier connection. You need no longer to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are routinely mapped in WebI file.

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

There are 3 special application modes that can be used to build the queries, create documents and to investigate the reports. When you open an current reports underneath modes are available −

Data Application Mode

Reading

Design

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

A query filter out limits the facts back from the database.

A block filter out permits decided on statistics to show in a unmarried block and hides the alternative facts.

A report filter allows selected information to show in a page and hides the alternative records. The record clear out applies to all information blocks on the page.

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

Prompt is defined as unique filter for users which allows them to go into a price every time records is refreshed inside the file.

Using activates, you've got more than one users viewing one file to display specific sub set of records in database. Prompts allow you to retrieve the facts from database and decrease the time.

Prompts are created in Query Panel

Q12. 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 endorsed manner for BI equipment to connect with Business Explorer (BEx) queries on the SAP NetWeaver BW server.

Q13. Explain The Architecture Of Web Intelligence Tool?

It is three layered architecture:

Database layer:- This layer defines more than one SAP and non-SAP records resources.

Semantic Layer:- This layer defines multidimensional information model.

Presentation Layer:- This layer defines in which facts is supplied to quit customers.

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

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

Universe

Flat documents in .Csv or .Xls layout

BEx queries

Analysis View

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

Universe level

Q16. 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 call, Qualification as “Detail” and it will upload a brand new discipline Associate Dimension. In Associate measurement, choose the particular object from the equal query.

Q17. 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

Q18. What Are The Key Differences Between Boxi R3 And Sap Bo 4.X?

Deski isn't always to be had in BO four.X

IDT is introduced to guide a couple of data resources

Import Wizard is no longer to be had in BO four.X

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

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

By using Create Hyperlink conversation field

Q20. What Is The Extension Of A Webi Document?

.Wid report

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

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

Q22. What Is Context And How They Are Created?

Context defines a selected be a part of course among tables or a particular group of joins for a selected query. Any gadgets created on a table column which belong to particular contexts is naturally compatible with all different objects from equal contexts.

Contexts can be created using come across contexts characteristic or manually. They are usually created primarily based on logical calculation and commercial enterprise necessities, hence the come across context method isn't always very effective. To manually create a context Go to Insert Context, supply the context call and pick out the joins that have to 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.

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

Aggregate recognition feature is utilized in situations where we've identical truth tables in specific grains. Using this feature we will define simplest one object for the measures within the reality tables.

Aggregate_aware(highest_level,lower stage)

We also want to define dimensions for related granularities and define their incompatibilities with the corresponding data through the aggregate navigation. This is accesses via Tools → Aggregate Navigation.

Use:

They are used to enhance the performance reviews via making use of arrogate tables to be had at database and are applied at Universe level as characteristic.

Q24. 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 year 2011, BO XI four.0 became brought and modern day model of the tool is SAP BO 4.2.

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

All information that suit the first query condition and not the second condition.

Q26. 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

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

Respect the following rules

Object names can vary.

The statistics kind for the merged gadgets should be the equal.

Data should have the equal case due to the fact the data provider is case-sensitive.

You can only synchronize on dimensions.

You can best display measures with synchronized dimensions. When you use them for every other purpose, reproduction values seem.

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

By the usage of AND/OR operators

Q29. What Do You Understand By Hierarchical Data?

Hierarchical information is described a statistics with Parent-infant courting and you may analyze the data at unique degrees of hierarchy.

All the measures which can be related to hierarchical records are aggregated as according to object degree in hierarchy.

Example

Consider a Geography hierarchy, you've got Country India and State described as Delhi. Now in case you use this geographical hierarchy in record and need to investigate Number of Units bought at every level for one of a kind classes, then hierarchies can help you use Aggregation at country degree and if you drill all the way down to state stage, for every country too.

Q30. What Is An Input Context?

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

Q31. 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

Q32. What Is A Query Panel?

You can pick out from listing of available items as according to your get entry to permissions. You might not be capable of use few of the gadgets cos of permission.

In query panel, you've got Universe define in left pane and Result gadgets, query filters, data preview panels in most important pane.

Q33. What Is Use Of String Concatenation?

Lastname+ “, “ + Firstname

Q34. What Is Query Stripping?

Query stripping function optimizes the question to fetch most effective DATA with a purpose to be immediately or circuitously rendered or displayed to the User, as a consequence lowering the response time and quicker show of the document for the consumer. This function is most effective to be had for OLAP universes, and it is going to be greyed out while using any RDBMS universe. It is utilized in Query panel.

Q35. What Is Difference Between Break And Sections?

Section breakup the information into a couple of cells which might be referred to as Section headers and Each Section header incorporates a value for measurement and facts similar to measurement price.

Break is used divides the records up into one block and every column carries dimension, attributes and measures and these values are repeated for each other row values within the block.

Q36. What Is Difference Between Query And Report Filters?

Query filters are applied in Query Panel and they are used to restrict the wide variety of rows from facts sources and to return the same in file.

Report filters are carried out at record degree on reports, tables, charts, and many others. These filters are not used to limit the statistics retrieval from the statistics supply and most effective hide positive values at record stage.

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

Conditional Formatting is used to focus on a few unique values within the record. If you need you could display specific low or excessive values with some specific colorings. Conditional formatting may be implemented to under elements −

Rows in horizon tables

Columns in Vertical tables

Cells in paperwork and pass tables

Sections

Free Holding Cells

Condition formatting can be used to make these formatting adjustments:

Text Color

Size and Style

Cell Border

Color

Size and Style

Cell backgrounds

Q38. Can You Attach A Webi Document In Mail?

Yes, with the aid of the use of ship with the aid of e-mail attachment choice.

Q39. What Are Classes And Subclasses?

Classes are used to organization similar items in a report. A elegance can incorporate one or greater subclasses.

Subclasses contains further subcategory of objects in higher level of a class.

Classes are used to arrange objects in a few logical way. While growing queries on Universe you may discover the facts on objects that you have to use in query.

Q40. What Are The Query Filters?

Query filters are used to restrict the rows lower back in a WebI document. Query filters let you hide the records that you don’t need to expose to unique humans and also limit the dimensions of .Wid report. When you run a question, it simplest returns the rows that meet the question filter definition.

Below are the important thing functions utilized in Query filter:

You can retrieve data as in line with specific enterprise requirement.

You can hide the records which you don’t want particular customers to peer in a WebI document.

Limit the scale of WebI document of community and therefore provides performance optimization.

Example: Being an Area Sales Manager for NY, you need to peer margin values for your region and Sales universe carries records from all of the areas in United State. Also you most effective want to see information from the shops in NY where income margin is more than 100K USD in second Quarter Q2 2015.

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

To override a report filter or a ranking

Q42. 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

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

Using Report Conversion Tool

Q44. 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

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

Using Query Merge. This alternative lets in you to merge the records from one of a kind data resources. Assume which you have created Query 1 and Query 2 in Query Panel. When you integrate both the queries in a unmarried WebI document, items from each the queries are proven in list of available items.

Q46. What Is Bi Launchpad?

BI Launchpad is a Java or HTML based interface of Business Objects device to carry out analytical reporting and statistics analysis. You can set the desire in your BI Launchpad which determines which device interface is launched via Launchpad.

Using Web or Internet Application to get entry to WebI interface through BI Launchpad, you may perform the underneath responsibilities −

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

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

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

Bar

Box

Column

Line

Map

Radar

Pie

Waterfall

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

Members are defined at exclusive level of hierarchies in a statistics supply.

Example:

Consider a Geography hierarchy include individuals – “India” at u . S . A . Level and “Haryana” at State stage.

You also can include person members in query from hierarchy if you don’t need to add all the members. Named set may be used to define set of members.

A named set is described as named expression and effects a fixed of individuals. You can outline named set at Universe level or a relational or OLAP database level.

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

Secured connection published to Repository.