BusinessObjects Board

Multiple Data Provider: need help understand

Hi,
I have to create a report with multiple data provider and I have questions:
I am linking the 2 with Account #.
One data provider has detaila bout the account and the other has details about the orders. So When I select all the account details in DP1, I cannot seelct everything I want in DP2. Why is that. The objects are greyed out.
Can someone help me with this?
I know it is basic but I need to get these greyed out values out. :hb:


aude (BOB member since 2006-05-12)

There’s a lot of information about this in the archives. For more details do a search on linking data providers. Basically you have to create variables in the report that are equal to the grayed out ones and create them as details rather than dimensions and link them to account # as a dimension. Then you can put them in your report.


Debbie Kelly :us: (BOB member since 2002-08-15)

Hi,

please have a look at this BO reporter’s FAQ as well as at this Solving the Mystery of Data Provider Synchronization presentation.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thanks!
but the problem is that if I tried to create these objects as description it is not going to work with I have more than 1 value per dimension. Like for ex I have an account # that has 2 products. If created product number has a description of the Account #, it is only going to give me one product#, not 2, right?


aude (BOB member since 2006-05-12)