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
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
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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Did you face any problems while creating reports? Name? Solutions?
Explain in detail about type 2(scd),
Explain which versions are used in the bo dashboard work?
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to schedule the report in b.o?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What are the data types present in bo? What happens if we implement view in the designer and report?
what will be the contents for a functional requirements specifications
how to prepare the documentation in business objects and where to get the requirement?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to generate the report from excel sheet?
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?
