Linking Data Providers , on Purge or Refresh

[system]

Hi,

I have three tables from three different data providers DP1,DP2,DP3

And i have a summary table where i need to show the sum of counts of item_ids from these three data providers …So i added all the counts from these data providers …It was giving sum different not the correct one …this is because all the data providers were linked to each other…so unlinked all the data providers , it started giving the correct result…

The problem is :----------------------------------

When the report is purged or refreshed to get the latest data …
the data providers get linked back again …and sum of counts show incorrect value…

Please see the example below…

Table summary :

count(<itemId(DP1)>) +
count(<itemId(DP2)>) +
count(<itemId(DP3)>) +

Table A

item count 10 [count(<itemId(DP1)>) ]

Table B

item count 11 [count(<itemId(DP2)>) ]

Table C

item count 12 [count(<itemId(DP3)>) ]

Is there any solution that we can permanently unlink the data providers…??

Thanks,

Chaitanya K.

---

kurtcobain (BOB member since 2006-04-12)

[system]

@Chaitanya:

The dimension objects which are getting linked migh have exactly the same name.

So one thing coming to my mind is, Can you rename the objects OR make it detail objects in your block.

Is this a solution for your issue.?

Let us know.

---

BO_Chief (BOB member since 2004-06-06)

[system]

Hi Chaitanya,

See https://bobj-board.org/t/53239

I think relinking only occurs when you open the query panel (using edit data provider) - if you avoid doing this you should be ok.

• Peter

---

Peter Hegarty (BOB member since 2004-05-04)