Apply/Revert/Done buttons are not visible - Write Back OBIEE 12c — Oracle Analytics

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

Apply/Revert/Done buttons are not visible - Write Back OBIEE 12c

Received Response
52
Views
6
Comments
3051163
3051163 Rank 2 - Community Beginner
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

Hi All,

I am implementing Write Back Feature in OBI 12c.

In Analysis, Table properties, when I check "Enable Write Back" Apply/Revert/Done buttons are not visible.

Able to enter/edit text but not able to apply changes as buttons are unavailable.

Various attempts have been made, but no luck.

Any suggestion would be highly appreciated.

Thanks in Advance.

Answers

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

    Lets check "writable" in logical column

    Screen+Shot+2016-11-25+at+12.11.00+AM.png

    Check the permissions

    Screen+Shot+2016-11-25+at+12.20.37+AM.png

    Screen+Shot+2016-11-25+at+12.12.59+AM.png

    Screen+Shot+2016-11-25+at+12.25.34+AM.png

  • 3051163
    3051163 Rank 2 - Community Beginner

    Thanks cesar for the advise, Logical column was configured properly.

    I have re-checked permissions, Column and table properties at RPD and Analytics, still not able to view the Buttons.

    Analysis.PNG

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

    I think there is something with the new version of obiee 12c

    I tried with chrome and Safari and when you are in "Edit" mode the button dissapear,

    Screen Shot 2017-01-18 at 8.49.29 AM.png

    However if you already set up your writeback analysis object ( set up the template that you use in your custommessages path), to see the button just clic in the "open" button of your analysis object

    like this:

    Screen Shot 2017-01-18 at 8.52.16 AM.png

    The button are present:

    Screen Shot 2017-01-18 at 8.50.04 AM.png

    Screen Shot 2017-01-18 at 8.53.22 AM.png

    Check also the certification matrix in this link http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1213certmatrix-2226694.xls ( client tab in the excel).

    I don't test it with  IE and the version OBIEE that I using is  OBIEE 12.2.1.2.0

  • 3051163
    3051163 Rank 2 - Community Beginner

    Thanks a ton for the reply.

    I believe there was a issue with reflection of RPD changes to Analytics.

    I have created a new table with same settings(Writeback), it worked for both new and existing.

    Meanwhile there was a server restart, so not sure what was the issue.

    Now the actual problem is, I am getting below error:

    "An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator"

    System:

    MS SQL server database

    Oracle Business Intelligence 12.2.1.0.0

    XML File:

    <?xml version="1.0" encoding="utf-8" ?>

    <WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

    <WebMessageTable lang="en-us" system="WriteBack" table="Messages">

       <WebMessage name="WB_Test">

          <XML>

             <writeBack connectionPool="Connection Pool">

                <insert> </insert>

                <update>UPDATE WB SET COMMENTS='@{ce374fe936da06edc}' WHERE id=@{cf11242553a7dfdf3}</update>

    <postUpdate>COMMIT</postUpdate>

             </writeBack>

          </XML>

       </WebMessage>

    </WebMessageTable>

    </WebMessageTables>

    Currently, I have Admin rights and I strongly believe I have configured properly.

    I have tried various changes to XML file, but the problem still exists.

    It would be great if anyone could assist with the above issue.

    Thanks in advance.

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

    OK this is another question I will answer in your new thread..

  • Dirk - JEM
    Dirk - JEM Rank 3 - Community Apprentice

    I face the same problem - and it's an error by Oracle BI. I think it comes with the new Alta UI.
    If you run this Answer in a Dashboard or if you use "Show as it looks in a Dashboard", then you will see the Buttons.


    I've opened a SR and the guy from the support says he cannot replicate even if I have exactly the same behavior in 5 different customer environments - I don't put any effort in this Oracle Support thing ...