Skip to Content
0
Former Member
Jan 17, 2006 at 07:29 PM

Aggregation of key figures in cube

17 Views

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