why we are using derived tables ?how it will help?
- 2 Answers
- 5119 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.
| Is This Answer Correct ? | 0 Yes | 9 No |
What is the prm file ? can anybody explain me ?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?
What sort of existing documents should business analysts refer to when starting on a new project?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
what is custom sorting?how we can do this expalain with procedure???
What are steps to be taken care to create a good Universe?
can anybody explain me in detail about software development life cycle of business objects in detail?
What is report template in b.o?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Can anybody tell me the difference b/w canned and adhoc reporting?.
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
Teradata 
