I have got amount field ( KF: AMOUNT) stored in my cube by date (POST_DATE). The user has a input variable where he can put in any date he wants in a BeX Query.
The Query needs to show Month to Date (MTD) and Year to Date (YTD) amounts based on the input date the user puts in.
How do we do this.
Any help deeply appreciated.