Error solving for SQL Server data sources using macro functions in the framework

Environment: DW is SQLServer2008

Modeling tools: Cognos FrameWork

version:cognos10.2

Problem: Create query topic in FM, SQL type data source, introduce macro function #camidlist () # Verify the model directly with the following error

Workaround, in the #camidlist () # function coat with the SQ function, as shown below

#sq (Camidlist ()) # like '%u:cn= ' +user_id+ ' "% '

OK problem solving

The main purpose is to convert the object before and after the like into the value of the string and then like

Error solving for SQL Server data sources using macro functions in the framework