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
- Thread starter alexaweb
- Start date
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
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