MDX query to calculate closedledgerbalance against time

• alokkumar_srivastava

  Mr or Mrs. 500

  Points: 508

  More actions

  October 8, 2010 at 4:17 am

  #241393

  Hi ,

  WE are facing problem to write MDX query that calculate close_ledger_balance against time dimension at day level:

  as avg(descendants([time].currentmember.children , [day]),[measure].[closeledger])

  but some how it's not giving correct value.

  Can any one please guide us .

  Thanks ,

  Alok