YouTube Icon

Interview Questions.

Top 100+ Business Objects Web Intelligence Xi 3 Interview Questions And Answers - May 27, 2020

fluid

Top 100+ Business Objects Web Intelligence Xi 3 Interview Questions And Answers

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

Answer :

BO XI R1
BO XI R2
BO XI R3
BO XI R3.1
BO XI R3.2
In yr 2011, BO XI four.0 turned into added and trendy version of the tool is SAP BO four.2.

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

Answer :

Deski isn't always to be had in BO four.X
IDT is brought to help more than one statistics assets
Import Wizard is no longer available in BO 4.X
Bo four.X is 6 layered structure in comparison to BOXI R3 5 layer structure.
SAP BI Interview Questions
Question 3. How Do You Migrate Deski To Webi Reports In Business Objects?

Answer :

Using Report Conversion Tool

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

Answer :

Secured connection published to Repository.

SAP BI Tutorial
Question five. What Are The Differences Between Personal, Shared And Secured Connections?

Answer :

A Personal connection is created by one consumer and can't be used by different customers. The connection information are stored in PDAC.LSI file.

A shared connection can be used by different users via a shared server. The connection information are stored in SDAC.LSI document inside the Business Objects installation folder. However one can't 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 those barriers. Through it rights may be set on items and documents. Universes may be exported to the crucial repository simplest thru a secured connection. The connection parameters in this case are stored within the CMS.

SAP BO Interview Questions
Question 6. What Is Bi Launchpad?

Answer :

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

Using Web or Internet Application to get right of entry to WebI interface via BI Launchpad, you can perform the below tasks −

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

Create and edit all the queries in no facts supply (Universes) but not BEx queries in Web application.

Question 7. Explain The Architecture Of Web Intelligence Tool?

Answer :

It is 3 layered structure:

Database layer:- This layer defines a couple of SAP and non-SAP information sources.

Semantic Layer:- This layer defines multidimensional records version.

Presentation Layer:- This layer defines in which records is offered to give up users.

Various data sources can be used to create analytical and advert-hoc reviews.

SAP BO Tutorial SAP BW Interview Questions
Question 8. What Are The Different Application Modes That Can Be Used In A Web Intelligence Tool?

Answer :

There are three extraordinary application modes that can be used to construct the queries, create files and to investigate the reports. When you open an present reports below modes are available −

Data Application Mode
Reading
Design
Question nine. 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?

Answer :

Design mode with Data

SAP BPC Interview Questions
Question 10. What Are The Different Data Sources That You Can Use To Create A New Webi Document?

Answer :

Universe
Flat files in .Csv or .Xls format
BEx queries
Analysis View
SAP BW Tutorial
Question eleven. What Is The Extension Of A Webi Document?

Answer :

.Wid document

Business Objects-Crystal Reports Interview Questions
Question 12. You Have Few Report Created In Older Versions Of Web Intelligence 3.1 And Want To Upgrade To 4.X, Which Tool You Should Use?

Answer :

Using Upgrade Management Tool UMT

SAP BI Interview Questions
Question 13. What Is The Extension Of Universes Created In Information Design Tool And Udt?

Answer :

.Unx- File created with Information Design Tool
.Unv- File created in Universe Design Tool
SAP BPC Tutorial
Question 14. What Is A Query Panel?

Answer :

You can select from list of to be had objects as in line with your get admission to permissions. You may not be able to use few of the items cos of permission.

In question panel, you've got Universe define in left pane and Result objects, question filters, statistics preview panels in predominant pane.

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

Answer :

BICS Business Intelligence Consumer Service. BICS connectivity is the recommended manner for BI equipment to hook up with Business Explorer (BEx) queries at the SAP NetWeaver BW server.

SAP BODS Interview Questions
Question 16. What Are The Different Save As Formats Supported For A Webi Report?

Answer :

WID
PDF
Excel
Excel 2007
CSV Achieve
TXT File
SAP BODS Tutorial
Question 17. What Are Classes And Subclasses?

Answer :

Classes are used to group similar objects in a record. A magnificence can comprise one or extra subclasses.

Subclasses incorporates in addition subcategory of objects in upper stage of a category.

Classes are used to organize gadgets in some logical way. While growing queries on Universe you may discover the records on items that you have to use in question.

Business intelligence Interview Questions
Question 18. What Is Difference Between Members And Named Set In Hierarchies?

