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
Explain the difference between union and group?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
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
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the steps to do to use alerts in bo?
How to restrict password to a user while sending a document in .pdf format
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Differences between business objects and web intelligence reports?
What are the steps to be taken to schedule the report?
how get the grand total in master-detail report?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how to create reports on screech?
Explain how we drill up week to month?