Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure if this will make any difference, but can you try adding DISTINCT?
SubStringCount(Concat(DISTINCT Dimension_Pick, '|'), 'Supplier')
Not sure if this will make any difference, but can you try adding DISTINCT?
SubStringCount(Concat(DISTINCT Dimension_Pick, '|'), 'Supplier')
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) ?
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
Sunny,
thank you very much, solved!