Category Archives: News

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 BW on HANA Interview Questions

SAP BW on HANA Interview Question And Answers:

Q.What is the DIM ID?

Dim ids ink dimensions to the fact table.

FOR Course Content   Click me


Q. What is the time distribution option in update rule
This is to distribute data according to time; for example if the source contains calendar week and the target contains calendar day, the data is spit for each calendar day. Here you can select either the normal calendar or the factory calendar.


Q. What are the types of attributes?
Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example assume that we have a customer characteristics with country as a navigational attribute; you can analyze the data using customer and country.


Q. What are the steps to load non cumulative cube?

  • initialize opening balance in R/3 (S278)
  • activate extract structure MCO3BFO for data source 2LIS_03_BF
  • set up historical material documents in R/3
  • load opening balance using data source 2LIS_40_S278
  • load historical movements and compress without marker update.
  • set up V3 update
  • load deltas using 2LIS_03_BF.

Q. What is a transnational info cube?
These cubes are used for both read and write; standard cubes are optimized for reading. The transactional cubes are used in SEM.

SAP BODS Interview Questions

SAP BODS Interview Questions and Answers Prepared by Real time Experts, Learn SAP BODS Online Training Classes SAP BODS Training Cerification Material Best Institute in Hyderabad USA Canada and Australia

SAP BODS Interview Question And Answers:

Q.What is the use of BusinessObjects Data Services?

BusinessObjects Data Services provides a graphical interface that allows you to easily create jobs that extract data from heterogeneous sources, transform that data to meet the business requirements of your organization, and load the data into a single location.


Q. Define Data Services components.
Data Services includes the following standard components:

  • Designer
  • Repository
  • Job Server
  • Engines
  • Access Server
  • Adapters
  • Real-time Services
  • Address Server
  • Cleansing Packages, Dictionaries, and Directories
  • Management Console [sociallocker]

Q. What are the steps included in Data integration process?

  • Stage data in an operational datastore, data warehouse, or data mart.
  • Update staged data in batch or real-time modes.
  • Create a single environment for developing, testing, and deploying the entire data integration platform.
  • Manage a single metadata repository to capture the relationships between different extraction and access methods and provide integrated lineage and impact analysis.

Q. Define the terms Job, Workflow, and Dataflow

  • A job is the smallest unit of work that you can schedule independently for execution.
  • A work flow defines the decision-making process for executing data flows.
  • Data flows extract, transform, and load data. Everything having to do with data, including reading sources, transforming data, and loading targets, occurs inside a data flow.

Q. Arrange these objects in order by their hierarchy: Dataflow, Job, Project, and Workflow.

  • Project, Job, Workflow, Dataflow.
  • SAP BODI Interview Questions

    SAP BODI Interview Question And Answers:

    Q.How does the statement ‘Single point of Integration’ suits the data integrator?

    DI combines both batch data movement and management with caching to provide a single data integration platform for information management from any information source and for any information use.


    Q. State and explain the key function of data integrator.
    Loading data: Loading ERP or Enterprise application data into an operational datastore and update in batch-time
    Routing request: Creates information requests to a DW or ERP system using complex rules
    Applying transaction: DI can apply data changes in a variety of data formats and any custom format.


    Q. State and explain various data integrator components.
    Designer: Is development interface that allows creating, testing and manually executing jobs that load a DW. Function performed is data mapping, transformation and control logic.
    Repository: Set of tables that hold user-created and predefined system objects, metadata, transformation etc.
    Types:
    Local repository: Used to store definitions of DI obj and source/target metadata.
    Central repository: Used to support multi-user development. Provides a shared obj library.
    Service: Starts Job Server when the system is restarted.
    Component: Job Server:
    Includes: Administrator: Includes scheduling, starting& stopping real-time services, managing adapters etc.
    Metadata Reporting: Provides browser based reports on Enterprise metadata stored in the DI repository.


    Q. Explain the process of running a job from designer.
    The Designer tells job server to run the job. The job server then gets the job from associated repository and starts an engine to process the job.


    Q. Explain job server and engine.
    when jobs are executed, the DI engine starts the data movement engine that integrates data from heterogeneous sources, performs complex data transformations and manages extraction and transactions in the ETL process.

    SAP BI ABAP Interview Questions

    SAP BI ABAP Interview Question And Answers:

    Q. What is table partition ?

    SAP is using fact table partitioning to improve the performance. you can partition only on 0CALMONTH or 0FISCPER.


    Q. How would you convert a info package group into a process chain ?
    Double Click on the info package grp, click on the ‘Process Chain Maint’ button and type in the name and description; the individual info packages are inserted automatically.


    Q. How do you replace a query result from a master query to a child query ?
    If you select characteristic value with replacement path then it used the results from previous query; for ex: let us assume that u have query Q1 which displays the top 10 customers, we have query Q2 which gets the top 10 customers for info object 0customer with as a variable with replacement path and display detailed report on the customers list passed from Q1.


    Q. What is modeling ?
    It is an art of designing the data base. The design of DB depends on the schema and the schema is defined as representation of tables and their relationships.


    Q. What is an info cube ?
    Info cube is structured as star schema (extended) where a fact table is surrounded by different dim table that are linked with DIM-ids. And the data wise, you will have aggregated data in the cubes.

    SAP Basis Interview Questions

    SAP Basis Interview Question And Answers:

    Q. What is SAP Basis?

    SAP basis acts as an operating system or a platform for SAP applications to run. It supports the entire range of SAP applications.


    Q. What is the difference between Developer Trace, System Log and System Trace?
    1. System Trace: When you want to record internal SAP system activities, system trace is used. The trace is useful in diagnosis internal problems within SAP system and the host system.
    2. System Log : To know the recent logs for application server and CI, System log is referred.
    3. Developer Trace: In the event of problems, developer trace, records the technical information about the error or problem
    For problem analysis and system monitoring Developer trace or System log is used.


    Q. In a situation where My SAP system is down (Users unable to login to SAP system), how to analyze the problem?
    1. Check the Database status
    2. SAP services
    3. SAP management console ( Dispatcher, IGS and Message Server)
    4. You need to find out trace root on the basis of point at serial no ( c ).


    Q. What is private mode?
    In private mode, the heap data is exclusively allocated by the user and is no more shared or available across the system. This occurs when your extended memory is exhausted.


    Q. What is OSP$ mean?
    Two users “OPS$adm” and “OPS$SAP” Service are created in your SAP system and to connect and communicate with database internally this user mechanism is used.