August 3, 2008 – 5:34 pm
A brief overview of the new features in this blog.
1) New 'Subscribe' button: This will enable you to subscribe to our blog RSS feed with your favorite RSS reader.
2) New 'Recent Visitors' widget: This widget will list the recent visitors to the website if they are registered with Mybloglog service. Just click on 'Join this Community' and use your Yahoo id to register.
Don't forget to add you picture to your profile on Mybloglog. Its really fun to see who's in our community!
3) New 'Top Commentators' section: This is our way of showing a little appreciation for people who actively comment on the posts.
4) New 'Recent Comments' section: Displays recent comments on any post.
Note the cool icons(Gravatars) next to your name. To use your pictures next to your comment, go to www.gravatar.com and register your email id and a profile picture. Thats all! Whenever you use that email id when submitting ...
Posted in General | No Comments »
August 3, 2008 – 12:34 pm
By: Venkat Pulluri
In Part 2 of step by step SAP BI 7 series we learned how to create InfoObjects / Characteristics.
Now in this post, we will see how to load data into the MasterData InfoObjects.
Also, we have to keep in mind that from data integrity and load performance point of view, we have to load the MasterData before loading the transactional data into InfoCubes or DSOs.
We know that BW is a Datawarehouse system and data will be loaded into BW from many sources like SAP R/3, other Databases and flatfiles. In this post we will discuss about how to load data from a flatfile.
STEP 1.A
Select SOURCE SYSTEM under 'Modelling'(T-code:RSA1).In the right panel, Context Menu (right-Click) on sources systems and select 'Create'.
STEP 1.B
Select the File System (Manual Metadata, Data using File Interface) option, and then click to continue.
STEP 1.C
Enter Logical Name & Description for the source system, and then ...
Posted in SAP BW | 8 Comments »
July 25, 2008 – 3:37 pm
STEP 1
Select 'Info Providers' under 'Modeling' tab in the left Panel. In the Right Panel, Right-click 'Demo Info Area' that we created in earlier exercise and then select 'Create Info Cube'
STEP2
Enter name and a Description, select the option 'Standard Info Cube' in block Info Provider Type, and then click to create the Info Cube
Note: An Info cube can be Standard Info Cube, Real or Virtual Info Provider.
A Standard Cube has a fact table and associated dimension tables, and it contains the data. We are building a Standard Info cube.
A Real time Cube is a Transactional Info cube with Write & Read access used in SEM- BPS.
A Virtual Info Provider does not contain data; instead, the data resides in the source system. Whenever query executed on the Virtual Info Provider data will be extracted from the source system on that time, extracted data will be shown as Query result.
STEP 3:
Select ...
Posted in SAP, SAP BW | 4 Comments »
July 25, 2008 – 5:34 am
-Suresh
STEP1: Loading was failed due to invalid characters present in the data.
STEP2: Click on the Details Button, to exactly know in which record error has been occured. Also you can able to know what are the allowed characters by Clicking on LongText button.
STEP3: Now Rt.Click on the InfoCube and go to Manage, to delete the failed Request as shown below.
STEP4: Now GoTo T-Code RSMO, to edit the PSA Records as shown below. Click on the PSA button as shown.
Then it popup new window, press continue as shown
Now Select the Error Record, and click on edit button as shown. Then it popup new window, in that edit the errored Record and Click on Continue.
Now Click on the Save Button to save the data in the PSA.
STEP5: Now Schedule the load, to load the data from PSA to InfoCube as shown screen by screen.
Click on the DataTarget Button to see the ...
Posted in SAP BW | 11 Comments »
July 23, 2008 – 5:04 pm
Here is a handy list of Transaction Codes (T-Codes) that can be used as a cheat sheet in SAP BI/BW Development.
Very frequently used T-codes are in bold letters.
AL11
DB20
IDOC
LISTCUBE
ORA_LOCK
RMPS_RECTYPEC
ROLE_CMP
RRC1
RRC2
RRC3
RRMX
RS12
RSA1
RSA10
RSA11
RSA12
RSA13
RSA14
RSA15
RSA16
RSA17
RSA18
RSA1OLD
RSA2
RSA2OLD
RSA3
RSA5
RSA6
RSA7
RSA8
RSA9
RSADMIN
RSATTR
RSBO
RSBOH1
RSBOH2
RSBOH3
RSD1
RSD2
RSD3
RSD4
RSDCUBE
RSISET
RSKC
RSLGMP
RSMO
RSPC
RSPC1
RSPCM
RSPCP
RSPLAN
RSQ02
RSRT
RSRTRACE
RSRV
SE03
SE09
SE10
SE11
SE12
SE16
SE18
SE19
SE20
SE21
SE24
SE37
SE38
SE80
SM12
SM36
SM37
SM50
SM51
SM66
SMQ1
ST01
ST03
ST04
ST05
ST22
STVARV
SU01
SU50
SU52
SU53
Display SAP Directories
Update DB Statistics
IDoc: Repair and check programs
Displays InfoCube Data
Oracle: Lock-Monitor
TNA: Record Types Customizing
Compare Roles
Create Currency Conversion Type
Edit Currency Conversion Type
Display Currency Translation Type
Start the Business Explorer Analyzer
Overview of master data locks
Modeling - DW Workbench
Realtime Test Interface Srce System
DW Workbench: InfoProvider Tree
DW Workbench: InfoSource Tree
DW Workbench: Source System Tree
DW Workbench: InfoObject Tree
DW Workbench: DataSource Tree
DW Workbench: Favorites Tree
DW Workbench: General Search
DW Workbench: Open Hub Destination
BW Administrator Workbench (old)
SAPI DataSource Repository
SAPI DataSource (Old GUI)
Extractor Checker
Install Business Content
Maintain DataSources
BW Delta Queue Monitor
DataSource Repository
Transfer Application Components
RSADMIN maintenance
Attribute/Hierarchy Realignment Run
Open Hub Maintenance
Open Hub Maintenance
Open Hub Maintenance
Open Hub Maintenance
Characteristic maintenance
Maintenance of key figures
Maintenance of units
Maintenance of time characteristics
Start: InfoCube editing
Maintain InfoSets
Maintaining the Permittd Extra Chars
Maintain RSLOGSYSMAP
Data Load Monitor Start
Process Chain Maintenance
Process Chain Display
Monitor daily process chains
Process Log
Modeling ...
Posted in SAP, SAP BW | 2 Comments »
July 19, 2008 – 11:46 am
This post is on working with duplicate data records in Masterdata loads, and is part of part of the 'Produciton Support Issues of SAP BW' series.
STEP 1
The monitor 'Details' displays error as shown in below picture when a Masterdata load fails due to duplicate data error.
Reason : Generally this error occurs when MasterData (MD) has been loaded earlier and it is in "modified" status in MasterData table. Unless we execute 'ChangeRun' or 'MasterData Activation' step, the data remains in "modified" status and is not reportable. Now our current MasterData load fails to insert the latest changes into the same table in "modified" version as the earlier records are still sitting in the table, resulting in duplicate records error.
STEP 2
Create a new session and go to Administrative Work Bench AWB (T-code: RSA1)
Then select from menu select 'Tools'-> 'Apply Hierarchy/Attribute Change ...' Or (Crtl+F9)
Now we will be in 'Change ...
Posted in SAP BW | 1 Comment »
July 16, 2008 – 10:02 pm
In this post lets discuss the object lock issues that we sometimes encounter in SAP BW production support role.
Lets take the below example where the InfoObject(0material) load has failed and the load monitor (T-Code: RSMO) looks like this.
STEP 1
Go to lock monitor (T-Code: SM12) screen and put an asterisk('*') in the selection for 'User name' and then click 'List' button at the top, as shown below.
STEP 2
Now the 'Lock Entry List' screen displays all the locks currently set in the system. Click the 'Find' button at the top, as shown in below pic
STEP 3
Now in the 'Find' screen enter the object that has failed; In our caste 'material', as shown in pic below.
If you find an entry in list, then look at 'Lock Argument' to find what action/process is locking the object. Generally this could be another request loading into the same object or a load from this object to ...
Posted in Uncategorized | No Comments »
July 12, 2008 – 12:39 pm
As part of the Produciton Support Issues of SAP BW series, lets see how to analyze a long running ODS activation step in this post.
STEP 1
Lets assume that we encountered the long running ODS/DSO step in a Process Chain(T-code: RSPC1) as shown in below pic.
STEP 2
Right Click on the ODS activation step in PC and select 'Administer Data Target' from the context menu options as shown below.
STEP 3
Now you will be in 'manage' screen of the ODS. Here, copy the activation request number ( ODSR_.....) of the request that is currently in activation status (yellow status) as shown below.
STEP 4
Now go to Table: 'RSODSACTREQ' (T-code: SE16) and input the activation request number (obtained in STEP 3) in 'ACTREQUEST' field selection. Now hit the 'Number of Entries' button and the number we obtain is the total number of DataPackets to be activated. (1658 in our case, as shown in below pic.)
STEP ...
Posted in SAP BW | 9 Comments »
July 12, 2008 – 12:14 pm
We learned how to analyze a long running BW load in Part 1 of SAP BW Production Support Issues series in ‘Process Overview‘ transaction ‘Detail Display‘ screen.
When a BW load takes long time to finish and if the 'Detail Display' screen looks like the pic. below, we need to investigate for hanging tRFCs in the system.
STEP 1
Go to the long running load monitor (T-code: RSMO) screen and from menu at top navigate to 'Environment' -> 'Transact. RFC' and then,
-> To 'In the Data Warehouse' , if the data source is in same SAP system as of the current load
-> To 'In the source system' , if the data source exists in external SAP system (like R/3)
as shown in pic below.
STEP 2
Now we will be in 'Transactional RFC' list selection screen. Here enter the input parameters. Put wild character asterisk '*' in you need to get entire list of tRFC's ...
Posted in SAP BW | 1 Comment »
July 8, 2008 – 5:32 pm
This article explains on how to analyze a long running BW load/job.
STEP 1:
Go to T-code 'RSMO' and identify the long running load. Then find the 'Request Number' of the load as shown in below pic.
STEP 2:
Clicking on the Req. No. pops up a window as shown in below pic. Copy this Req. No.
STEP 3:
Then goto the Job monitor screen (T-code: SM37) in the source system (Same system if source exist in the same SAP system) and enter the Req. No. we got in STEP 2 as shown below, prefixed with an asterisk '*' and then hit 'Execute' button.
This will take you to 'Job Overview screen' as shown below.
STEP 4:
Double clicking on the job in above screen takes you to below screen. Here click on 'Job details' button
STEP 5:
From the job details screen note the PID# as shown below
STEP 6:
Now goto T-code 'sm66' screen which give the global work ...
Posted in SAP BW | No Comments »
July 5, 2008 – 1:18 pm
By: Venkat Pulluri
Creating Info Objects: Characteristics
STEP 1
Goto T-Code 'RSA1' (AWB) and search for the InfoArea 'Demo Info Area' we created in Part 1
Right Click 'Demo: Info Object Catalog- CHAR' and then select 'Create Info Object'
STEP 2
Enter a name and Description, and then Click to Continue.
STEP 3
Select 'CHAR' as the Data Type, enter '15' for the field Length, and then click the tab 'Attributes'.
STEP 4
Enter an attribute name 'MATNM_IO' and then click to create the attribute.
NOTE: Notice that MATM_IO is underlined and works like an hyperlink. After MATM_IO is created, when you click 'MATM_IO' hyperlink and it will lead you to MATM_IO’s detail definition window.
STEP 5
Select the option 'Create Attribute As Characteristic' and then click to continue.
STEP 6
Select 'CHAR' as the Data Type, and then enter '30' for the field Length. Notice that the option 'Attribute Only' is selected by default. Click to continue.
Note: If 'Attribute Only' ...
Posted in SAP BW | No Comments »
July 2, 2008 – 11:18 am
Part 1 : Creation of InfoArea, InfoObject Catelog
Part 2 : Creation of InfoObjects: Characteristics and Key Figures
Part 3 : Creation of InfoCube
Part 4 : MasterData Loading
Posted in SAP BW | 4 Comments »
July 1, 2008 – 6:43 pm
By Venkat Pulluri
Creating Info Area
STEP 1
After logging on to the BI System, run transaction RSA1, or double-click the Administrator work bench. (Use TRAN CODE: RSA1OLD for BW3.5 AWB)
STEP 2
In the new window, click Info Provider under Modeling in the left panel, In the right panel, right-click info Provider and select Create Info
STEP 3
Enter Name and a Description for the Info Area, and then click button to continue
======================================================================
Creating Info Object Catalogs
STEP 1
In the new window, click Info Provider under Modeling in the left panel, in the right panel, right-click Demo Info Area, and Create info object Catalog……
STEP 2
Enter a Name and a Description fro the Info Object Catalog, select the option Char., and then Click to create the Info Object Catalog.
STEP 3
In the new window, click to check the Info Object Catalog. If it is valid, click to activate the Info ...
Posted in SAP BW | No Comments »
June 29, 2008 – 1:35 pm
As we know, the production SAP BW daily batch comprises of extracting data from the source systems like SAP R/3 and other database systems and then loading into corresponding data targets in SAP BW.
Here is the list of of common SAP BW prodcution support issues we encounter in daily BW batch.
Long running BW loads and ultimately leading to max. run time failures
BW loads failing due to lock issues on the objects
Load failures due to duplicate data being extracted from source system
Load failures due to Number range buffering / SID generation errors
ODS activation failures
Fill aggregates / infocube compression step failures
Load failures due to invalid chars in the data
Connection issues between SAP systems and IDOC processing failures
Occasional datasource replication issues
Detailed explanation of the error cause and how to fix the above issues will be posted in coming posts.
[ad#ad-6]
Posted in SAP BW, SAP R/3 Extraction | No Comments »
June 21, 2008 – 4:42 pm
By:arun
This post explains creating a generic DataSource in SAP R/3 which uses a Funtion Module to extract data and this DataSource can be used in SAP BI/BW to extract data from R/3.
Function Module Extraction Steps:
1) Go to T-Code SE11
Check Data Type check box and enter ZFM_EXST_VBAK and press create button
2) A small window pop's up select check box Structure and press Tick mark.
3) Maintain Structure Windo pop's up give Short Description, then click on Components header, In Component and Component type give the extraction Structure necessary fields as shown. The Currency WEARK field and Quantity NETWR fields much be included with reference fields.
4) Now go Currency/quantity fields as shown.
NETWR Net value in document currency field, must have reference field that in in the base table. Enter Currency / Quantity field name as shown and Activate it
5) Create Object Directory Entry Window pop's up Give Package name as $temp, save it ...
Posted in SAP R/3 Extraction | 6 Comments »
June 18, 2008 – 11:19 pm
By Suresh Donga
Transactional InfoCubes are used in connection with the entry of planning data.
The data from T-Cube is accessed Transactionally, i.e. Data is written to the InfoCube (possibly by several users at the same time). While Standard InfoCubes are used for Read-Only access.
Transactional InfoCubes can be filled with data using two different methods: Loading planned data via BW-BPS or via BW Staging, where no planned data can be loaded.
Creating a Transactional InfoCube:
STEP1: GoTo T-Code RSA1, Creat an InfoArea and then Rt.Click on InfoArea and select Create InfoCube as shown
STEP2: Then it popup the new screen, Give name of InfoCube and Description , then Select the Check box Real Time and then Press Create as shown
STEP3: Now assign the Characteristics to the Created dimensions & KeyFigures to the keyfigs folder same as we normally do for the cube and Activate.
This is how we Create a Transaction Cubes, Now we will ...
Posted in SAP BW | 1 Comment »
June 12, 2008 – 12:51 pm
By : Rajesh Gundoji
This is a simple example to create a Web Template using WAD( Web application Designer).
The three main work areas in a WAD are Web Items, Template, and Properties. Fig 1 shows the window after logging into WAD. Start-->programs--->Business Explorer--->WAD.
Fig 1
Step1. Click on Create a new template then a window will pop up, select blank web template. Name your Web template in the General tab of the Properties work area.
Fig 2
Selecting Web Items
Step2. Select the Web Items as per your requirement from the Web Items Work area and just drag and drop them into the blank Web Template (Fig 2).
Fig 3
Defining Properties for the Web Items
Step3. Defining the source for the Web Items, so that it behaves the way source is defined.Select the Web Item and
click on New Data Provider (Properties--->GeneralTab---> Data Provider Assignment Type).
A new window pops up (Fig 3), Where we can ...
Posted in SAP BW | No Comments »
June 1, 2008 – 2:03 am
Created By: Arun
STEP 1: In R/3 Go to command bar use T-code 'SQ02'
Give a Infoset name and press create button
A new window pops up, give name and select the check box Direct read table and give table name(Example VBAP) to extract as shown and press continue button.
STEP 3: A small window pops up check the box create empty field groups and press continue.
STEP 4: Here a new window pops up, Drag the table fields you want to extract from left to right folder.
(here we are creating extraction structure of the infoset adding field at right side)
Then press generate button.
STEP 5: window pops up give package name and press local object.
( after pressing local object Infoset generated was see at the bottom)
STEP 6:Now Create the Data Source using Tcode -RSO2
Check the check box create transaction data and give any name and press create.
STEP 7: Below data source window ...
Posted in SAP BW | 4 Comments »
May 28, 2008 – 8:37 pm
By: Ravi Bommineni
These steps explain how to access an SE38 ABAP program withou using the t-code SE38
Go any of the update rules.
Click on Display activated program
Click on others
Click on program, enter the program name and continue
Now you will be in the program you wanted to access.
Posted in SAP BW | 1 Comment »
May 27, 2008 – 6:13 pm
By: Suresh Donga
STEP1: Double Click on the Transformations under your Target (in this example ODS) as shown below.
STEP2: Go to change mode of the Transformations. Then double Click on the Rule you want to change (Here Revenue = Price * Qty)as shown below.
STEP3: Give Description of the formula in the new popup window, and then go to Source Fields of Rule to add the Fields that are required to use in the Formula (Here PRICE & QUANTITY Fields) as shown.
STEP4: Now GoTo Rule Type and change it to Formula (To write a Formula) OR to Routine (To write a Routine) as shown.
STEP5: Double Click on the Price-Field, Multiplication Operator and Quantity-field to come in to Formula window as numbered in the figure below. After writing the Formula Go for SYNTAX CHECK (numbered 4) shown below.
STEP6: Now go back and press F8 . Then Activate the Changed Transformations. Now you ...
Posted in SAP BW | 4 Comments »
May 21, 2008 – 4:40 pm
By: Venkat Pulluri
Pre req: You need to have DEBUG access in the SAP system.
STEP 1
Display the table records using SE16 (For illustration below is the active table of an ODS).
STEP 2
Enter '/h' in command line & Press enter.
Display The records by pressing the Display Button
It will take to Debugging screen.
(Change to classic debugger if you're in new BI7 debugger as shown below).
Press F7 it reach the below screen
STEP 3
Press F5 to place the cursor on above line. Double click on CODE to display the value in Field names, bottom of the above screen. Delete SHOW, enter EDIT and press change button (R-hand bottom) to change the CODE value.
STEP 4
Then F8, It will show the below screen to change the records manually. Change the values of record and press save to save the record in the table with new value. Do the changes for next records by pressing arrow button ...
Posted in SAP, SAP BW | 1 Comment »
May 19, 2008 – 1:34 pm
Everyday handy list of BW tricks and useful tips. If you have any of your own, please feel free to share....
Table TSTC contains all the t-codes availabe in the system. This even contains the custom (zxxxxx) created ones
To find who has changed an object recently; Tab E071 gives the CRs that changed the object, input this CR info in Tab E070 to find the user name
T-code SE39 can be used to compare programs or update rules across different sytems. This is very useful to match the code between developement and production systems
T-code SM21 can be useful in finding additional information on failures in a system along with ShortDumps(t-code ST22)
Easiest way to get the table name of PSA; go to Tab RSTSODSPART and input the Request number from the load monitor. Field ODSNAME_TECH gives the PSA
[ad#ad-6]
Posted in SAP BW | 2 Comments »
May 17, 2008 – 9:04 am
Hello BW Techies,
Here is the list of a few SAP BW Interview questions that can be considered as FAQ.
Keep checking for the updates as we will keep adding more to the list regularly.
Differences between an ODS/DSO and an InfoCube
Differences between TransferRules and UpdateRules
What is the role of StartRoutine in TransferRules and UpdateRules
Performance improvement in loading and reporting
Difference between RollUp and Compression
What is the role of ChangeRun
What is a ShortDump
What is the use of NumberRange Buffering
Use of LineItem Dimension and HighCardinality check options in a InfoCube
Use and limitations on Partitioning of an InfoCube
[ad#ad-5]
Posted in SAP BW | 2 Comments »
|
|
