Skip to main content

Trying to create a QIS Draft that utilizes the “_CFV” version of the table so that the Custom Fields are available.  However, due to the fact that a “CF$_” is prepended to the field name and the Created View Definition is not editable to change an alias, the field comes into the Information Source with the CF$_ prefix, which I thought was fine.

 

And the field is visible in the BR, but if you try to put a filter on the field, it errors out, indicating that QFACT_XYZ_CFV.CF is not a dimension or fact.  It appears that the $ in the db field name is being evaluated as a parameter and making BR blow up.

 

Other than writing an IAL where I can alias the field correctly, does anyone know how to get around this issue?

Hi @jghall 
What is the UPD level you are using?
If it's below APPS9 UPD 12 , IFS Solution 260296 will resolve this issue.
If so please create a support ticket to IFS Support, then they will investigate the issue further and proceed with this solution.

Reply


Terms & ConditionsCookie settings