Crurraca2010
Programmer
Hi,
I am trying to build a "SCD dimension" with surrogate key in BI 8.3, I have:
Dimension
==========
ID_Dim BK_LEVEL3 BK_LEVEL2 BK_LEVEL1
1 BK1_L3 BK1_L2 BK1_L1
2 BK2_L3 BK1_L2 BK1_L1
3 BK3_L3 BK2_L2 BK1_L1
4 BK1_L3 BK2_L2 BK1_L1
FACTS
==========
TIME ID_DIM MEASURE
01/01/2010 1 10
01/01/2010 2 20
01/01/2010 3 30
01/02/2010 4 15
01/02/2010 2 20
01/02/2010 3 30
So, in 01/01/2010 dimension is:
BK1_L1
BK1_L2 BK2_L2
BK1_L3 BK2_L3 BK3_L3
And in 01/02/2010:
BK1_L1
BK1_L2 BK2_L2
BK2_L3 BK3_L3 BK1_L3
In a crosstab in Report Studio the element BK1_L3 is duplicated, and I need to consider that it's the same element:
Crosstab:
Time ( month)
MEASURE 01/01/2010 01/02/2010
BK1_L3 10
BK2_L3 20 20
BK3_L3 30 30
BK1_L3 15
and aggregations by year are wrong too:
Time ( year)
MEASURE 2006
BK1_L3 10
BK2_L3 40
BK3_L3 60
BK1_L3 15
I know they are different elements in BD because of the Id, but is it possible to aggregate by label instead Id?
Thanks,
Cristian
I am trying to build a "SCD dimension" with surrogate key in BI 8.3, I have:
Dimension
==========
ID_Dim BK_LEVEL3 BK_LEVEL2 BK_LEVEL1
1 BK1_L3 BK1_L2 BK1_L1
2 BK2_L3 BK1_L2 BK1_L1
3 BK3_L3 BK2_L2 BK1_L1
4 BK1_L3 BK2_L2 BK1_L1
FACTS
==========
TIME ID_DIM MEASURE
01/01/2010 1 10
01/01/2010 2 20
01/01/2010 3 30
01/02/2010 4 15
01/02/2010 2 20
01/02/2010 3 30
So, in 01/01/2010 dimension is:
BK1_L1
BK1_L2 BK2_L2
BK1_L3 BK2_L3 BK3_L3
And in 01/02/2010:
BK1_L1
BK1_L2 BK2_L2
BK2_L3 BK3_L3 BK1_L3
In a crosstab in Report Studio the element BK1_L3 is duplicated, and I need to consider that it's the same element:
Crosstab:
Time ( month)
MEASURE 01/01/2010 01/02/2010
BK1_L3 10
BK2_L3 20 20
BK3_L3 30 30
BK1_L3 15
and aggregations by year are wrong too:
Time ( year)
MEASURE 2006
BK1_L3 10
BK2_L3 40
BK3_L3 60
BK1_L3 15
I know they are different elements in BD because of the Id, but is it possible to aggregate by label instead Id?
Thanks,
Cristian