COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: ordotan on 26 Aug 2014 08:24:55 AM

Title: Error for dynamic query items in DQM-based model
Post by: ordotan on 26 Aug 2014 08:24:55 AM
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  ?