Business Objects FAQs, Interview Questions and Answers

3/17/2010 No Comment

Business Objects Interview Questions with detailed answers.

Learn by sharing Business Objects Interview Questions.

Explain what do you mean by aggregate awareness in Business Objects?
Answer : Aggregate awareness is a function used to aggregate the data from table, is used to enhance the performance of SQL transactions; it determines which tables to use in SQL generation either aggregate or detailed tables. Precedence: left to right
Syntax: @Aggregate_Aware (sum (table1.sal), sum (table2.sal))
Setting up Aggregate Awareness:

Build the Objects:

  • Identify all the possible definitions (table/column combinations) of the objects.
  • Arrange the objects by level of aggregation.
  • Build the objects using the @Aggregate_Awareness function.
Specify the incompatible objects
  • Build an objects/aggregate tables matrix.
  • For the first aggregate table, decide whether each object is either at the same level of aggregation or higher (compatible) or at a lower level of aggregation (incompatible)
  • Check only the boxes of objects that are incompatible for that table.
  • Repeat the steps for the remaining aggregate tables.
Define any necessary contexts
1.Define one context per level of aggregation.

Test the results
1. Run several queries.
2. Compare the results.

What do you mean by Object Security Access Levels? (Right click object->Edit->Advanced Tab)?You can 
Answer : restrict an object so that only end users with the appropriate security access level can use it. Security access levels are assigned to user profiles by the supervisor from the Supervisor module.

The levels are from highest to lowest: Private, Confidential, Restricted, Controlled, and Public (Default level). The higher the level, the fewer the number of users can access it.

What do you mean by Multidimensional Analysis?

Answer : The purpose of multidimensional analysis is to organize data along a combination of “dimensions” and “hierarchies”.

BUSINESSOBJECTS allows two types of multidimensional analyses:
Slice and diceDrill (available only with the BUSINESSOBJECTS EXPLORER).

Explain Enterprise Mode in Business Objects?
Answer : Enterprise mode means working in an environment with a repository.
Online and offline modes are options that apply when you are working in enterprise mode.

Online mode: Online, the default mode, is appropriate for a networked environment in which the general supervisor has set up a repository. In online mode, you can import or export universes.


Offline mode: Working in offline mode means essentially that you work with universes that are stored locally on your computer. To use this mode, you must have been connected at least once in online mode.

What is Workgroup Mode?

Answer : Workgroup mode means working in an environment without a repository.

Explain Incremental Export in Business Objects?

Answer : DESIGNER can export a universe incrementally, meaning that it takes into account only the modifications made since the last export.

What is the method of migrating the universe across domains and/or repositories?

Answer : The following are the steps followed while migrating a universe across repositories:
1. First open the universe in the current repository and make the connection as shared.
2. Save the Universe. (Save for all Users)
3. Open the universe in the designer and export that to the required repository.
4. Change the connection type from shared to secured.

What do you mean by Linked Universes?

Answer : Linked universes are universes that share common components such as parameters, classes, objects, or joins.

What do you mean by Linking of universes and how many levels of linking is possible?

Answer : Creating a universe by taking the components from another universe. Only one level of linking is possible in Business Objects. There are thee approaches to linking: 1. Kernel 2. Master 3. Component

Disadvantages:
1.Any change made to the master universe is reflected onto the derived universe. 2. Designer does not save any list values, which may be associated with the linked universes.
Related Posts


No comments :

 

Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer