Working with data field that contains separator

[jackmaster]

Hello everybody,

I have a problem working with data field that use separator in Framework Manager and I would like to ask for your help. Let me explain this:

In my model, I have a data field "Design" that describes the names of design (separated by ; ) which the users use :
UserID   ....    Design
1                    A;B;C
2                    A;B;D;E
3                    E;F;A
...

In my DB, I don't have any other table that contains the values separated of "Design" so I want to create a data item in my model that contains all the names of design like: A, B, C, D, E, F... from this data field "Design" so that in Report Studio I can create a filter for my report like:

[ ] A
[ ] B
[ ] C
...

which help me filter the users that use the selected design.

I think of using a macro function "split" in Framework Manager to return the array of separated value :
#csv (split( ';' , [Consolidation View].[Users].[Design] ))#

But I have this error, it seems I cannot use the data field direct in the function:
QE-DEF-0260 Parsing error before of near position 21 of '#csv (split( ';' , ['

Do you have any suggestions about how to use the split function or any other idea to implement this requirement?

Thanks in advance!