Dear All,
I have 2 Data Provider and need to insert into a crosstab table:
DP1:
Loss number
Region (East, Central, West)
Day Loss Bucket
DP2:
Prior Report Balance (I use a sub query to get this)
Region (East, Central, West)
Now I create a crosstab table with:
Region (Row)
Day loss Bucket (column: value 30, 60, 90)
loss number/prior report Balance (Body)
The results came out real small compare to what I expect. Please advise!
kyanforum (BOB member since 2009-05-22)
check dimesion objects are linked or not if dimension objects are not linked then link them…
amitrathi1234 
(BOB member since 2007-10-15)
Yes I did. I also did some investigation myself, so I created a regular table and only use the Day Loss Bucket, Loss Number, Prior Report Balance. but at the break footer, it give me the total sum not the break sum. Please look at the attachment for a screen shot. Thanks!
loss bucket.txt (0.0 KB)
kyanforum (BOB member since 2009-05-22)
can anyone help me on this? desperate!
kyanforum (BOB member since 2009-05-22)
What is merged dimension over here???
BO_User2000 (BOB member since 2008-11-18)
oh I forgot to tell you that they linked by “account number”
kyanforum (BOB member since 2009-05-22)
I got it to work btw…Thanks anyway!
kyanforum (BOB member since 2009-05-22)