Hi, i'm using Analysis Services/SQL server both with SP4, and i have a view with data.
The cube is working fine, but now i have to build a new dimension(parent-child). All my other dimensions are star schema based on the view.
In the column of the data i have data like "abc;def;ghi;" or "abc;ghi;" and i want to filter data based on this values:
abc
def
ghi
this values are in a table.
When i choose in the dimension "abc;" i want to filter not with an equal but with a like( like in SQL)
is it possible?
many thanks
ruimsp
The cube is working fine, but now i have to build a new dimension(parent-child). All my other dimensions are star schema based on the view.
In the column of the data i have data like "abc;def;ghi;" or "abc;ghi;" and i want to filter data based on this values:
abc
def
ghi
this values are in a table.
When i choose in the dimension "abc;" i want to filter not with an equal but with a like( like in SQL)
is it possible?
many thanks
ruimsp