1.Give the notes and functionalities of cascading prompts, @ script in business objects
Syntax
@Prompt ("message", ["type"], [lov], [MONO|MULTI], [FREE|CONSTRAINED])
where
message is the text of a message within single quotes.
Type can be one of the following: "A" for alphanumeric, "N" for number, or "D" for date.
Lov can be either a list of values enclosed in brackets (each value must be within single quotes and separated by commas) or the name of a class and object separated by a backslash and within single quotes.
MONO means that the prompt accepts only one value. MULTI means that the prompt can accept several values.
FREE refers to free input as opposed to CONSTRAINED, which means that the end user must choose a value suggested by the prompt.
Description
is used to create an interactive object. In the Query Panel, this type of object causes a message to appear. This message prompts the end user to enter a specific value.
Note
the last four arguments are optional; however, if you omit an argument you must still enter the commas as separators.
Example
In Where Clause:
City. City IN @Prompt ("Choose City", "A", {"Chicago", "Boston", "New York"}, MULTI, FREE)
In the Query Panel, the object prompts the end user to choose a city.
2.What is Nested prompt and how to create this prompt?
Nested prompts are called "Cascading Prompts" in Business Objects environment. Try searching for this keyword. To create cascading prompts, you need to edit the properties of an object & impose another prompt as a condition.
3.What is a Universe?
A) It is a semantic layer between Database and the designer used to create objects and classes. (It maps to data in Database).
4.How do you design a universe?
The design method consists of two major phases.
During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.
During the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. You may also wish to perform tests on the universes you create from the Business Objects User module. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.
For a universe based on a simple relational schema, Designer provides Quick Design, a wizard for creating a basic yet complete universe. You can use the resulting universe immediately, or you can modify the objects and create complex new ones. In this way, you can gradually refine the quality and structure of your universe
5.What are Linked Universes?
If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.
6.In the BO universe, how to link two universe, like I have one universe in sales.uni and another is marketing.uni
In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linking.
7.Types of universes in business objects?
Simple and Complex.
8.How can you check the universe?
By making use of Check integrity button
9.What are the user requirements in a universe?
Database connections, key column, join and check for loop if you need measures, metrics,
10. How can you check the integrity?
By making use of Check integrity button.
11. What are Universe parameters?
Name of the universe, description and RDBMS connection, size and rights.
12. How can we improve performance?
By making use of Aggregate tables.
13. How many universes can be created in a project
We can create any number of universes, but at a time we can open only one universe, generally number of universes should be equal to number of sub-domains.
14. In the BO universe, how to link two universe, like I have one universe in sales. uni and another is marketing.uni
In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linking.
15. What are the user requirements in a universe?
Database connections, key column, joins and check for loopif you need mesures, metrics, cheers,www.sithu.s5.com
16. What are Universe parameters? –
Name of the universe, description and RDBMS connection, size and rights.
17. what all will be exported to the repository, when we export a universe ?
When we export a universe first time, a unique identifier is allocated to the universe and this identifier is updated on the local version of the universe in the universe domain.
If we export the universe to a diff, domain and now the universe has an identifier for diff-domain (EX: exporting a universe from a development domain to a production domain)
when a designer exports the universe to the Repository (universe domain) they must export all the related LOV files (which contains the data values associated with an object) to the document domain.
18. How many universes can be created in a project...?
 In a project you can create multiple universes. For multiple universe usage linked universe is an ideal concept.
19. What is the size of data base?
In general it will be anything between 4-8 Terabytes.
20. Dimension Parameters for analysis. Dimensions typically relate to a
Hierarchy such as geography, product, or time. For example Last Name and CityId
21. What is a Fact Table
A fact table contains statistical information about transactions. For example, it
May contain figures such as Sales Revenue or Profit.
22. What is an aggregate table?
These are tables that contain pre calculated data
23. What is a Lookup Table?
A lookup (or dimension) table contains information associated with a particular
Entity or subject.
24. Classes
A class is a logical grouping of objects within a universe. It represents a category
Of objects. The name of a class should indicate the category of the objects that it
Contains. A class can be divided hierarchically into subclasses.
25. When is the Repository created?
- In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation