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 are the errors u have faced in creating reports in business objects and explain some?
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
am a fresher hw to get real time experience?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
what is crosstab reporting,slice and dise and drill mode??
How to change the order of prompts in universe?
What is the difference between the Bo 3.0 and 3.1?
Can more than 1 metric be applied on an analytic in business objects?
How to make alternative rows red and green in WebI Report?
Have you worked with multiple data sources? If yes. How do you link them?
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1