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??
What I have tried:
I tried but it always receive total amount of month but not getting filter amount as per current month and date of service.
Below 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]