Skip to Content
0
Former Member
Jun 28, 2009 at 10:14 AM

Basic Cube behaviour question

37 Views

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