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!

MDX age calculation

Status
Not open for further replies.

alexaweb

Programmer
May 11, 2001
12
0
0
CL
Hi, I have a cube with birthdate dimension for my users. How can I make a calculated dimension such that it will store each users' age on runtime, so that every new day the age is updated??

Thanks in advance
 
Hi, Alexaweb!
I know this is a very rough method to solve this problem but...
Create a view based on the fact table with the birthdays and all the other fields of the , this view should contain age = now date - user's birthday.
Base your cube on this view as fact table.

My best regards, Issahar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top