Answer Posted / 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 View All Answers
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What is difference between webi and infoview?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
how get the grand total in master-detail report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain in detail about type 1?
any difficulitis have you phase while creating bo reports and how did u solve it
What is aggregate table and aggregate fact table ... Any examples of both?
How were the reports scheduled and how to resolve unexecuted documents?
what are the tables used in health care domain project and columns used in report?
in sap bi we have wad, then why we go for sap bo
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is top business?
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?
