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}

0

Hi – thanks for the info. I’m trying to use Datalink now, I can add conditions to the Qualifiers pane in the Datalink Wizard, but I’m not sure what syntax to use to be able to refer to a Quantrix matrix, rather than another element from the imported file.

I don’t see any info about that in the manual section 12 about Datalink. Can you give an example of such a syntax?

0

Hi – This would require DataNAV to be able to use expressions in the qualifier area. While DataLink has this feature, it is not yet supported in DataNAV. I will add your vote to this request in our database.

If anyone else has a different approach to this use-case please feel free to post.

-Mike