Friday 27 April 2018

SAP Webi Interview Questions

Question1. 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 year 2011, BO XI 4.0 was introduced and latest version of the tool is SAP BO 4.2.

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

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

Answer : Using Report Conversion Tool

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

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

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

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

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

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

Question10. What Is The Extension Of A Webi Document?

Answer : .wid file

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

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

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

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

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

Answer :

    • WID
    • PDF
    • Excel
    • Excel 2007
    • CSV Achieve
    • TXT File

More about SAP Webi:

1 comment: