Owner: FreeSAP Business Warehouse(BW) Books,Faqs,Material URL:http://freesapbwlive.blogspot.com Join Date: Sat, 07 Jun 2008 09:33:52 -0500 Rating:0 Site Description: BI InfoObject,Master Data,Modeling,Business Warehouse, Errors,Reporting,Tables,Conversion Routine,Data Uploading,DataStore Objects,Infocube,InfoSets,Interview Questions,Modeling,MultiProvider,TCodes,Upgrade BI,VirtualProviders Site statistics:Click here
SAP R/3 Source Table.field - How To Find? 2008-08-22 08:53:02 What is the quickest way to find the R/3 source table and field name for a field appearing on the BWInfoSource
? -----Reply Message-----Subject: RE: R/3 Source Table
.field - How To Find? Hi, With some ABAP-knowledge you can find some info: 1, Start ST05 (SQL-trace) in R/32, Start RSA3 in R/3 just for some records3, After RSA3 finishes, stop SQL-trace in ST054, Analyze SQL-statements in ST05 You
What is meant by Primary Index and Secondary Index 2008-08-22 08:52:39 Explain the what is primary and secondary index. When you activate an object say ODS / DSO, the system automatically generate an index based on the key fields and this is primary index. In addition if you wish to create more indexes , then they are called secondary indexes. The primary index is distinguished from the secondary indexes of a table. The primary index contains the key fields of the ta Read more:Primary
, Index
, Secondary
Types of Update Methods 2008-08-22 08:52:18 What are these update methods and which one has to use at what purpose. R/3 update methods-----------------------------------------------1. Serialized V3 Update
2. Direct Delta3. Queed Delta4. Un Serialized Delta Update By: Anoo a) Serialized V3 Update This is the conventional update method in which the document data is collected in the sequence of attachment and transferred to BW by batch job.The Read more:Methods
SAP BW versus R/3 Reporting 2008-08-22 08:51:31 Dear All, Would it be sufficient just to Web-enable R/3 Reports ? Why does one needto implement BW ? What are the major benefits of reporting with BW overR/3 ? Thanking you, -----Reply Message-----Subject: RE: BW versus
R/3 Reporting
There are quite a few companies that share your thought but R/3 was designedas a OLTP system and not an analytical and reporting system. In factdepending on you needs
Removing '#' in Analyzer (Report) 2008-08-22 08:51:05 In ODS, there are records having a value BLANK/EMPTY for some of the fields. EX: Field: `Creation Date' and there is no value for some of the records. For the same, when I execute the query in Analyzer
, the value `#' is displaying in place of `BLANK' value for DATE and other Characteristic fields. Here, I want to show it as `BLANK/SPACE' instead of `#'. How to do this? I had a similar problem an
How To Convert Base Units Into Target Units In BW Reports 2008-08-22 08:50:40 My client has a requirement to convert the base units of measurements into target units of measurements in BW reports. How to write the conversion routine and otherwise pls refer conversion routine used so that the characteristic value(key) of an infoobject can be displayed or used in a different format to how they are stored in the database. Have a look at the how to document "HOWTO_ALTERNATE_UOM Read more:Convert
, Target
Deltas Not Working for Installation Master Data BW Errors 2008-08-22 08:49:58 I am having trouble with the deltas for master data object "installation". The changes are clearly recorded in the time dependent and time independent tables, EANL/EANLH. The delta update mode is using ALE pointers, does anyone know of a table where I can go check where these deltas/changes are temporarily stored, or what's the process behind this type of delta? The following steps must be execut Read more:Installation
, Master
, Errors
Error in bw data transport 2008-08-22 08:49:32 After creating a query in BEX, you try and save the query, it gives you the following popup message: "The query could not be saved due to a problem in transport
". Steps to correct the problem: 1. Within Adminstrator Workbench click on the Transport Connection tab in the Navigation Window on the left hand side. 2. Select the Request BEx button on the toolbar. 3. Create a transport. 4. Try to
SAP BW ERROR : replicate data from source system 2008-08-22 08:49:10 BW 2.1C OS WINT4 The RFC is working fine and you are trying to replicate data from source system (4.0B), while doing this you got anerror an ABAP dump, in this dump the Exception Condition are "CNTL_ERROR" raised Take a look at OSS notes 158985 and 316243. Depending on what patch level, GUI, or Kernel you are on.
Transport Process Chains to Test System 2008-08-22 08:48:47 What is the best way to transport process chains to test system?I got many other additional and unwanted objects got collected when I tried for collection of process chains from transport connection. To transport a process chain the best is to transport only objects created for the process chain. On my system I created specific obejcts for PC : Infopackages, jobs, variant. those objects are only Read more:Process
, Chains
, System
BW BI Transformation Creating Inversion Routines 2008-09-12 02:35:17 Use If you have defined routines in the transformation for a VirtualProvider, for performance reasons it may be useful to create inversion routines for these routines. In this way you can transform the selection criteria of a navigation step into selection criteria for the extractor. However, you do not require inversion routines to ensure the consistency of the data. More information: Processi Read more:Transformation
, Creating
, Routines
Inversion Routine Parameters BW BI Transformation Creating Inversion Routines 2008-09-12 02:34:46 The inversion routine has method invert. It has the following parameters: Importing ● i_th_fields_outbound: Fields/InfoObjects for the query structure ● i_r_selset_outbound: Query selection conditions ● i_is_main_selection: Allows you to transfer complex selection conditions such as selection conditions for columns. ● i_r_selset_outbound_complete: All selections Read more:Transformation
, Creating
, Routines
, Routine
Example for Inversion Routine BW BI Transformation Creating Inversion Routines 2008-09-12 02:34:12 In this example, the German keys 'HERR' and 'FRAU' in the target characteristic are mapped to the English keys 'MR' and 'MRS' from the field PASSFORM (form of address) of the source. All other values from the source field are mapped to the initial value. The coding of the routine is as follows: *---------------------------------------------------------------------** CLASS routine DEFINIT Read more:Transformation
, Creating
, Routines
, Routine
, Example
Details for Implementing the Inversion Routine BW BI Transformation Creating Inversion Routines 2008-09-12 02:32:51 Set Objects The purpose of an inverse transformation is to convert selection conditions of the query that are formulated for the target of the transformation (outbound) into selection conditions for the source (inbound). To do this, the selection conditions are converted into a multidimensional set object. In ABAP objects, these are the instances of class CL_RSMDS_ST). The advantage of this repre Read more:Transformation
, Creating
, Routines
, Routine
Regular Expressions in Routines BW BI Transformation Creating Inversion Routines 2008-09-12 02:32:04 Use You can use regular expressions in routines. A regular expression (abbreviation: RegExp or Regex) is a pattern of literal and special characters which describes a set of character strings. In ABAP, you can use regular expressions in the FIND and REPLACE statements, and in classes CL_ABAP_REGEX and CL_ABAP_MATCHER. For more information, see the ABAP key word documentation in the ABAP Editor. Read more:Transformation
, Creating
, Routines
, Expressions
Creating InfoSources (SAP Source System) in SAP BW BI 2008-09-12 02:30:42 Use Instead of creating a new InfoSource
, you can copy one from SAP Business Content. Procedure Choose the InfoSource tree of the Data Warehousing Workbench to create InfoSources for an SAP source system. From the context menu of the affected application component, choose Additional Functions ® Create InfoSource 3.x. ... 1. Select the type. 2. Under InfoSource, ent Read more:System
, Creating
BW Communication Structure in SAP BW BI 2008-09-12 02:30:06 Definition The communication structure is localized in the SAP Business Information Warehouse and displays the structure of the InfoSource. It contains all of the InfoObjects belonging to the InfoSource of the SAP Business Information Warehouse. Use Data is updated in the data targets of this structure. In this way, the system always accesses the actively saved version of the communication stru Read more:Structure
Maintaining Communications Structures with Flexible Updating in SAP BW BI 2008-09-12 02:29:39 Use Assign the fields of a DataSource to the corresponding InfoObjects of the InfoSource. Although the DataSource contains source system fields that belong together, you can combine fields that logically belong together from several DataSources, from various source systems in the communication structure. Prerequisites You have created an InfoSource with flexible updating. Procedure You can get to Read more:Maintaining
, Communications
, Structures
, Flexible
Maintaining Communication Structures with Direct Updating in SAP BW BI 2008-09-12 02:29:12 Use Assign the fields of a DataSource to the corresponding InfoObjects of the InfoSource. Although the DataSource contains source system fields that belong together, you can combine fields that logically belong together from several DataSources, from various source systems in the communication structure. Prerequisites You have created an InfoSource with direct updating. You have assigned a source Read more:Maintaining
, Structures
, Direct
Checking for Referential Integrity in SAP BW BI 2008-09-12 02:28:43 Use The check for referential integrity occurs for transaction data and master data if they are flexibly updated. You determine the valid InfoObject values. Prerequisites The check for referential integrity functions only in conjunction with the function Error Handling on the scheduler tab page Update. See also Handling Data Records with Errors. In order to use the check for referential integ Read more:Integrity
Transfer Structure in Data Flow 3.x in SAP BW BI 2008-09-12 02:28:09 Definition The transfer structure is the structure in which the data is transported from the source system into BI. It is a selection of DataSource fields from a source system. Use The transfer structure provides BI with all the source system information available for a business process. An InfoSource 3.x in BI needs at least a DataSource 3.x for data extraction. In an SAP source system, Da Read more:Structure
BW Maintaining Transfer Structures in SAP BW BI 2008-09-12 02:27:41 Use In the transfer structure maintenance, you specify which fields for a DataSource are to be transferred into a communication structure. Prerequisites You have created an InfoSource. You have maintained a communications structure. A maintained communication structure is required for the procedure described in the following. It is however also possible for you to create the InfoSource first, Read more:Maintaining
, Structures
BW Processing Transfer Rules in SAP BW BI 2008-09-12 02:27:10 Use When you have maintained the transfer structure and the communication structure, you use the transfer rules to determine how you want the transfer structure fields to be assigned to the communication structure InfoObjects. You can arrange for a 1:1 assignment. You can also fill InfoObjects using routines, formulas, or constants. You need not assign InfoObjects to each field of the transfe Read more:Processing
, Rules
BW Start Routines in Transfer Rules in SAP BW BI 2008-09-12 02:26:31 Use You have the option of creating a start routine in the transfer rules maintenance screen. This 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. The entire data package in the transfer structure format is used as parameter for the routine. Functions You can change the data package by adding or deleting rec Read more:Start
, Routines
, Rules
BW Creating Transfer Routines in SAP BW BI 2008-09-12 02:25:56 Procedure ... 1. In the transfer rule maintenance screen, choose Create Routine for the relevant InfoObject. 2. For the transfer rule choose Routine ® Create in the dialog box. 3. Specify a name for the local transfer routine that you want to create. 4. You have the option of using transfer structure fields in the routine. You can choose betwe Read more:Creating
, Routines
BW Inversion Routine in SAP BW BI 2008-09-12 02:25:17 Use If you have defined transfer routines in the transfer rules for the InfoSource of a SAP RemoteCube, for performance reasons, it makes sense to also create inversion routines for each. When jumping to a transaction in another SAP system using the report-report interface, you have to create an inversion routine for the transfer routine if you are using one, because otherwise the selections can Read more:Routine
BW Error Handling in the Transfer Routine in SAP BW BI 2008-09-12 02:24:46 In a transfer routine, you have the option of transferring error messages and warnings to the monitor. Note the following: · When you use the transfer routine to transfer messages to the monitor, you need to maintain in the scheduler the settings that control how the system behaves if an error occurs. See also Handling
Data Records with Errors. · If, in your routine, you set t Read more:Routine
Recommend Site To A Friend
