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
Give some information on report bursting?
How many universes can be created in a project?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Can we create universe with no cache??
Can Bo generates the Report from the cubical data Explain?
Can anybody tell me what are the tuning problems?
Explain about alerts in bos, under what situation we need to use alerts?
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
What is the dense rank?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
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?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
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 Is Snow Flake Schema?
what will be the contents for a functional requirements specifications
