Friday, April 29, 2011













Unemployment Intelligence













Interest Intelligence







Thursday, April 28, 2011

Inserting data values in to database which having '&' in it.

Hi guys,

If u have an insert sql command like this

Insert into rushi_details(first_name,Last_name,emp_id,company_name) values('rushendra','prasad',1234,'rushi consulting & outsorcing')

This will not insert and prompt to enter a valuse for outsorcing as we have '&' before it. for this type of issues used this command:

set ESCAPE \
Insert into rushi_details(first_name,Last_name,emp_id,company_name) values('rushendra','prasad',1234,'rushi consulting \& outsorcing')

Then this will insert in to rushi_details table

If we inserting one or more than one keep the set ESCAPE \ before al insert statements then run.

NOTE: 'rushi consulting \& outsorcing' we are keeping \ before &.

Monday, May 10, 2010

WRITE BACK


I would like give small report on writeBack in obiee:

Im using sh schema in oracle database.
PreRequests for writeback:
  1. User must have writeBack privillegers.
  2. Direct database access privillegers.
1. FOR PREVILIGES LOG IN PRESENTATION SERVER AS "ADMINISTRATOR", THEN GO TO    "SETTINGS"------>"ADMINISTRATION".AS SHOWN BELOW.



2.NOW CLICK ON THE "MANAGE PREVILIGES"                                                                           




3.SEARCH FOR THE "WRITE BACK", IT IS THE LAST PREVILIGE IN THE LIST,SCROLL DOWN.




4. BY DEFAULT IT IS "NOT ASSIGNED "CLICK IT AND ADD "PRESENTATION SERVER AND ADMINISTRATOR" FOR BOTH AND CLICK FINISHED AND CLOSE WINDOW.

5. GO TO THE ANSWERS AND SELECT "COUNTERY ID " AND "COUNTRY REGION"              COLUMNS     



 


6.AFTER SELECTING THE COLUMNS SEE THE RESULTS IN "TABLE" FORMAT, AND SELECT THE ""WRITE BACK PROPERTIES"" BELOW THE TABLE NAME.                    


         


7.WE WILL GET THE EDIT PROPERTIES FOR WRITE BACK                                                            

A. FIRST CHECK THE "ENABLE WRITE BACK"
B.TEMPLATE NAME AS "WRITE_BACK"             
C.NAME THE BUTTON TEXT AS""WRITE""          
D.LEAVE THE BUTTON POSITION AS ""DEFAULT" 


CLICK OK  




8.U CAN SEE THE BUTTON  ""WRITE"" BELOW THE RESULTS, BUT IT IS NOT                        "ENABLED", WE CAN SEE HOW TO ENABLE IT.                                                                  




9.NOW GO TO THE "CRITERIA", SELECT THE "COUNTRY REGION" COLUMN PROPERTIES THEN GO TO "COLUMN FORMAT"---- SELECT THE "VALUE INTERACTION" AS"""WRITE BACK"" AS SHOWN BELOW SCREEN SHOT  



10.GIVE THE FIELD SIZE AS UR WISH---- HERE I AM TAKING "6"AND CLICK OK                  




11.NOW SEE THE RESULTS U CAN SEE THE COUNTRY REGION  NAMES CAN   BE "ENABLED", WE CAN GIVE NEW NAME IN THE FIELD AND PRESS "WRITE" THEN IT IS WRITTEN IN TO DATA BASE------BUT CURRENTLY STILL WE DONT HAVE "WRITE"BUTTON ENABLED





12. NOW WE CAN SEE HOW TO ENABLE THE "WRITE" BUTTON, FIRST OF ALL GO TO THE BELOW URL AND SAVE A FILE WITH NAME AS REPRESENTED BELOW IN .XML FORMAT

D:/ORACLEBI\WEB\MSGDB\CUSTOMMESSAGES\

















 BE SURE OF THE ABOVE RED MARKED THINGS PROPERLY CONFIGURED OR NOT.
 
We have to modify connection pool same as in administrator tool
  1. writeBack connectionPool="WriteBack"
  2. We have to modify the template name tag attributes same as in report specified name
  3. WebMessage name="Write_back"
  4. Insert and updates are modified as far as our requirement concerned
     

13.NOW GO TO THE ANSWERS AND SEE THE RESULTS OF THE SPECIFIED SAVED FILE OF "WRITE BACK".....NOW THW BUTTON WRITE IS ENABLED.

WAT EVER THE MODIFICATIONS NOW U CAN DO AND PRESS WRITE BUTTON DIRECTLY IT WRIT IN DATA BASE.




HOPE THIS MA Y GIVE U AN IDEA REGARDING THE "WRITE BACK"