Hi all,
I have a requirement where I’ve to link two Dataproviders based upon one dimension object. One Dataprovider is pointing to Access and another is pointing to ORacle.If both the dimension objects are equal then only the report has to execute other wise it has to raise an eror message ‘Wrong Data’. But I’m unable get the data from these two dataproviders. Please help me out as soon as possible.
Thanks in advance.
dattatreya (BOB member since 2004-06-28)
Could you eloborate on this?
Andreas 
(BOB member since 2002-06-20)
I did not get the combination of data from this. Its giving the data from the 1st dataprovider only. I hope you get my point.
Thanks.
dattatreya (BOB member since 2004-06-28)
Both data providers have as a result object only the common dimension and nothing else (such as measures etc.)?
Andreas 
(BOB member since 2002-06-20)
Have you tried created two separate blocks from two data providers and see whether they are showing data?
Idea is to make sure both of your DPs are fetching data from the database.
mkumar (BOB member since 2002-08-26)
He doesn’t even have to do that. Just do a Data - View Data - and look at the Results tab for each query. That shows you the raw results for each data provider.
Anita Craig 
(BOB member since 2002-06-17)
When you add a data provider, it doesn’t automatically put the data on the report. You have to do it yourself.
Steve Krandel 
(BOB member since 2002-06-25)
As Steve said it does not do it, all it does is show the new result set highlighted in blue, and all you need to do is drag those highlighted objects into the report.
Bharat 
(BOB member since 2004-05-03)
Thanks all,
I’m able to see the data in two dataproviders seperately, but I didn’t find the combination of both.
Like if I’ve 1 st dataprovider query like
SELECT Year,sum(Quantity_sold) FROM Agg_yr_qt_mt_mn GROUP BY Year
2 nd data provider query like
select year,today from scott.efashion
1 st query contains data like
YEAR — Qty_Sold
1999 — 50000
2000 — 60000
2001 — 70000
2 nd query contains data–
YEAR — Today
1999 — sysdate
2000 — sysdate
2001 — sysdate
2002 — sysdate
I want the result to be displayed like
YEAR — Qty_SOld — Today
1999 — 50000— sysdate
2000 — 60000— sysdate
2001 — 70000— sysdate
I hope u all get my point this time.
Thanks again.
dattatreya (BOB member since 2004-06-28)
In your example,
After linking the 2 Dataproviders using Year, in the slice dice panel drag sysdate into the table1 place it after qty sold.
This should get your expected result.
[/quote]
Ashokkumar (BOB member since 2004-05-20)