Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7903 Views
- I also Faced
- E-Mail Answers
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 |
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
How many universe dfi you create if you have 2 years of experience in BO
Explain when to use local filter and when to use global filter?
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
What is the use of Surrogate Key in BO?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
1.what is context? How u create? With example.
can i use stored procedure in webi?
What is the aggrigate navigation ? can anybody explain me with some practical example?
Teradata 
