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!