Hi Experts,
I know that this may seem like a basic question but I would like to know how the Cube behaves when there are 2 datasources updating into it.
Say I have the following fields:
1. Datasource 1 : COMPANY (A) --- COLOR (Blue) --- SALES QTY (50 pcs)
2. Datasource 2: COMPANY (A) --- SALES QTY (10 pcs)
If it updates 1 cube, I understand that it will be aggregated so that if you display the total sales qty of COMPANY A:
COMPANY (A) SALES QTY (60 pcs).
However, my question is that if in your report, you decide to add a drilldown to COLOR.
Will it show as 2 records? Where 1 record shows color as "BLANK"?
COMPANY (A) COLOR (Blue) Sales Qty (50 pcs)
COMPANY (A) COLOR (#) Sales Qty (10 pcs)
How to i make it appear as :
COMPANY (A) COLOR (BLUE) Sales Qty (60 pcs).
Which is basically what i am trying to summarize. The 2nd datasource is sort of like a HEADER information only that is why there is no color breakdown.
Please advise.
Thanks guys!
Edited by: karene on Jun 28, 2009 12:14 PM