CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

Answers were Sorted based on User's Feedback



CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?..

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

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?..

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

Post New Answer

More Business Objects Interview Questions

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

2 Answers   IBM,


what do u mean by variable functions ?

2 Answers  


I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?

2 Answers  


REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  


Explain the difference between compatible and incompatible objects?

0 Answers  






WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

4 Answers  


If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,


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 ?

1 Answers   Virtusa,


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

0 Answers  


Explain how to schedule the report in b.o?

0 Answers  


How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,


Explain is there any default username & pwd for bo designer & supervisor?

0 Answers  


Categories