Obiee 11g Write Back Error Log
Contents |
configure for write back: 1.Create aphysical table in the database how to implement writeback in obiee 11g that has a column for each write-back field needed.
The System Is Unable To Read The Write Back Template
In the table create statement, make the write-back fields non-null-able.Note:For optimum security, store write-back
Writeback In Obiee 11g Tutorial
database tables in a unique database instance.2.Use the Oracle BI Administration Tool to configure the new table, as described inOracle Fusion Middleware Metadata
Obiee 12c Writeback
Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.3.Create awrite-back template that specifies the SQL statements that are necessary to both insert and update values into the table that you created. For more information, seeSection 19.8.3, "About the Write-Back Template."4.Add the LightWriteback element in the instanceconfig.xml file, obiee writeback example as described inSection 19.8.2.1, "Setting the LightWriteback Element."5.In Oracle BI Presentation Services, grant the following write-back privileges to the appropriate users: Manage Write Back and Write Back to Database.For information, seeSection C.2.3.2, "Setting Privileges in Oracle BI Presentation Services Administration."6.Configure a write-back analysis, as described inOracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.19.8.2.1Setting the LightWriteback ElementIn order for users to write back values, you must manually add the LightWriteback element in the instanceconfig.xml file. Before you begin this procedure, ensure that you are familiar with the information inSection 3.4, "Using a Text Editor to Update Oracle Business Intelligence Configuration Settings". To manually set the element for write back: 1.Open the instanceconfig.xml file for editing, as described inSection 3.6, "Where are Configuration Files Located?"2.Locate the ServerInstance section in which you must add the LightWriteback element.3.Include
here for a quick overview of the site Help Center Detailed answers to obiee 11g writeback insert any questions you might have Meta Discuss the workings and obiee writeback insert policies of this site About Us Learn more about Stack Overflow the company Business Learn more writeback xml path in obiee 11g about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community http://obiee10grevisited.blogspot.com/2012/02/write-back-in-obiee11g.html Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Write Back Form in OBIEE up vote 0 down vote favorite I created a write back form that incorporates an XML template. Can somebody please let me http://stackoverflow.com/questions/29146001/write-back-form-in-obiee know what is wrong with my code? All the write back features have been enabled so I believe my syntax in the form is not valid.
Intelligence (OBIEE/Siebel Analytics) OBIEE 10G/11G - Writeback Capabilities (Table of Pivot) OBIEE 10G/11G - Writeback Capabilities (Table of Pivot) Table of Contents 1 - Introduction 2 - Articles Related 3 - How to http://gerardnico.com/wiki/dat/obiee/write_back 3.1 - Security, Privileges 3.2 - Configure Write Back Report 3.2.1 - Instanceconfig.xml 3.2.2 - Table properties 3.2.3 - Column properties 3.3 - Write Back Template to define the DML statement 3.4 - When http://rajeshthomas.blogspot.com/2012/08/writeback-analysis-in-obiee-11g-part-1.html the update and insert statement run 3.5 - How to update 4 - Support 4.1 - Log 4.1.1 - sawlog 4.1.2 - nqquery.log 4.1.3 - nqserver.log 4.2 - Reload the change online 4.3 - obiee 11g 10G: the Update Button is grey 5 - Documentation / Reference 1 - Introduction Write Back is the ability to enter values directly into a report and have those values used in calculations and charts in the report. For example, a report can have Sales Quota Amount defined as a write back field, Sales Amount as a field from the data warehouse, and Percentage of Quota as in obiee 11g a calculated field (Sales Amount/Sales Quota Amount). When viewing the report you can change the Sales Quota Amount and the Percentage of Quota field recalculates appropriately. This document give a step-by-step guide with picture to help the implementation of this functionality. You can use this functionnality only in a table view. If you want to use it on a pivot, you must first transform your table view as a pivot view : OBIEE - How to perform a pivot in a table view For 11g, you must now explicitly select the Writeable option for each logical column for which you want to enable write-back. 2 - Articles Related OBIEE 10G/11G - Answer/AnalyticsOBIEE - Pivot Measures (The Filter Function)OBIEE - Custom MessagesOracle Business Intelligence (OBIEE/Siebel Analytics)OBIEE - Table view 3 - How to 3.1 - Security, Privileges First, you must grant your account with the privilege “Write Back to database” : Login in OBI Presentation Service Website Follow this links : Setting / Administration / Manage Privileges Grant the privilege “Write Back to database” to the permitted group Second, you must grant the direct access database to the user through the Administration Tool in the security part. Login in OBI Administration Go
that is displayed in an analysis in oracle answers. very crude way of putting it. Please refer to the OBIEE docs from Oracle for the limitations. Interestingly, this contradicts the basic concept of an OLAP system, which is primarily meant for fetching data rather than inserting data. However there are some special cases, where you would want this functionality. There are certain design considerations too that are involved with the data warehouse, which we will discuss in another post. I'm creating a demo table for this purpose create table JT_DEMO_WRITEBACK( CUST_KEY NUMBER PRIMARY KEY, CUST_NAME VARCHAR2(255) NOT NULL, CUST_RATING NUMBER NOT NULL); lets insert some data to look like this: Login to Oracle Answers. got to Administration page. Under security click the "Manage Privileges" link change the "Write Back to Database" privilege start the BI Admin Tool and open your rpd. In the physical layer, create a new connection pool called "WB Connection Pool". Import this table. create an alias for this table. disable caching on your physical table that you want to write back to. create a new Business Model to look like this we want the Customer Rating field to be editable(writable) in our Answers page. Create the new subject area in the presentation layer as shown below. for simplicity purpose, I'm setting an implicit fact for the WB Test Subject area. set the permission to read write for the relevant users save your rpd and check for consistency. Enable writeback in the configuration file by Modifying the instanceconfig.xml file located in $(ORACLE_INSTANCE)\config\OracleBIPresentationServicesComponent\coreapplication_obips1 add the following to the instanceconfig.xml file