Heya bit of a newbie to OLAP and am hoping this hasnt been answered.
I have a cube that has been setup with client geographic/sub region hierarchy. It also has a sex and agegroup groupings attached... I want to create a calculated measure for future projected populations using a link to an underlying projection table.
eg
Underlying Cube Fact Data
2004 2010
[Geo region] [sex] [age group] [pop] [pop]
region a M 1 10 x
projection table has the following:
[geo region] [sex] [age group] [2004] [2005]... [2010]
region a M 1 100 102 110
region a F 1 90 95 100
where the calculated measure would have a link by geo region, sex and age group and accordingly in above example would mean x = (110/100)*10 giving calculated measure of 1.1
anyone have any ideas?
Cheers
I have a cube that has been setup with client geographic/sub region hierarchy. It also has a sex and agegroup groupings attached... I want to create a calculated measure for future projected populations using a link to an underlying projection table.
eg
Underlying Cube Fact Data
2004 2010
[Geo region] [sex] [age group] [pop] [pop]
region a M 1 10 x
projection table has the following:
[geo region] [sex] [age group] [2004] [2005]... [2010]
region a M 1 100 102 110
region a F 1 90 95 100
where the calculated measure would have a link by geo region, sex and age group and accordingly in above example would mean x = (110/100)*10 giving calculated measure of 1.1
anyone have any ideas?
Cheers