self service / ad-hoc table

[ilanbaruch]

hi all,

i have a self service table based on 35 conditional dimension:

SubStringCount(Concat(Dimension_Pick, '|'), 'Supplier')

i added another dimension and is working good (as expected) on developer but when i update the model into access point

it is not showing the dimension in the table.

tried to change the name in the dimension list still not working ..

any ideas??

advanced thanks

[sunny_talwar · Accepted solution]

Not sure if this will make any difference, but can you try adding DISTINCT?

SubStringCount(Concat(DISTINCT Dimension_Pick, '|'), 'Supplier')

[settu_periasamy]

Is only one dimension not showing (newly added) or entire dimensions not showing?

Can you check the dimension name(assume you are loading labels via external file -excel) ?

[ilanbaruch]

all is working as usual, only the new one is not showing and only on access point.

on developer its working

all names is in the script, no excel

[ilanbaruch]

Sunny,

thank you very much, solved!