How do I enable write back in Obiee 11g?

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.

How do I enable usage tracking in Obiee 12c?

To set up the usage tracking statistics database:

1. On the Oracle BI Server computer, open the NQSConfig.INI file in a text editor. You can find this file at: BI_DOMAIN/config/fmwconfig/biconfig/OBIS.
2. In the [USAGE_TRACKING] section, update the following parameters:
3. Save and close the file.
4. Restart the Oracle BI Server.

What is writeback in Obiee 11g?

Write Back is the feature/ability in OBIEE to allow the user to enter a value or values directly into a report and have those values written to an actual physical table in the database. You can use this functionality only in a table view.

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.

What is usage tracking in Obiee 11g?

1.7. 0 (11g) Why Usage Tracking: Usage Tracking is used to monitor system and ad-hoc query performance and to provide input on usage trends for use in billing users and departments for resources.

How do I turn on usage tracking in Obiee?

OBIEE 11g Usage Tracking Setup

1. Log into EM.
2. Select WebLogic Domain>bifoundation_domain from the left navigation pane.
3. Click the WebLogic Domain drop-down list in the right pane.
4. Select System MBean Browser from the list.
5. Expand Application Defined MBeans>oracle.
6. Expand bifoundation_domain.
7. Lock the domain to update it.

Is prompted in Obiee 12c?

We mostly use the Column prompt for restricting data in the reports. The column used for prompt is “is Prompted” in the report and data will be restricted based on this. There is one more prompt type named as “Variable Prompt”.

What is selection steps in Obiee?

Selection Steps in OBIEE are done on non-measure / dimension columns, using measure values. 2. To force / trick the Selection Step to work on measures values directly, we have to create a dummy column that combines all the non-measure keys, and is used as index of measure values in the analysis.

What is OBIEE usage tracking?

Introduction. OBIEE provides Usage Tracking as part of the core product functionality. It writes directly to a database table every Logical Query that hits the BI Server, including details of who ran it, when, and information about how it executed including for how long, how many rows, and so on.

How do I turn on usage tracking in OBIEE?

How do I turn on my usage tracker?

Configuring Usage Tracking in Enterprise Manager

1. Log into EM.
2. Select WebLogic Domain>bifoundation_domain from the left navigation pane.
3. Click the WebLogic Domain drop-down list in the right pane.
4. Select System MBean Browser from the list.
5. Expand Application Defined MBeans>oracle.
6. Expand bifoundation_domain.

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.

What is write back privilege in obiee presentation services?

The Write Back Privilege was granted to the ‘Authenticated User’ from OBIEE Presentation Services by selecting the ‘Administration’ link and selecting ‘Manage Privileges’ under Security. The ‘Write Back’ privilege is located at the bottom of the list of privileges.

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 )

How to update RPD on obiee 12C server?

Remove caching on Physical Table; in the RPD – Physical layer, right-click on the Physical Table and select properties, on the General tab ‘Cacheable’ was unselected. After this now we will upload this updated RPD on the OBIEE 12c server.