Skip to Content
0
Former Member
Feb 24, 2009 at 05:45 AM

How to apply exclude on the varaible(TOP N clients and rest clients)

169 Views

Hi ,

From the past two days..I trying to solve my query but couldnt , posted two threads in SDN , but unable to get exact answer and i have planned to close that.. two threads and created new one here,

Please try to give me atleast clue, how to proceed

<Removed>

1st Query(TOP N clients) resticted by Total revenue

X 500

Y 400

Z 300

2nd query

A 50

B 30............. and so on..

All the rest other than TOP N should display in the second query and i am planning to embed this two queries in the same workbook.

I have searched in SDN and some one has. much similar problem and the clue is as follows, i have given the post.. below

The below thread says. to create a variable with replacement path and restrict the client(vendor) with replacement path variable and exclude it to get other clients(vendor), is it possible to do, do any of you tried this one,. please let me know , how to do exclude the varaible, i want step by step how to exclude, as i am not able to do this..

u00bfhow-can-separate-then-ranking-the-first-top-3

First create the simple query which will give you top 3 vendors

2. Open 7.0 query designer

3. On left panel - Info Provider - find your characteristics (vendor)

4. expand to Characteristics value variables

5. right click and create new variable

6. Specify processing type - replacement path

7 switch to next tab - Replacement path

8. Select - Replace variable with query -

9 . Specify technical name of the query created in step 1.

10. confirm other parameters and save.

Now this variable can be considered as top 3 vendors. When you restrict vendor on this variable it will be always restricted on top 3 vendors.

Now in your new query, create a selection, in which you can restrict as mentioned above to get top 3 vendors.

1. create structure

2. create selection

3. Add vendor on right hand side

4. Now restrict this vendor char on newly created replacement path variable.

This should give you top 3 vendors.

Create one more selection with same steps but use exclude property to get all other vendors.

Edited by: Arun Varadarajan on Feb 24, 2009 11:46 AM