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.

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

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

0 Answers   iNautix, Wipro,


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  


can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,


9.what are the multidimensional analyses

4 Answers   TCS,


Analysis in business objects?

4 Answers  


Difference between b.o 5.1 and 6.1b?

0 Answers  


what is static filter and dynamic filter

1 Answers  


please anyone explain me the derived table with the problem tables.

1 Answers   CTC,


what is the difference between breaks and sections?

3 Answers   IBM,


What is thin client And thick client..?

2 Answers  


Explain what would you consider as your biggest achievement and why?

0 Answers  


Difference between scope of analysis in webi and in deski?

1 Answers   CA,


Categories