SQL Server Performance

create custom rollup formula

Discussion in 'Analysis Services/Data Warehousing' started by vulcanoro, Jun 30, 2004.

  1. vulcanoro New Member



    I've created a custom rollup formula for the year and month level of time dimension as follows :

    [Time].CurrentMember.LastChild

    If is possibile i would like to create a custom rollup formula for the day level, so when i select multiple days i want to display the last value from the selected days.

    Can anyone help me?
  2. Raulie New Member

    You can accomplish this at any level of a time dimension using the PrevMember function in MDX.
    Example...
    ([TIME].CurrentMember.PrevMember,[my measure])

    In [my measure] I am refering to the value you want displayed.

Share This Page