January 13, 2014 at 9:16 am
Hi All.
I have a cube with a standard date dimension (year, quarter, month) and one measure. Currently, the quarter figure is just a simple aggregate of the monthly measure. I need to code a custom aggregate i.e. instead of saying month1 + month2 + month3, I need something like ((month1/100)+1) * ((month2/100)+1) * ((month3/100)+1). I need to do this for each month.
My question is, how should I go about doing this ?
Is this a calculated member for each quarter ? Or could I provide a measure expression ?
I've tried so far with a calculated member without much success. I would be grateful for any pointers (code !).
Regards,
J
January 15, 2014 at 3:45 am
Have a look into the SCOPE statement it should give you the ability to do what you need:
http://technet.microsoft.com/en-us/library/ms145989.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply