Drill down with caculation different for each level

• jacques.dubois

  Grasshopper

  Points: 17

  More actions

  August 12, 2013 at 6:49 am

  #297497

  In a cube I have a measure that is aggregated in function of its level in the hierachy : for exemple my hierachy is Year, Quarter, Month.

  The aggregated value on Year is the sum of the values of first month of this Year,

  the aggregated value of the Quarter will be the sum of the values of the first month of this Quarter,

  the aggregated value of the Month will be the sum of this month.

  How can I obtain these aggregations ?

  Thank you for your help.

• Scott Murray-240410

  SSCarpal Tunnel

  Points: 4649

  More actions

  August 13, 2013 at 5:07 am

  #1640860

  you might want to take a look at the Business Intelligence Time Intelligence Wizards. It can generate the calculations for many of these values.