Skip to Content
0
Former Member
Nov 05, 2012 at 10:04 AM

Performing Boolean Operation on Characteristic

89 Views

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.