create master item dimension

[Tommmy]

Hi expert

Need to build some master items with restrictions on two dimensions. Is this possible. The following script is a sample for this challenge:

if(Account={'9900', '9901'} and CostCenter={'10', '20'}, 'ABCDE')

Any ideas?

Thanks, Tom

[kaushiknsolanki]

Yes, you can create a calculated dimension and make it a master dimension. Its possible to use the same function you have written

[Tommmy]

Thanks, but with this formula I am getting an error:

[Tommmy · Accepted solution]

solved:

=if(Account=('9900') or Account=('9901'), if(CostCenter='10' or CostCenter='20', 'ABCDE'))

[kaushiknsolanki · Accepted solution]

You can also try to use functions like Wildmatch and match like below to simplify your expression.

if(match(Account,9900,9901) and  match(Costcenter,10,20),'ABCD')