Siebel Tools Could Not Connect To Datasource For Event Api' title='Siebel Tools Could Not Connect To Datasource For Event Api' />Enhancement of extractors. Hi Khanna,I hope you got the answer for your question. What are the extractor types Application Specifico BW Content FI, HR, CO, SAP CRM, LO Cockpito Customer Generated Extractors. LIS, FI SL, CO PA Cross Application Generic Extractors o DB View, Info. Set, Function Module. What are the steps involved in LO Extraction The steps are o RSA5 Select the Data. Sourceso LBWE Maintain Data. Sources and Activate Extract Structureso LBWG Delete Setup Tableso 0. LIBW Setup tableso RSA3 Check extraction and the data in Setup tableso LBWQ Check the extraction queueo LBWF Log for LO Extract Structureso RSA7 BW Delta Queue Monitor. How to create a connection with LIS Info. Structures LBW0 Connecting LIS Info. Structures to BW4. Siebel Tools Could Not Connect To Datasource For Event Api' title='Siebel Tools Could Not Connect To Datasource For Event Api' />What is the difference between ODS and Info. Cube and Multi. Provider ODS Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI. CUBE Follows the star schema, we can only append data, ideal for primary reporting. Multi. Provider Does not have physical data. It allows to access data from different Info. Providers Cube, ODS, Info. Object. It is also preferred for reporting. What are Start routines, Transfer routines and Update routines Start Routines The start routine is run for each Data. Package after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global Data. SharePoint Quick Guide Learn SharePoint in simple and easy steps starting from basic to advanced concepts with examples including Overview, Types, Capabilities. Listing of web test tools and management tools link checking, html validation, load testing, security testing, java testing, publishing control, site mapping. Structures. This structure or table can be accessed in the other routines. The entire Data. Package in the transfer structure format is used as a parameter for the routine. Transfer Update Routines They are defined at the Info. Object level. It is like the Start Routine. It is independent of the Data. Source. We can use this to define Global Data and Global Checks. What is the difference between start routine and update routine, when, how and why are they called Start routine can be used to access Info. Package while update routines are used while updating the Data Targets. What is the table that is used in start routines Always the table structure will be the structure of an ODS or Info. Cube. For example if it is an ODS then active table structure will be the table. Explain how you used Start routines in your project Start routines are used for mass processing of records. In start routine all the records of Data. Package is available for processing. So we can process all these records together in start routine. In one of scenario, we wanted to apply size to the forecast data. For example if material M1 is forecasted to say 1. May. Then after applying size Small 2. How To Use The Yawara Stick. Medium 4. 0, Large 2. Extra Large 2. 0, we wanted to have 4 records against one single record that is coming in the info package. This is achieved in start routine. What are Return Tables When we want to return multiple records, instead of single value, we use the return table in the Update Routine. Example If we have total telephone expense for a Cost Center, using a return table we can get expense per employee. How do start routine and return table synchronize with each other Return table is used to return the Value following the execution of start routine. What is the difference between V1, V2 and V3 updates V1 Update It is a Synchronous update. Here the Statistics update is carried out at the same time as the document update in the application tables. V2 Update It is an Asynchronous update. Statistics update and the Document update take place as different tasks. V1 V2 dont need scheduling. Serialized V3 Update The V3 collective update must be scheduled as a job via LBWE. Here, document data is collected in the order it was created and transferred into the BW as a batch job. The transfer sequence may not be the same as the order in which the data was created in all scenarios. V3 update only processes the update data that is successfully processed with the V2 update. What is compression It is a process used to delete the Request IDs and this saves space. What is Rollup This is used to load new Data. Packages requests into the Info. Cube aggregates. If we have not performed a rollup then the new Info. Cube data will not be available while reporting on the aggregate. What is table partitioning and what are the benefits of partitioning in an Info. Cube It is the method of dividing a table which would enable a quick reference. SAP uses fact file partitioning to improve performance. We can partition only at 0. CALMONTH or 0. FISCPER. Table partitioning helps to run the report faster as data is stored in the relevant partitions. Also table maintenance becomes easier. Oracle, Informix, IBM DB23. SAP DB, Microsoft SQL Server, IBM DB24. How many extra partitions are created and why Two partitions are created for date before the begin date and after the end date. What are the options available in transfer rule Info. Ship Simulator 2008 Full Iso. Object Constant Routine Formula. How would you optimize the dimensions We should define as many dimensions as possible and we have to take care that no single dimension crosses more than 2. What are Conversion Routines for units and currencies in the update rule Using this option we can write ABAP code for Units Currencies conversion. If we enable this flag then unit of Key Figure appears in the ABAP code as an additional parameter. For example, we can convert units in Pounds to Kilos. Can an Info. Object be an Info. Provider, how and why Yes, when we want to report on Characteristics or Master Data. We have to right click on the Info. Area and select Insert characteristic as data target. For example, we can make 0. CUSTOMER as an Info. Provider and report on it. What is Open Hub Service The Open Hub Service enables us to distribute data from an SAP BW system into external Data Marts, analytical applications, and other applications. We can ensure controlled distribution using several systems. The central object for exporting data is the Info. Spoke. We can define the source and the target object for the data. BW becomes a hub of an enterprise data warehouse. The distribution of data becomes clear through central monitoring from the distribution status in the BW system. How do you transform Open Hub Data Using BADI we can transform Open Hub Data according to the destination requirement. What is ODS Operational Data. Source is used for detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables. What are BW Statistics and what is its use They are group of Business Content Info. Cubes which are used to measure performance for Query and Load Monitoring. It also shows the usage of aggregates, OLAP and Warehouse management. What are the steps to extract data from R3 Replicate Data. Sources Assign Info. Sources Maintain Communication Structure and Transfer rules Create and Info. Package Load Data. What are the delta options available when you load from flat file The 3 options for Delta Management with Flat Files o Full Uploado New Status for Changed records ODS Object onlyo Additive Delta ODS Object Info. CubeQ Under which menu path is the Test Workbench to be found, including in earlier Releases The menu path is Tools ABAP Workbench Test Test Workbench. Q I want to delete a BEx query that is in Production system through request. Is anyone aware about itBugs Fixed in 1. Doc ID 1. 61. 41. Business Intelligence Server Enterprise Edition Version 1. Business Intelligence Suite Enterprise Edition Version 1. Information in this document applies to any platform. Purpose. This note provides a list of the bugs fixed in each of the patches as. Oracle Business Intelligence Enterprise Edition OBIEE. It is divided into eight sections, listing the bugs. Details. Note un linked bugs are internal only and not publicly available. Patch 1. 69. 13. 44. Patch 1. 1. 1. 1. Oracle Business Intelligence Installer BIINST. T2. P unable to access bi analytics application on target. T2. P copyconfig of bidomain shows plain text password of repository. Patch 1. 79. 22. 35. Patch 1. 1. 1. 1. Oracle Business Intelligence Publisher BIP. SCHEDULESERVICE DELIVERYSERVICE REQUIRES SPECIFIC ELEMENT FOR REPORT FILENAMEbug 1. BISERVER QUERY FAILS IF AMPERSAND IS USED IN COLUMN NAMEbug 1. BI PUBLISHER CANNOT SEE FOLDER GRANTED WHEN USER ACCOUNT IS EXPIREDGRACE. DATA ENGINE RETURNS INCORRECT DATATYPE WHEN DECIMALS IS STORED IN NUMBER COLUMN. BIPREGION IS NOT WORKING AFTER CALLING SAME REPORT USING REPORTSERVICES API. RPT NOT RENDERING IN PDF AND HTML WHEN CREATED IN MY FOLDER WITH WIZARD. DATA FIELDS THAT CONTAIN A BACKSLASH IN A PARAMETER CAUSE DATA MODEL TO FAIL. FLEXFIELD PARAMETER POP UP DIALOG HAS NO TEXT DESCRIPTION. BIEE DASHBOARD IMPORT ORCL NUMBER SHOWS UP AS NULL. ONLY THE FIRST PRESENTATION VARIABLE IS PASSED TO THE DATA MODEL ENGINESev 1 SR. QA LOV SEARCH DOES NOT WORK FOR NON DEFAULT REFRESHED LOVbug 1. EXPORT FILE NAME IS NOT DECODED PROPERLY. BI DATAMODEL RETURNS ONLY FIRST ROW IF WE HAVE MULTIPLE GRANDCHILD VOSbug 1. BI PUBLISHER 1. 1. SCHEDULED JOBS NOT RUNNING AS SCHEDULEDbug 1. PARAMETERS WITHOUT DEFAULT VALUES ALLOW MANUAL ENTRY OF DATA USING IE7. INTERMITTENT BIP REPORT CORRUPTION OR ERRORS WHEN RUN ON AIX. DTE REL7 BIP REGION NOT PSEUDO TRANSLATE ITS FIELDS BUTTON DONE, TEMPLATE, OUT. COULD NOT LOAD SCHEMA INFORMATION ERROR WHEN USING QUERY BUIbug 1. BIP 1. 1G DATE FORMAT CHANGES AFTER AN EXPORT TO EXCEL OR PDFbug 1. SECURE FTP IS NOT TRANSFERING ALL OUTPUT FILEbug 1. SELECTING THE DATE FROM CALANDER ICON IS REMOVING THE TIME ZONE INFORMATION. ACC SECTION 5. 08 MENU SELECTION NOT WORKING IN IE8bug 1. MDX QUERIES FAIL TO LOAD WHEN SAVING, OR IF SAVED, GENERATE NO DATA. TRIGGER DOES NOT  ACCEPT VARIABLE PARAMETER SYSDATE 7bug 1. UNABLE TO SEE REPORTS AFTER UPLOAD ON ONE OF TWO NODES. ONLY FIRST REPORTS TEMPLATE USED FOR ALL REPORTS WHILE PREVIEWING THEMbug 1. APP FND 0. 29. 38 MULTI ORGANIZATION ROUTINE FAILED WHEN SELECT A RESP IN MYACCOUNTbug 1. BIPUBLISHER DYNAMICAL CONNECTION DOESNT WORK IN SCHEDULE WEBSERVICE XCA. XPATH ERROR IN BI PUBLISHER 1. G BUT WORKS IN 1. Gbug 1. 63. 10. 35. REPORTS ARE SCHEDULED TO RUN EVERY 2 WEEKS BUT RUN EVERY WEEK. CELL PADDING CALCULATIONS FOR PDF, RTF AND HTML OUTPUTS ARE NOT THE SAME. SECURITY ON THE CUSTOMIZED REPORT TO MATCH THAT OF THE ORIGINAL REPORT. BURSTING JOB DATA DOES NOT HAVE BURSTKEY POPULATED IN JOBSLIST API. NESTED GROUP CAN NOT BE DISPLAYED CORRECTLY IN EXCEL TEMPLATE. BEFORE SCHEDULE EVENT TRIGGER GETS NPE IN PRE PROCESS FUNCTION. CAN WE SET CONDITIONAL FORMATTING FOR EACH SHEET IN EXCEL TEMPLATE. XLSX FORMAT OUT OF MEMORY DUE TO LARGE NESTED TABLE. QA IE1. 0 REPORT CREATION WIZARD BROKEN, DATA SOURCE FAILS TO LOAD. REPORT JOB HISTORY 5. OUTPUTS SHOW DISABLED XML DATA FOR ALL RECORDS AFTER PREVbug 1. XLIFFUTILITY NOT FINDING THE CORRECT STRING IN A SERIES OF FO INLINE ELEMENTS. JVM OUT OF MEMORY WHILE ADDING IMAGE TO BIP REPORTbug 1. INCONSISTENT ALIGNMENT IN INTERACTIVE REPORTS WITH PIVOT TABLES USING IE9. Double Entry Journal On The Hunger Games'>Double Entry Journal On The Hunger Games. MEMORY PROBLEMS IN FOPROCESSOR WHILE HANDLING LARGE NESTED TABLEbug 1. INCONSISTENT ALIGNMENT IN INTERACTIVE REPORTS WITH PIVOT TABLES USING IE9. KEEP WITH NEXT. WITHIN PAGE ATTRIBUTE SET TO ALWAYS UNWANTED PAGE BREAK IN PDF. BIP UPDATES CATALOG OBJECTS VIA BIPS SOAP AS BISYSTEMUSERbug 1. LOCAL SUPER USER LOGIN FAILS. ER BIP IS DUPLICATING AN IMAGE TO EVERY ROW WHEN EXPORTED VIA EXCEL 2. ER SUPPORT PROCESSING NON STANDARD SQL QUERIES. PDF2. IMAGE PERFORMANCE DUE TO SUN. AWT. PACKAGEbug 1. REQUIRE CONFIGURATION OPTION TO CREATE PDF FILES WITH OR WITHOUT EXTGSTATE. BIP DATA MODEL FAILS TO LOAD DATA FOR A DATA SET BASED ON XML WITH UTF 8 CHARSET. QA QUERY BUILDER DOES NOT HAVE CONSISTENT LOOK. CONTAINS MULTIPLE FONT STYLES. ER NEW OPTION FOR XLSX OUTPUT TO EXPAND COLUMN TO AVOID CELL MERGING. QA RGRN TIMEZONE DISPLAYS UNDEFINED AFTER CHANGING IT. REMOVING BISYSTEMUSER IMPERSONATION REDUCE CALLS TO BIPS FOR NULL SESSION IDbug 1. JAVA. LANG. NULLPOINTEREXCEPTION IN REPORTS WITH GROUP DETAIL REPEATING SECTION. ITEM COST DETAIL REPORT XML ROUNDS THE DISPLAY OF ITEM COST TO NEAREST VALUE. TEMPLATE BUILDER STAGING PROCESS NEEDS TO BE IMPROVEDbug 1. ANCHOR TWO PIVOT TABLES SO THEY APPPEAR SIDE BY SIDE IN RTF TEMPLATE IS FAILING. ACC IE8 ENTER DOES NOT SELECT FLOATMENU HIGHLIGHTED ENTRY. IN IE AND FIREFOX THE DECIMAL MAKSING PARAMETER IS NOT EDITABLEbug 1. BIPUBLISHER REPORTS PROCESSING CLOCK,CANCEL BUTTON AND NO DATA FOUND MSGbug 1. NESTED FORMULAS IN PIVOT TABLE FAIL IN LAYOUT EDITORVIEWERPDFbug 1. PERMISSION SETTING NOT DISPLAYED PROPERLY IN MORE THAN 3. ROLESbug 1. 67. 54. BI PUBLISHER INCORRECT VALUES FOR SUBTOTALS. INTERACTIVE VIEWERPDF ERROR IN BIP 1. IMPLEMENT A SETTING TO LIMIT MEMORY USAGE MEMORY GUARDbug 1. SENDING LARGE FILES TO ORACLE CLOUD SERVER REMOVES. PART EXTENSIONbug 1. SCHEDULE TRIGGER IN DATAMODEL ISSUEbug 1. BI PUBLISHER PROBLEMS WITH CUSTOM FORMULA IN A SUBTOTAL CELL IN INTERACTIVE MODE. ADD MORE FIELDS IN BIP AUDITING AND MONITORING. ADD CHECKBOX TO CONTROL ADDPARTEXTINTRANSFER PROPERTY IN SFTP FTP CONFIGbug 1. SCHEDULED PROCESSES ARE NOT RUNNING CORRECTLY. ADDING EVENT LOGGING TO HELP DIAGNOSIS. QA LABEL LANGUAGE NOT IN ENGLISH BY DEFAULTbug 1. BI PUBLISHER PARAMETER NAMES TRANSLATION NOT RETAINED ON REPORT REFRESH. LAYOUT EDITOR REPORTS DO NOT SUPPORT CLOB DATA. REL7. ST7 CDRM ENV EMAIL DELIVERY NOT WORKING. IE1. 0 DELETE ICON NOT VISIBLE. ACC MULTISELECT SELECT LIST AGAINST IE1. IS NOT WORKING USING NAVIGATION KEYbug 1. OPENING REPORT JOBS PAGE RESULTS IN ERROR GETING HISTORY DATA. RESENDING A REPORT AS FTP FROM THE JOB HISTORY PAGE FAILSbug 1. ER DATE AND NUMBER FORMAT LOST WHEN DOWNLOADING REPORT TO EXCEL. QA IE1. 0 IN DMEDITOR STRUCTURE XMLOUTPUT VIEW NOT DISPLAYED PROPERLY. REPORT TITLE CHANGE TO UNDEFINED WHEN EDIT REPORT LAYOUT IN IE1. LAYOUT EDITOR CHARTS DO NOT GENERATE DATA VALUES IN 2. ND OR MORE CHARTS. ENHANCE DATAMODEL PROCESSING TO WRITE DIAGNOSTIC DETAILS AND LIMIT XML SIZE. DERIVE SYSTEM TEMP DIRECTORY FROM SERVER PROPERTYbug 1. AFTER APPLYING OBIEE BP1 PATCH, BI PUBLISHER STOPS WORKING. IE1. 0 BI1. 11. 18. SELECT ALL DO NOT WORK FINE IN QUERY BUILDER IN IE1. NEED TO REDUCE DEFAULT REPORT THRESHOLD AND DB FETCH SIZE TO MINIMIZE OOM IN FA. FAPPS UPLOADING DATA MODEL THROWS ERROR BUT UPLOADS ANYWAY WITH INVALID DATA. SCHEDULER ENGINE DOES NOT USE A SERVER TEMPORARY DIRECTORY. A REDUNDANT TEMP FILE CREATION OCCURS BY REPORT GENERATION BY SCHEDULERbug 1. IE7 IF OUTPUT NOT FILLED AFTER SELECTING DESTINATION THROWS 5. INTERNAL. bug 1. 71. QA IE1. 0 DRAG DROP ON REPORT WIZARD NOT WORKING FOR TABLE LAYOUT. MEMORY SCALABLE FEATURE FOR NESTED TABLE CAUSES WRONG OUTPUT. IE1. 0 BI1. 11. 18. CLICK ON PAGE NUMBER ITEMS WARNING MESSAGE SHOWS. UNDEFINED DISPLAYED AFTER SELECTING DATATIME IN SCHEDULE PAGE. G UPGRADED ANALYSIS REPORT RETURNS EMPTY XML DATA IN 1.