Answer :

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

Example:

Consider a Geography hierarchy include members – “India” at u . S . Stage and “Haryana” at State degree.

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

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

SAP BO Interview Questions
Question 19. Where Do You Define Hierarchies To Use In Webi Report?

Answer :

Universe stage

SAP BW on HANA Tutorial
Question 20. How Do You Use Infocubes In Sap Bw To Connect To Webi Document?

Answer :

You can create Webi files based totally on BEx (enterprise Exchange Queries) created by using BEx Query Designer that is based on Info Cube in SAP BW gadget. You can connect with a BEx question in WebI with use of BICS BI patron service connection. You want no longer to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are routinely mapped in WebI report.

SAP BW on HANA Interview Questions
Question 21. How Do You Connect To Sql Server To Create A Universe To Use In A Webi Report?

Answer :

Using a Relational connection created in Universe Designer

Question 22. What Are The Query Filters?

Answer :

Query filters are used to limit the rows back in a WebI report. Query filters can help you cover the data which you don’t need to reveal to particular people and also restriction the scale of .Wid file. When you run a query, it handiest returns the rows that meet the query clear out definition.

Below are the key features used in Query filter out:

You can retrieve records as according to specific commercial enterprise requirement.

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

Limit the scale of WebI record of community and subsequently provides performance optimization.

Example: Being an Area Sales Manager for NY, you want to see margin values to your vicinity and Sales universe consists of information from all the areas in United State. Also you simplest need to see records from the stores in NY in which sales margin is more than 100K USD in 2nd Quarter Q2 2015.

Question 23. What Is Difference Between Query And Report Filters?

Answer :

Query filters are implemented in Query Panel and they're used to restrict the number of rows from records sources and to go back the identical in document.

Report filters are carried out at report stage on reports, tables, charts, and so forth. These filters are not used to restriction the facts retrieval from the records source and most effective cover positive values at record level.

Business Objectives Interview Questions
Question 24. Why Do We Use Prompts? Where Do We Apply Prompts To Use In Webi Report?

Answer :

Prompt is described as unique clear out for customers which lets in them to enter a value each time information is refreshed within the record.

Using activates, you've got a couple of users viewing one record to display specific sub set of statistics in database. Prompts will let you retrieve the statistics from database and reduce the time.

Prompts are created in Query Panel

SAP BW Interview Questions
Question 25. What Is Context And How They Are Created?

Answer :

Context defines a particular be part of path among tables or a particular group of joins for a specific query. Any gadgets created on a table column which belong to unique contexts is clearly well suited with all other gadgets from same contexts.

Contexts may be created the usage of stumble on contexts feature or manually. They are typically created based totally on logical calculation and enterprise necessities, as a result the stumble on context technique is not very effective. To manually create a context Go to Insert Context, deliver the context name and pick out the joins that must be gift within the context. For a universe contexts need to be created in a way that all joins(except shortcut joins) fall in at the least one context.

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

Answer :

Aggregate consciousness function is used in eventualities wherein we have same reality tables in unique grains. Using this characteristic we will outline handiest one item for the measures within the fact tables.

Aggregate_aware(highest_level,decrease level)

We additionally want to outline dimensions for associated granularities and define their incompatibilities with the corresponding records via the combination navigation. This is accesses via Tools → Aggregate Navigation.

Use:

They are used to decorate the performance reviews with the aid of making use of arrogate tables to be had at database and are implemented at Universe level as feature.

Sap Business One Interview Questions
Question 27. What Is The Use Of Subquery?

Answer :

Subqueries presents you a more flexible option to filter out the records in comparison to an everyday query filter. Using Subqueries you may limit the values lower back with a WHERE clause. You can also examine the values of items in a subquery with the opposite items.

Using Subqueries, you may implement complicated good judgment to restriction the dimensions of information which are not viable to use with easy question filters.

They are utilized in Query panel

SAP BPC Interview Questions
Question 28. In Query Panel, You Can’t See Ranking Option Enabled, What Could Be The Reason?

Answer :

Database ranking is performed by way of editing the script generated through question. If you database doesn’t support ranking, then choice to create rating will not spotlight in query panel.

Also be aware that Ranking can’t be created on hierarchical facts.

Question 29. What Do You Understand By Hierarchical Data?

Answer :

