on 07-16-2008 9:16 PM
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
Can you add 0Movetype to your characteristic restrictions and restrict it to the values (100, 103 and 105)
In the display properties for 0Calday select Sort according to Descending .
Would that work?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.