Post reply

MDX: Personal Rate of Return

  • October 15, 2006 at 11:22 pm

    #114702

    I'm currently working with SQL Server Analysis Services 2000 and would like to calculate the personal rate of return on my portfolio cube. I have calculated the return for each month and now need to multiply each month together to obtain the total % return. I.e. ((R1 * R2 * Rn) - 1) * 100

    I can't find any MDX functions which can multiply the values of many children together as in the above equation. How would I go about calculating the % return?

  • October 18, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 18, 2006 at 7:48 pm

    #666693

    A possible (ie untested )approach could be to try and get a hierarchy in to your cube that has unary operators.  Using the '*' operator should result in the rollup of the parent (in your case 'Year' rolling up the 12 months) being the children multiplied by each other.  You'd then need to take in to account your '-1 / 100) section.

    Alternatively, you could try a calculated cell approach, where you specify the slice of the cube for which the calculation is to be used and also specify the calculation.

     

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply