CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Answers were Sorted based on User's Feedback
Answer / ramesh
No.We cannot create view in BO universe.view is similar to derived table in BO where we can create our customised columns involved complex calclutions from already existing tables and columns and make the joins to normal tables and we can create objects and classes for any other table in universe structure pane.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / pbs
yes.We can't create views in Universe.views are stored as SQL.Derived tables are stored as tables.Exection is faster in case of derived tables as it operates on the new table directly ,but views are SQL and executes and operates on the source table and then fetches te records.Advantage of view is any changes in source table will also get reflected in view,but in derived table it is not possible.
Is This Answer Correct ? | 0 Yes | 5 No |
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
what do u mean by variable functions ?
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
Explain the difference between compatible and incompatible objects?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain how to schedule the report in b.o?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
Explain is there any default username & pwd for bo designer & supervisor?