Interested to Buy Any Domain ? << Click Here >> for more details...
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
- 2 Answers
- 7976 Views
- I also Faced
- E-Mail Answers
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 |
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?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?
What is a fantrap in business objects?
What is global filters and local filters
explain merge dimensions with real time in DWH?
it is possible to link two universes of separate functional domain ?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Explain what is the difference between business requirement document and use case document.
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
Teradata 
