Cross table problem

Hello,

Let me explain my problem. I have 2 data providers which bring information about the last month and 13 rolling months. The report contains a table based on the last month data provider and 2 crosstabs and 1 graph based on the 13 rolling months data provider.

The problem is that I have the Product Group dimension as section from the last month data provider and this is causing some blank lines to appear in my crosstabs.

I did a test. When i put the Product Group dimension as section from the the last 13 rolling months data provider, it simply causes chaos in my first table.

Can you please help asap please?

Hope to hear from u v soon!!

Thanks in advance,
Shamnaz


shamnaz (BOB member since 2004-04-21)

Do you bring Product Group in both the DP’s and are linked on it???


Sridharan :india: (BOB member since 2002-11-08)

Yes theyare linked!


shamnaz (BOB member since 2004-04-21)

So it looks like there some Product Group which are present in DP1 and not in DP2 and vice versa and BO does Outer Join when it links DP… Search here for Data Provider Synchronization…

Presentation can be found in the below link…
http://www.bonymaug.com/reporter.htm


Sridharan :india: (BOB member since 2002-11-08)

I am going to have a look at the presentation!! Hope it solves my prb. Thks!


shamnaz (BOB member since 2004-04-21)

It has been my experience that linked data providers, crosstabs, and sections are a pain, and just don’t work the way you want. If you eliminate one of the three, you’d be ok.


Anita Craig :us: (BOB member since 2002-06-17)

Finally, a simple filter has solved the prb. Thanks again for your link. It has helped me a lot in understanding the prb.


shamnaz (BOB member since 2004-04-21)