Hai, Can anyone tell me 'how to use one dataprovider result as a

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.

Question Posted / mrs.narmatha

3 Answers
7895 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

Answer / sathish arichandran

In XI R2 webi there is a function called Dataprovider SQL().
It returns the sql query as an output in string format. You
can use this sql to another data provider for an input. I
hope this will help you. Revert back to me once you use this
option

Is This Answer Correct ?

2 Yes

1 No

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

Answer / jansi

Select query result option is not available in Web-I

Is This Answer Correct ?

3 Yes

2 No

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

Answer / 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

More Business Objects Interview Questions

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers

what is the core universe and what is the active universe?

1 Answers

What is pragma?

1 Answers

What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers Reliance,

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers

how to improve the performance of the report