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
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 |
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 |
What is a category?
what is optional prompt in boxi r2
what is isolated joins in check integrity
what are the all possible reasons of getting partial result on a webi report?
What is a Set?
What is recurring sheduling and batch scheduling?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
Explain is there any default username & pwd for bo designer & supervisor?
How would I achieve Traffic Lighting in Business Objects
what is the difference b/w star and snowflack schema in dataware house?
what do u mean by variable functions ?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....