Tag Archives: SAP BO Interview questions

SAP Business Objects Interview Questions and Answers

SAP BO Interview Questions And Answers

Q. What is a personal connection?

Personal connection can be created only by a single user and it can’t be made used by others. The details regarding such a connection can be usually stored inside PDAC.LSI file.

Q. What is Shared connection?

This is a kind of connection that is usually made used by other user via a server which is shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.

Q. What is a secured connection?

Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related with this kind of connection can be set over documents as well as objects. Universes can be brought inside central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.

Q. Define custom hierarchies?

The custom hierarchies can be used for defining the universe for facilitating drill down that is customized and can happen between objects from different or same classes considering the user requirements.

Q. How can custom Hierarchies be created?

The custom hierarchies can be created by following the path tools ->hierarchies in BO designer.

Q. Define a context in the universe.

Context can be defined as the particular path of join between a specific group of joins or the tables for the purpose of a particular query. A particular object that can be found inside the column of a table, belonging to particular context is supposed to be compatible to all the various kinds of objects belonging to the same context. In the case of objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside micro cube. This is for making sure that there is no incorrect result associated with a loop or any other kind of issue related with join path.

Q. How can Contexts be created?

Context can be created by making use of feature associated with context or by manual procedures. The context are usually created by making use of logical calculation or based on the business requirements. The detect context may not be much useful in this case and so it should be done by making use of manual procedure.

Q. Define a Chasm Trap.

Chasm trap is a condition that arises when the values inside the fact table get inflated at the time of measuring the values from two different fact tables by considering the dimensions inside dimension table.

SAP BO 4.1 & SAP BO 4.2 Interview Questions Please Contact Us

FOR Course Content Click me

SAP BO BI (Business Objects) Online Training

SAP BO Online Training Course Content.

Enroll Live Instructor Led Classes For SAP Business Objects 4.1 / 4.2  Training. SAP BO Online Training  ✓Real time experts ✓Certification Training Material ✓24/7 Support ✓Real Time Scenarios ✓Recording ✓Pay Installment ✓Resume Preparation

 

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

 

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

 

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

 

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

 

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

 

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

 

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

 

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

 

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

 

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

 

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

 

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

 

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

 

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

 

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

 

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

 

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports
For SAP Business Objects Interview Questions                Click

 

Top ↑