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

Can we create universe with no cache??

2192


How we drill up week to month?

833


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1777


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2063


Explain the difference between union and group?

852


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

861


How to generate the report from excel sheet?

879


What is package in BO

2958


Explain is data mart?

781


In banking domain how many Fact tables,Dimension table are present?

8599


What is the difference between datawarehousing and businessintelligence?

879


8. How much supervision have you typically received in your previous job?

2039


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

1649


What is the profile and package?

2089


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4091