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

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

1634


Is there any other repository domains rather than universe, security, document?

806


is it possible to export the webi reports to crystal reports?with out using businessview?

2042


Explain what are the steps to do to use alerts in bo?

806


Can we create universe with no cache??

2175


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1692


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3566


How to open a universe with out using the Designer ??

7038


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1807


Explain how many universes can be created in a project?

820


What are the data types present in bo? What happens if we implement view in the designer and report?

803


What are all difference between business objects 6.5 and xi r2?

800


how to create metric universe ?

2090


can anybody tell me about complicated object you have created

2972


What is the difference between datawarehousing and businessintelligence?

853