Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Studio Crosstab with changing Dimension

Status
Not open for further replies.

Crurraca2010

Programmer
May 12, 2010
2
0
0
ES
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top