Regd Query preselection exclusion

[Former Member]

Hi All,

I have a query to run for top 10 customers buying top 10 materials. I acheived this by picking up preselection values from two queries based on sales volume and the customer who purchased it.

This is working perfectly fine.

Now on the same Query I want to make a new scenario, which is Top 10 customers not buying Top 10 materials, for which I am in no position to make out this work on.

Can any body suggest how to attain the same.

Cheers

Sabita

[former_member184494]

Sabita ,

you could look at :

1. Have a pre query that returns a value set for top 10 materials ,

restrict the query based on the above value set but run an EXCLUSION on the same and not an inclusion.

Arun

Awarding points is a way of saying thank you on SDN

[Former Member]

Hi Arun,

Iam also in the same team and would like to explain the scenario in more detail. We already have a pre query which returns Top10 materials.And we have created a Replacement path variable for that query result. But, when we are using that variable in the query we are not getting 'Exclude from selection' option. We are not sure whether its the Bex functionality. If thats the case then how shall we proceed?? All comments are welcome.

Uma Mahesh

[former_member184494]

Uma ,

Really sorry that I led you on a wild goose chase , I just checked it myself and it does not allow the same ..

Arun

[Former Member]

Ok Arun,

can you tell me one thing,Value set values are stored in which table.

Thanks,

Uma.