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.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which command using Query Analyzer will give you the version of SQL server and operating system ?

4428


Differences between business objects and web intelligence reports?

801


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2799


how many reports have u created ? explain a few.

1811


What is the functional & architectural differences between business objects and web intelligence reports?

2086






how to create metric universe ?

2054


How to restrict password to a user while sending a document in .pdf format

2007


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

853


What Is Snow Flake Schema?

827


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1183


What we need to discuss with designer before starting the universe designing.

1969


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9730


what will be the contents for a functional requirements specifications

1989


What is the difference between slice and dice and cross tab report?

770


What sort of existing documents should business analysts refer to when starting on a new project?

752