Business Objects FAQs
What is aggregate awareness?
Ans: 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:
1. Identify all the possible definitions (table/column combinations) of the objects.
2. Arrange the objects by level of aggregation.
3. Build the objects using the @Aggregate_Awareness function.
Specify the incompatible objects
1. Build an objects/aggregate tables matrix.
2. For the first aggregate table, decide whether each object is either:
- at the same level of aggregation or higher (compatible)
- at a lower level of aggregation (incompatible)
3. Check only the boxes of objects that are incompatible for that table.
4. 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 are Object Security Access Levels? (Right click object?Edit?Advanced Tab)
Ans: You can 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 is Multidimensional Analysis?
Ans: 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 dice
• Drill (available only with the BUSINESSOBJECTS EXPLORER).
What is Enterprise Mode?
Ans: 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?
Ans: Workgroup mode means working in an environment without a repository.
What is Incremental Export?
Ans: 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?
Ans: 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 are Linked Universes?
Ans: Linked universes are universes that share common components such as parameters, classes, objects, or joins.
What are Linking of universes and how many levels of linking is possible?
Ans: 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.
What is aggregate awareness?
Ans: 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:
1. Identify all the possible definitions (table/column combinations) of the objects.
2. Arrange the objects by level of aggregation.
3. Build the objects using the @Aggregate_Awareness function.
Specify the incompatible objects
1. Build an objects/aggregate tables matrix.
2. For the first aggregate table, decide whether each object is either:
- at the same level of aggregation or higher (compatible)
- at a lower level of aggregation (incompatible)
3. Check only the boxes of objects that are incompatible for that table.
4. 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 are Object Security Access Levels? (Right click object?Edit?Advanced Tab)
Ans: You can 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 is Multidimensional Analysis?
Ans: 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 dice
• Drill (available only with the BUSINESSOBJECTS EXPLORER).
What is Enterprise Mode?
Ans: 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?
Ans: Workgroup mode means working in an environment without a repository.
What is Incremental Export?
Ans: 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?
Ans: 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 are Linked Universes?
Ans: Linked universes are universes that share common components such as parameters, classes, objects, or joins.
What are Linking of universes and how many levels of linking is possible?
Ans: 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.
