Hi Gurus,
I've a requirement of creating a query on the cube, to populate the materials, where either of the product hierarchy attribute is not assigned.
Like if category, sub-category, brand or sub-brand either of the attribute is not assigned, those values should be displayed.
I've created a query on the infoprovider, in columns I've operating profit. This is done to ensure that only those materials will be considered were the operating profit is present.
Now, when I restrict the Free Characteristic Category, Sub-category, Brand or Sub-brand with the fixed value "Not Assigned", I do get the results only when all of the characteristic are not assigned.
But this is not what i want, the requirement is to display the material if any of these characteristics are not assigned.
Please help me and do let me know how this can be achieved.
Thanks & Regards,
Ratin.