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 |
Any one suggest me best SAP Business Objects XI Online Training institute from India
Tell me about a complicated object you have created?
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
what is difference between global filter an query filter in web intelligence?
Why do we need metrics and sets?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
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