Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Write Back Error in OBIEE 12.2.1
Answers
-
-
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
0 -
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
0 -
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.
0
