Answer Posted / 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 |
Post New Answer View All Answers
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
how to create reports on screech?
How to create Index to the table in the universe designer and how it improves the Query performence
In banking domain how many Fact tables,Dimension table are present?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what are the steps to do to use alerts in bo?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain how we drill up week to month?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what is document design in boxi,have u participate in that
Explain what are the measure objects?
Explain what are the steps to be taken to schedule the report?