Skip to Content
0
Former Member
Jul 16, 2008 at 08:16 PM

Calculate Max Date

70 Views

Dear Gurus,

I have 0CALDAY, 0MOVETYPE and 0MATERIAL in different dimensions in a Cube. I want to display in my query Max of 0CALDAY where 0MOVETYPE = ('101', '103', '105') for each Material. I am not sure how I can achieve this in BEx.

Please advise.

Appreciate all the help.

Thanks.

Regards,

bw_newbie