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 package in BO
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can we configure two instances of CMS pointing to two different CMS system databases?
Which versions are used in the bo dashboard work?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain which versions are used in the bo dashboard work?
Explain is data mart?
can anybody tell me about complicated object you have created
Can we Save (save as) WEBI Doc as DESKI?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
what will be the contents for a functional requirements specifications
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?
How to open a universe with out using the Designer ??
