Click here to Skip to main content
15,881,803 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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]
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900