I want to create account receivable aging report from cube, in that I want to filter out measure with month and date of service.
Does any one have example?? I tried but it always receive total amount of month but not getting filter amount as per current month and date of service.
Here is my mdx query.
with member newcurrentpayment AS ( Aggregate ( {ClosingPeriod([Time].[Calendar].[Date], [Time].[Calendar].currentmember).lag(0) :ClosingPeriod([Time].[Calendar].[Date], [Time].[Calendar].currentmember).lag(30)} ,[Measures].[Actual Payment Posted] ) ) SELECT { [Measures].[Actual Payment Posted], newcurrentpayment } ON 0 ,non empty ({([Time].[Calendar].[Month].&[2019-01-01T00:00:00]: [Time].[Calendar].[Month].&[2019-03-01T00:00:00])}) on 1 FROM [INTERNALTESTING]
