I have the following SQL datasource:

Code:
exec [dbo].[CREATE_EXCEL]  'select * from cf.Revenue where iou_latam_head = ''''Tushar Parikh'''''
If I have hardcoded the query in the Pentaho CDE datasource, my stored procedure works and creates an excel.

I cannot however, replace this string with a variable to make it dynamic.

Code:
exec [dbo].[CREATE_EXCEL] ${query}
I have tried to put the variable query, the following values:


  • select * from cf.Revenue where iou_latam_head = ''''Tushar Parikh''''
  • 'select * from cf.Revenue where iou_latam_head = ''''Tushar Parikh'''''
  • select * from cf.Revenue where iou_latam_head = ''Tushar Parikh''

Nothing works...

Please your guidance.