Answer Posted / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain how we drill up week to month?
Explain is there any other repository domains rather than universe, security, document?
Is there any other repository domains rather than universe, security, document?
When we use aggregate awareness function in designer?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
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?
How we drill up week to month?
Explain what are the measure objects?
Explain about alerts in bos, under what situation we need to use alerts?
What we need to discuss with designer before starting the universe designing.
What is top business?
explain in detail about type 3?
What task is 98% of the required work of a business analyst?