Question:
Hi,
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.
Regards
Answer:
For Current Month Date , you can use SAP Exit variable
In Current Month ,less than today date
For Selected Month ( History ) u may need to write ABAP.
Please inform if need more help.
Cheers
Martin
Answer:
Hi,
I am not sure how to do the Month to Date and Year to Date Aggregation of amount if the underlying cube currently stores data by each day. Could you please help out?
Regards
arv