Hi Friends,
I have a requirement in which I need to group the Vendors into Required and Not Required based on the Vendor group. All Vendors given in selection must fall under REQUIRED and the rest all group under NOTREQUIRED . This needs to be done in frontend, that is report.
Suppose the data in cube is as
Vendor......Vendor Group.....Matl Qty
ABC..............11..................100
BBD..............13..................500
HHY..............12..................300
AAA..............44..................200
In Selection (Vendor Group=11,13)
Report should be
Grouping......................Matl Qty
REQUIRED
ABC..............11..................100
BBD..............13..................500
NOTREQUIRED
HHY..............12..................300
AAA..............44..................200
In this the end user need to get the selection
where he need to select the required group number....
so in the report the required groups must fall under REQUIRED
and the rest of all must come under NOTREQUIRED.
please through some light ...
Regrads
Sandy