topic Re: master dimensions in App Development

master dimensions

johndoub — Sat, 26 Oct 2019 22:52:33 GMT

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 — Mon, 28 Oct 2019 11:37:22 GMT

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 — Mon, 28 Oct 2019 12:13:39 GMT

You may specify all stores which you need in an IF

For example

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

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

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