What is a universe?
Answers were Sorted based on User's Feedback
Answer / janardhan
A Universe is a business-oriented mapping of the data
structure found in databases: tables, columns, joins, etc.
A Universe is a semantic layer between Database and end
users.
A Universe can represent any specific application,
system, or group of users. For example, a universe can
relate to a department in a company such as marketing or
accounting.
A Universe can also pertain to a section within a
department or just about any set of organized procedures
such as a payroll or inventory system.
A Universe consists of a set of objects, grouped by classes
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / vasu bathula
Universe is a semantic layer that maps the data structure
found in databases(tables,columns,etc)in business terms.
A universe is a file that contains the following:
1.Connection parameters for one or more database middleware.
2.SQL structures called objects that map to actual SQL
structures in the database such as columns, tables, and
database functions. Objects are grouped into classes.
Objects and classes are both visible to Web Intelligence
users.
3.A schema of the tables and joins used in the database.
Objects are built from the database structures that you
include in your schema. The schema is only available to
Designer users. It is not visible to Web Intelligence and
Desktop Intelligence users.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / handy
A universe is a semantic layer which isolates the end user
from technical issues of database structure.
Actually it is a file which contains the connection
parameters to database middleware.
It contains the structures that map to actual SQL structures
in the database like columns, tables.
A schema of tables and joins used inthe database.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vams_gk
universe is semantic layer between data base and querypanel
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sagar
A universe(UDT/IDT) is a semantic layer b/n the data base and the end user.
Here we connect to the required database and based on the client requirement like which particular data he needs in a report(like fields/columns) we pull-out the required tables from the database connection and join them to get the required output. And universe is not a reporting tool.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / geetu
A universe is a file that contains the following:
• Connection parameters for one or more database middleware.
• SQL structures called objects that map to actual SQL
structures in the
database such as columns, tables, and database functions.
Objects are
grouped into classes. Objects and classes are both visible
to Web
Intelligence users.
• A schema of the tables and joins used in the database.
Objects are built
from the database structures that you include in your
schema. The
schema is only available to Designer users. It is not
visible to Web
Intelligence and Desktop Intelligence users.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / shiv
it is a connection between the user and the database
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / porkodi
a universe is actually a collection of all planets held together
| Is This Answer Correct ? | 0 Yes | 7 No |
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
How to import BIAR file in bo?
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
every reports have docid,when i export a report docid will change or not?
how to do scheduling in desktop intelligence in BO XI R2
Explain the difference between union and group?
What are all difference between business objects 6.5 and xi r2?
Tell me about a complicated object you have created?
Hi, How to navigate one report to another report in webi? Thanks in Advance
i want to take a report 10 records per page. How to take it? is there any paging option in BO?