Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Data Mining

'LIKE' function in SSAS ?

how can i filter rules in a dmx query ?

NODE_CAPTION LIKE '%something%' doesn't seem to be recogenized by ssas..

help plzz

[147 byte] By [ManagedSnake] at [2008-2-15]
«« No compatibility view for sysproperties
»» Reading data from Excel file
# 1

No, the LIKE operator is not supported in SSDM 2005. A possible workaround is to use a UDF (user defined function) to perform the filtering. See http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/3100.aspx for more details.

thanks

BogdanCrivat at 2007-9-9 > top of Msdn Tech,SQL Server,Data Mining...
SQL Server
Data Mining

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified