Obiee 11g Write Back Error
Contents |
template is an XML-formatted file that contains SQL commands needed to insert and update records in the write back table and columns you have created. You can create multiple write back templates, customizing each one for the fields used in each specific the system is unable to read the write back template please contact your system administrator report. In the report properties you specify the name of the write back template to
The System Is Unable To Read The Writeback Template Obiee 11g
use. The write back template must meet the following requirements:To meet security requirements, you must specify the connection pool along with the SQL commands
Obiee Writeback Error Log
to insert and update records. This SQL references the values passed in the write back schema to generate the SQL statements to modify the database table. Values can be referenced either by position (such as @1, @3) or
Writeback In Obiee 11g
by column ID (@{c0}, @{c2}). Column positions start numbering with 1, whereas column IDs start with c0. The use of Column ID is preferred. NOTE: The notation @n is not the same as @{cn-1}, because the column with ID cn-1 may not be the nth column in the table. You must include both an
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more 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 Stack Overflow is a community of 6.2 million https://docs.oracle.com/cd/E12096_01/books/AnyWebAdm/AnyWebAdm_Dashboard17.html 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 know what is wrong with my code? All the write back features http://stackoverflow.com/questions/29146001/write-back-form-in-obiee have been enabled so I believe my syntax in the form is not valid.
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security http://oracle.ittoolbox.com/groups/technical-functional/oracle-bi-l/obiee111164-writeback-error-4993488 Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News http://rajeshthomas.blogspot.com/2012/08/writeback-analysis-in-obiee-11g-part-1.html Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate Andrew.S.Baker JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 Adrian_Grigoriu blrvenkat obiee 11g COMPANIES Panaya Inc. Oracle ShoreTel Evault View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle BI The Oracle BI group is for the discussion of technical issues that arise during the implementation, configuration, or daily use of Oracle Business Intelligence solutions. Home | Invite Peers | More Oracle Groups Your account is the system is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. OBIEE11.1.1.6.4 - Writeback Error Devpriyo Bhattacharya asked Nov 2, 2012 | Replies (1) Hi All, I am getting the following error: Write Back Error An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator. I have been trying to resolve this issue since last one week now. I have tried all, what is given in the following links, still the above error: 1) http://bidirect.blogspot.in/2011/05/writeback-for-dashboard-commentary-for.html 2) http://obieelearner.blogspot.in/2012/07/obiee-11g-write-back.html 3) https://forums.oracle.com/forums/thread.jspa?threa dID=2456664&tstart=60 4) https://forums.oracle.com/forums/thread.jspa?threa dID=2277734 5) http://obiee10grevisited.blogspot.in/2012/02/write -back-in-obiee11g.html 6) http://deliverbi.blogspot.in/2012/08/obiee-111162-writeback-setup.html 7) http://subhashtata.blogspot.in/2011/12/writeback-in-11g-obiee.html 8) https://docs.google.com/file/d/0BwMedcp
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