31. When do you use multiple universes?
You can use multiple universes to solve a Chasm trap in a WEBINTELLIGENCE universe when
Multiple SQL for Measures cannot be used as there are dimension objects defined for one or both of the fact tables.
32. When do you NOT use multiple universes?
You do not use multiple universes in the following situations:
• Full client BUSINESSOBJECTS universes
• When a WEBINTELLIGENCE universe does not contain dimension objects defined for any of the fact tables.
33. What are @Functions?
1) @Aggregate_Aware (2) @Prompt (3) @Script (4) @Select (5) @Variable (6) @Where
@Prompt: message prompts the end user to enter a specific value.
Syntax: @Prompt (‘message’, [‘type’], [lov], [MONO|MULTI], [FREE|CONSTRAINED])
@Script: This function recovers the results of Visual Basic for Applications macro (VBA macro).
Syntax: @Script (‘var_name’, ‘vartype’, ‘script_name’)
@Select: This function enables you to re-use the Select statement of an existing object.
Syntax: @Select (Classname\Objectname)
@Variable: The @Variable is used to reference the value assigned to a name or variable.
Syntax: @Variable(‘myname’)
@Where: This function lets you re-use the Where clause of an existing object.
Syntax: @Where (Classname\Objectname)
34. What is 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:
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.
35. What are Object Security Access Levels? (Right click object?Edit?Advanced Tab)
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.
36. What is Multidimensional Analysis?
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).
37. What is Enterprise Mode?
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.
38. What is Workgroup Mode?
Workgroup mode means working in an environment without a repository.
39. What is Incremental Export?
DESIGNER can export a universe incrementally, meaning that it takes into account only the modifications made since the last export.
40. What is the method of migrating the universe across domains and/or repositories?
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.
Note: Both the repositories must reside within the same database schema.
More Questions & Answers :-
Part1 Part2 Part3 Part4 Part5
You can use multiple universes to solve a Chasm trap in a WEBINTELLIGENCE universe when
Multiple SQL for Measures cannot be used as there are dimension objects defined for one or both of the fact tables.
32. When do you NOT use multiple universes?
You do not use multiple universes in the following situations:
• Full client BUSINESSOBJECTS universes
• When a WEBINTELLIGENCE universe does not contain dimension objects defined for any of the fact tables.
33. What are @Functions?
1) @Aggregate_Aware (2) @Prompt (3) @Script (4) @Select (5) @Variable (6) @Where
@Prompt: message prompts the end user to enter a specific value.
Syntax: @Prompt (‘message’, [‘type’], [lov], [MONO|MULTI], [FREE|CONSTRAINED])
@Script: This function recovers the results of Visual Basic for Applications macro (VBA macro).
Syntax: @Script (‘var_name’, ‘vartype’, ‘script_name’)
@Select: This function enables you to re-use the Select statement of an existing object.
Syntax: @Select (Classname\Objectname)
@Variable: The @Variable is used to reference the value assigned to a name or variable.
Syntax: @Variable(‘myname’)
@Where: This function lets you re-use the Where clause of an existing object.
Syntax: @Where (Classname\Objectname)
34. What is 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:
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.
35. What are Object Security Access Levels? (Right click object?Edit?Advanced Tab)
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.
36. What is Multidimensional Analysis?
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).
37. What is Enterprise Mode?
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.
38. What is Workgroup Mode?
Workgroup mode means working in an environment without a repository.
39. What is Incremental Export?
DESIGNER can export a universe incrementally, meaning that it takes into account only the modifications made since the last export.
40. What is the method of migrating the universe across domains and/or repositories?
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.
Note: Both the repositories must reside within the same database schema.
More Questions & Answers :-
Part1 Part2 Part3 Part4 Part5
No comments:
Post a Comment