Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Write Back Error in OBIEE 12.2.1

Received Response
244
Views
14
Comments
2»

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Did you consider?

    '@1' :for -> string, varchar2

    @1  : for -> number double

  • Venkata Rachuri
    Venkata Rachuri Rank 5 - Community Champion

    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
    Venkata Rachuri Rank 5 - Community Champion

    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
    cesar.advincula.o Rank 6 - Analytics Lead

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

    Screen Shot 2016-11-21 at 3.20.59 PM.png

    @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.

    Screen Shot 2016-11-21 at 3.18.30 PM.png