SQL Server Performance

how to avoid the report from total up the value?

Discussion in 'Analysis Services/Data Warehousing' started by biru, Jun 4, 2007.

  1. biru New Member

    Hi everyone...i've created an olap report using the pivottable in excel which contain data like opening and closing balance...the closing balance for today will be the opening balance for the next day...the report is correct if i select data based on day..but there's problem when i select data based on month or year, the report will total up the opening balance of that month/year, which is wrong...the opening balance of that month suppose to be the same as the closing balance of the day before..so what should i do so that the report will always take the closing balance as the opening balance?..is there anything i need to do with the cube?..thank you.
  2. Raulie New Member

    You can use the ClosingPeriod MDX function in a Calculated member at the month level.

    Raulie



Share This Page