master dimensions

[johndoub]

i have a field "Store" that has 13 values for my 13 stores.  Can i create a master dimension that consists of 11 of these stores?

or conversely, can i set up a new field that has 11 stores?

[rubenmarin]

Hi, there are different ways of do this, you want to keep those extra 2 stores for some reason?

As an easy way to create the new field you can use:

If(not match(Store, 'StoreToRemove1', 'StoreToRemove2'), Store)

That can also be used for a master dimension, if doen't works weel you can also try with:

Aggr(If(not match(Store, 'StoreToRemove1', 'StoreToRemove2'), Store), Store)

[naumanshah]

You may specify all stores which you need in an IF

For example

pick( store, '1', '2', '3', '4', ... ,'11') > 0

OR

len(pick( store, '1', '2', '3', '4',... ,'11' )) > 0

OR

Match(store, '1', '2', '3', '4',... ,'11' )>0