Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mayur
hi,
see i would like to answer it through on example:
consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..
now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...
& even a complex sql is effectively implemented...
finally this will enhance ur performance & a effective development logics ....
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the difference between the public object&schema object?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain difference between zabo and webi?
How to generate the report from excel sheet?
Is there any other repository domains rather than universe, security, document?
explain in detail about type 3?
What is the profile and package?
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?
What three things do you consider to be the most important factors for a manager?
Explain when we use aggregate awareness function in designer?
What Is Snow Flake Schema?
What is the difference between business requirement document and use case document.
Explain what task is 98% of the required work of a business analyst?
What is the difference in creating filters in designer and business objects?
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...