Hierarchical facts is defined a facts with Parent-child dating and you may analyze the records at unique tiers of hierarchy.

All the measures which are associated with hierarchical statistics are aggregated as consistent with object stage in hierarchy.

Example

Consider a Geography hierarchy, you have Country India and State defined as Delhi. Now in case you use this geographical hierarchy in record and want to research Number of Units offered at every stage for exceptional classes, then hierarchies will let you use Aggregation at us of a degree and in case you drill all the way down to state stage, for each nation too.

Question 30. What Is Difference Between Break And Sections?

Answer :

Section breakup the information into multiple cells which are referred to as Section headers and Each Section header incorporates a value for size and data corresponding to dimension value.

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

Question 31. What Is Query Stripping?

Answer :

Query stripping function optimizes the question to fetch handiest DATA so that you can be immediately or indirectly rendered or exhibited to the User, as a consequence lowering the reaction time and faster display of the document for the user. This feature is best available for OLAP universes, and it will likely be greyed out whilst the usage of any RDBMS universe. It is used in Query panel.

Question 32. What Are The Different Chart Type In Webi Tool?

Answer :

Bar
Box
Column
Line
Map
Radar
Pie
Waterfall
Question 33. Explain The Difference Between Query Filter, Report Filter And Block Filter?

Answer :

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

A block filter out allows decided on facts to show in a single block and hides the alternative records.

A document filter permits selected records to show in a web page and hides the alternative records. The document filter applies to all statistics blocks on the page.

Business Objects-Crystal Reports Interview Questions
Question 34. When You Synchronize Two Queries From Different Data Sources, What Rules Must You Respect?

Answer :

Respect the subsequent guidelines

Object names can vary.

The information kind for the merged gadgets must be the same.

Data must have the identical case due to the fact the facts issuer is case-touchy.

You can best synchronize on dimensions.

You can most effective display measures with synchronized dimensions. When you use them for some other motive, replica values appear.

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

Answer :

All records that suit the first query situation and no longer the second situation.

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

Answer :

Conditional Formatting is used to focus on some unique values in the record. If you need you could display precise low or excessive values with some unique colorations. Conditional formatting may be applied to under elements −

Rows in horizon tables
Columns in Vertical tables
Cells in forms and cross tables
Sections
Free Holding Cells
Condition formatting can be used to make those formatting adjustments:

Text Color
Size and Style
Cell Border
Color
Size and Style
Cell backgrounds
SAP BODS Interview Questions
Question 37. How You Can Add Multiple Query Filters In Query Panel?

Answer :

By the usage of AND/OR operators

Question 38. What Are The Different Report Filters Operators?

Answer :

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
Question 39. You Want To Use Queries From Different Data Sources In A Webi Document. How You Can Use This?

Answer :

Using Query Merge. This alternative lets in you to merge the statistics from distinctive records resources. Assume that you have created Query 1 and Query 2 in Query Panel. When you integrate each the queries in a unmarried WebI file, gadgets from both the queries are shown in listing of available items.

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

Answer :

Using New Variable

Business intelligence Interview Questions
Question forty one. What Is An Input Context?

Answer :

The input context is the list of dimensions that are blanketed in the calculation itself.

Question 42. What Is Use Of String Concatenation?

Answer :

Lastname+ “, “ + Firstname

SAP BW on HANA Interview Questions
Question forty three. What Is The Use Of Nofilter() Function?

Answer :

To override a document filter or a rating

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

Answer :

By the use of Create Hyperlink dialog box

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

Answer :

Enter the Variable name, Qualification as “Detail” and it'll upload a new subject Associate Dimension. In Associate dimension, pick out the particular item from the same question.

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

Answer :

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

Question 47. Can You Attach A Webi Document In Mail?

Answer :

Yes, via using send via e-mail attachment choice.

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

Answer :

When you operate Save as choice, on right aspect you get many alternatives – Refresh on open, Permanent Regional formatting, Save for all users, Remove document Security.

Select Save for all customers’ option whilst saving the document.

Question forty nine. 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?

Answer :

Input Controls

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

Answer :

Input controls are used to filter and analyze the record statistics. You outline input controls the use of textual content bins and radio buttons. Input controls are related to record factors like tables and phase headers and use control to apply filter out on file factors.

When you select a cost of an input control, it filters the values in file detail that is associated with enter control by decided on value.

Input Controls can also be used on hierarchical facts.




CFG