DataNav Qualifier issue

3.68K viewsDataLink
0

Does anyone know whether it is possible to use elements utilizing Quantrix references in DataNav Qualifiers.

Let me explain:
I want my users to be able to select a forecast from a list of forecasts in a DB using the forecast name.

I then want to use DataNav to pull in the forecastparameters, for the selected forecast, so I want to use DataNav Qualifiers to select only the forecast from the datasource that matches the user-selected Forecastname.

Anyone have any ideas how to address this?

0

Hi – In the qualifier area the syntax would be:

{MatrixName::ItemName}

If you look at the SQL panel of DataLink wizard you can also enter it directly on this screen. It would look something like:

WHERE databaseValue = {MatrixName::ItemName}

You are viewing 1 out of 3 answers, click here to view all answers.