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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculated Measure utilising population projections

Status
Not open for further replies.

c0redumpt

Programmer
Feb 16, 2003
6
AU
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top