Write Back Error in OBIEE 12.2.1

cesar.advincula.o

Did you consider?

'@1' :for -> string, varchar2

@1  : for -> number double

Venkata Rachuri

Hi,

Thanks for the reply. If you see my template above it has following line

INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@{c1})

@{c1}  so I am considering  for numeric data type.

Thanks

Venkat

Venkata Rachuri

Finally Figured out the issue.

This one not working

INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@{c1})

This one works.

INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@1)

God and OBIEE Development team knows why .

Thanks

Venkat

cesar.advincula.o

The @{ C1 }  syntax refers to COLUMN_ID of the XML in the ADVANCED TAB, for example @{c8557240790424dd0}

@1 syntax in your writeback,  you refers to  the position of the column @1 ( column 1), @2,.. @n.

If you use @1, i recommend to uncheck "MOVE COLUMNS", "HIDE COLUMNS" and "INCLUDE/EXCLUDE COLUMNS" because if your user moves some columns (change the position of the column), you could pass a different value, and your writeback will dont work.