Error for dynamic query items in DQM-based model

[ordotan]

Hi,

Hi all,

I had converted my model to work in the DQM mode (to work with JDBC data source) and now I'm getting an error for all of my dynamic query items which depends on some varaible.

For example :

#'[RadcomDB].[AGG_GN_NE '##prompt('TableKey','token','5m')##'].[NETWORK_NAME]'#
This expression is valid, and being translated to
[RadcomDB].[AGG_GN_NE 5m].[NETWORK_NAME], which is a valid location in my model.

When testing it (with the "play" button), I"m getting the following error -

XQE-V5-0005 Identifier not found '[RadcomDB].[AGG_GN_NE 5m].[NETWORK_NAME]'

Any ideas  ?