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?
