Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11g Writeback Question
Answers
-
1. Setting the LightWriteback Element
--> This is done and verified. No issue there.
2: You only can UPDATE or INSERT a 1 Table By
--> I am not updating multiple tables. I am updating only 1 table and only 1 column. But the Columns pulled in presentation layer are from 3 different tables.
Now typically, when OBIEE run SQL to fetch data, it used the physical joints from BMM layer to match the columns and then then fetch the combination.
For example: - Conseder following details -
Tablename - PO_INFO
Columns - PO_LINE_LOCATION_ID
ORGANIZATION_ID
SUPINFO
Tablename - PO_DETAILS
PO_LINE_LOCATION_ID
PO_NUM
When I create report with columns SUPINFO, PO_NUM
then OBIEE will match the PO_LINE_LOCATION_ID in tables PO_INFO and PO_DETAILS and then display the records in UI.
Now say I want to update SUPINFO using writeback.
I have following in my writebacktemplate -
<update>UPDATE POD.PO_INFO SET SUPINFO='@{c36281e59054c18d5}' WHERE PO_NUM='@{c9ac14dfb77047c4d}'</update>
Is writeback smart enough to match the IDs in 2 different tables and then update the column?
it is smart enough to use physicall joins in BMM layers to generate output but I am not sure if it is smart enough to use these joins during writeback.
Hope this helps !!!
0 -
Hello,
No matter, if you use a multiple joins, the thing is the '@{c9ac14dfb77047c4d}' has a value which is get for the "Table View" Object in your Presentation Services (Oracle BI Answers), finally, this value that got, go for your <UPDATE> tag code, and this do the UPDATE for a physical table (table in database), I mean the code that you have in your <UPDATE> tag, its like PHYSICAL PL/SQL code.
I dont understand, one thing:
Why do you do and UPDATE something like this:
<update>UPDATE POD.PO_INFO SET SUPINFO='@{c36281e59054c18d5}' WHERE PO_NUM='@{c9ac14dfb77047c4d}'</update>
Does your physical table POD.PO_INFO (table which resides in the database) has this columns ( PO_LINE_LOCATION_ID , ORGANIZATION_ID , SUPINFO)
And has this column PO_NUM, also, in the POD.PO_INFO table ?
Kind Regards,
0