How do I enable write back in Obiee 11g?
Open the saved analysis > table view > edit view > Table view property > Write Back tab > Select enable Write Back and provide the name as wb_prod_attribute (Saved WebMessage name in the xml). Save the Analysis. With this step, we have completed the configuration of Write Back in OBIEE.
What is Obiee 12c writeback?
“Writeback” – presenting an Answers interface so that users can update data in database tables or insert new rows – first appeared in version 7.8. 4. To use OBIEE’s writeback capabilities, there are several set up steps.
How do I enable usage tracking in Obiee 12c?
To configure usage tracking:
- Open the repository in online mode.
- Import the S_NQ_ACCT and the S_NQ_DB_ACCT table from the RCU schema.
- In the NQSConfig.
- Import the following tables to track query statistics related to the initialization block execution and the summary advisor feature:
What is usage tracking in Obiee 11g?
When usage tracking is enabled, the Oracle BI Server collects usage tracking data for each query and writes statistics to a usage tracking log file or inserts them directly to a database table. For the purposes of this tutorial, you will use a database table, which is the recommended leading practice.
What is usage tracking in Obiee 12c?
Usage tracking in OBIEE 12c is very similar to that in 11g, which enables mainly administrative users to track all reports being run and queries fired to the database. It is also very helpful in identifying and analyzing objects that require better query performance.
What is usage tracking in OBIEE 12c?
How to configure write back in obiee 11g?
Please follow the steps listed below to configure Write Back in OBIEE 11g. Step 1: Physical Layer – From Physical Table Properties Go to-> General tab dialog box. Uncheck Cacheable Step 2: Business Model & Mapping Layer – Logical Column Properties Go to-> General tab. Check Writable option.
How to enable writeback for a template in Salesforce?
Step 1 : Give Privilege to the Role for Write Back ( Administration -> Manage Privilege -> Write Back & add the role for writeback privilege). Step 3: Now edit Table Properties view -> writeback & check ‘Enable Write Back’ & mention Template Name as mentioned in writeback file ( WebMessage name= “WriteBack_Template_Name” ).
Where to place writeback template in custommessages?
To place this template, there’s a slight change in location than that was in 11g version. There is no default directory named customMessages where we are supposed to place WriteBack templates. You must also include SQL commands to insert and update records.
How to enable lightwriteback in Oracle BI presentation services?
Step 1: Enable Write Back. Add the LightWriteback tag within the serverinstance tag of instanceconfig.xml file ( file path – $ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1 )
