Hai,
Can anyone tell me 'how to use one dataprovider
result as an input to another dataprovider?.
In BO6.5 there is an option like "select query result".
we can use this option in the filter.
but the same thing not available in BO XI webi.
if any one face this problem , can you please share with me
how to do this?
Thanks,
Narmatha.

Answer Posted / natarajan

In BO XIR2 report designer window, you have an option called
Combine Queries. Using that, its possible to source the
output of one query as an input to another query. Combine
query gives features to do a union, intersection or minus.
Intersection query will help to select common rows from two
different queries, which I think is the solution for your query.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain when we use aggregate awareness function in designer?

788


Explain what is the difference between slice and dice and cross tab report?

830


explain in detail about type 3?

794


What is the difference between the public object&schema object?

775


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

828


What is the difference between datawarehousing and businessintelligence?

866


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2626


Can Bo generates the Report from the cubical data Explain?

1835


Explain what are the steps to be taken to schedule the report?

842


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

1638


What task is 98% of the required work of a business analyst?

786


What is Indexing? how did u implement indexing?

2023


in sap bi we have wad, then why we go for sap bo

3061


How to execute the plsql procedure from the report by clicking with mouse?

822


Explain about alerts in bos, under what situation we need to use alerts?

770