OBIEE Reports level Real time project requirement with sql

HI Folks ,

                How are You!!!!!!!!!!


I had one of the my project one scenario in inventory project.The user asking for the customize data as per seems to  Business data calculation in reporting.

I know your confused !!! dont warry i will explain with images ok

• In technical it is called word Write back table
• The write back table means , we provided the write back  table with report(i.e with credentials like username and password,url for the report.
• they  people enter the  manually some value.
• and accepted the some results based on that input

• A bove the shows  the diagram for the business requirment.
• If the customer enter the value manaually for write back  report  Eg: report for customer 
• for example customer enter the value 10,in first coulmn cust_column,once enter the data it's automatically reflected in main business requirement report.
• actaully we are took the example for  business requirement calculation :
• Business_column=cust_column+10.
• resut for Business_column=20
• This Requirement full fill the Triggers in data base
• we can used this query in reporting level,anlyzed

our local data base practice to understanding for us:

•  I am used the oracle  sql developer.
• First create the table WRITBACK_TAB

CREATE TABLE  WRITBACK_TAB 

   ( CUST_COLUMN  NUMBER(10,0),

BUSINESS_COLUMN  NUMBER(10,0)

   )

• once create the table after that ,create the trigger
• create or replace TRIGGER db_trigg
•  AFTER 
• INSERT OR UPDATE
• of Cust_column
• ON writback_tab 
• BEGIN 
•    update writback_tab set BUSINESS_COLUMN=Cust_column+10;
• END;

Now the Trigger create. after that we can go to the particular table

1. Once click the table it comes like this below shows figure.

• we can observed the data tab in two columns no data
• once enter the value '10'in cust_column  then automatically come to Business_column value '20'
• Befor enter the values we can click the insert row (ctrl+l)