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

OBIEE 11g Writeback Question

Received Response
96
Views
12
Comments
2»

Answers

  • Md. Altas
    Md. Altas Rank 3 - Community Apprentice

    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 !!!

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

    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,