SAP Webi Interview Questions
This SAP Webi Interview Questions contains few questions answers for fresher as well as experienced as a free online practice test.
What are the different version of Business Object that you have worked on?
Answer
- BO XI R1
- BO XI R2
- BO XI R3
- BO XI R3.1
- BO XI R3.2
In year 2011, BO XI 4.0 was introduced and latest version of the tool is SAP BO 4.2.
What are the key differences between BOXI R3 and SAP BO 4.x?
Answer
- Deski is not available in BO 4.x
- IDT is introduced to support multiple data sources
- Import Wizard is no longer available in BO 4.x
- Bo 4.x is 6 layered architecture as compared to BOXI R3 5 layer architecture.
How do you migrate Deski to Webi reports in Business Objects?
Answer
Using Report Conversion Tool
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
What are the differences between Personal, Shared and Secured connections?
Answer
- A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file.
- A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection. Neither can a Universe to exported to repository using a shared connection.
- A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS.
What is BI Launchpad?
Answer
BI Launchpad is a Java or HTML based interface of Business Objects tool to perform analytical reporting and data analysis. You can set the preference for your BI Launchpad which determines which tool interface is launched via Launchpad.
Using Web or Internet Application to access WebI interface via BI Launchpad, you can perform the below tasks −
- Create, edit and refresh all the reports in Web Intelligence.
- Create and edit all the queries in no data source (Universes) but not BEx queries in Web application.
Explain the architecture of Web Intelligence tool?
Answer
It is three layered architecture −
- Database layer – This layer defines multiple SAP and non-SAP data sources.
- Semantic Layer – This layer defines multidimensional data model.
- Presentation Layer – This layer defines where data is presented to end users.
- Various data sources can be used to create analytical and ad-hoc reports
What are the different application modes that can be used in a Web Intelligence tool?
Answer
There are three different application modes that can be used to build the queries, create documents and to analyze the reports. When you open an existing reports below modes are available −
- Data Application Mode
- Reading
- Design
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
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
What is the extension of a Webi document?
Answer
.wid file
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
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
What is a Query panel?
Answer
You can select from list of available objects as per your access permissions. You may not be able to use few of the objects cos of permission.
In query panel, you have Universe outline in left pane and Result objects, query filters, data preview panels in main pane.
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 way for BI tools to connect to Business Explorer (BEx) queries on the SAP NetWeaver BW server.
What are the different save as formats supported for a Webi report?
Answer
- WID
- Excel
- Excel 2007
- CSV Achieve
- TXT File
What are classes and subclasses?
Answer
- Classes are used to group similar objects in a report. A class can contain one or more subclasses.
- Subclasses contains further subcategory of objects in upper level of a class.
- Classes are used to organize objects in some logical manner. While creating queries on Universe you can find the information on objects that you have to use in query.
What is difference between members and named set in hierarchies?
Answer
Members are defined at different level of hierarchies in a data source.
Example
- Consider a Geography hierarchy contain members – “India” at country level and “Haryana” at State level.
- You can also include individual members in query from hierarchy if you don’t want to add all the members. Named set can be used to define set of members.
- A named set is defined as named expression and results a set of members. You can define named set at Universe level or a relational or OLAP database level.
Where do you define hierarchies to use in Webi report?
Answer
Universe level
How do you use InfoCubes in SAP BW to connect to Webi document?
Answer
You can create Webi documents based on BEx (business Exchange Queries) created by BEx Query Designer which is based on Info Cube in SAP BW system. You can connect to a BEx query in WebI with use of BICS BI consumer service connection. You need not to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are automatically mapped in WebI document.
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
What are the query filters?
Answer
- Query filters are used to limit the rows returned in a WebI document. Query filters allow you to hide the data that you don’t want to show to specific people and also limit the size of .wid document. When you run a query, it only returns the rows that meet the query filter definition.
- Below are the key features used in Query filter −
- You can retrieve data as per specific business requirement.
- You can hide the data that you don’t want specific users to see in a WebI document.
- Limit the size of WebI document of network and hence provides performance optimization.
Example − Being an Area Sales Manager for NY, you want to see margin values for your region and Sales universe contains data from all the regions in United State. Also you only want to see data from the stores in NY where sales margin is greater than 100K USD in 2nd Quarter Q2 2015.
What is difference between query and report filters?
Answer
Query filters are applied in Query Panel and they are used to limit the number of rows from data sources and to return the same in document.
Report filters are applied at report level on reports, tables, charts, etc. These filters are not used to limit the data retrieval from the data source and only hide certain values at report level.
Why do we use Prompts? Where do we apply Prompts to use in Webi report?
Answer
- Prompt is defined as special filter for users which allows them to enter a value every time data is refreshed in the document.
- Using prompts, you have multiple users viewing one document to display different sub set of data in database. Prompts allow you to retrieve the data from database and reduce the time.
- Prompts are created in Query Panel
What is context and how they are created?
Answer
- Context defines a particular join path between tables or a specific group of joins for a particular query. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.
- Contexts may be created using detect contexts feature or manually. They are generally created based on logical calculation and business requirements, hence the detect context method is not very effective. To manually create a context Go to Insert Context, give the context name and select the joins that should be present in the context. For a universe contexts should be created in a way that all joins(except shortcut joins) fall in at least one context.
