Why is a new column/field to data model SQL not available to the template (123fields)
BI Publisher 12C
My experience is limited with no formal training.
I need to modify an existing report that requires adding fields to my data model SQL and adding these additional fields to the report template. (I am using the MS Word plug-in).
- Copied the data model/SQL and report(rtf) from a production region to my local folder.
The new fields are derived from the same input parameter which is a four byte year. examples below: - (SUBSTR(:P_TAXYR-2,3,2) ||'/'|| SUBSTR(:P_TAXYR-1,3,2)) AS PY1,
(SUBSTR(:P_TAXYR-1,3,2) ||'/'|| SUBSTR(:P_TAXYR,3,2)) AS PY2,
SUBSTR (:P_TAXYR-1) AS PRIORYR
0