Wednesday, October 13, 2010

Initial BI Settings for Portal and BI Integration

After we have integrated BI with Portal, there are few initial BI Settings which has to be done by Portal Administrator to go forward.
Let's have a look as what need to be done at the BI server end.
Procedure:
1.  Start the transaction Table View Maintenance (transaction code SM30).
2. Enter RSPOR_T_PORTAL as the table.
3.Choose Maintain.
4.To create a new entry, choose New Entries.
5.Maintain the connected portal:
a) RFC destination:
b) Name of the system: ( Please give the system which has been created in the Portal)
c) Default:
d) Portal URL Prefix: , for example, http://:
e) RM prefix for BW metadata: , for example /bw_metadata
f) KM Service URL:
6. Save your entries.
Posted by Prashanth K at 12:48 PM 0 comments
Labels:

Tuesday, October 12, 2010

Upgrade & Migration -Wiki links

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=85000722

 

Technical and Functional Migration

Changed Terminology for BI in SAP NetWeaver 7.0 (2004s)

A summary of changed and new terminology for BI7.0

Upgrade to Netweaver BI 7.0- SAP Noteshttps://wiki.sdn.sap.com/wiki/display/BI/Upgrade+to+NetWeaver+BI+7.0+%28SAP+Notes+%29

Important notes for upgrading to SAP BI7.0

Upgrade from BW 3.X to BI 7.0 (SP13)

Upgrade strategy for Upgrading from BW3.x to BI7.0

Technical and Functional upgrade from 3.1 to 7.0

Details on Technical and Functional Upgrade from BW3.1 to 7.0

Migration of 3.x objects to BI 7.0

A summary on how Objects created in 3.x are to be migrated to 7.0. Objects here would mean SAP BI Objects

Changes in BI 7.0 & BW 3.5

A summary of changes to terminology and new additions in SAP BI 7.0 that will help you understand the new SAP BI 7.0 system better

Query Migration and Learnings

Migration of 3.x BEx Queries to BI7.0 - Useful Tips

Useful Tips on how and what to watch out for when migrating BEx Queries from their 3.x versions to the new 7.0 version

Queries or Workbooks Migration - Errors and Fixes

Common Errors and their resolution when migrating BEx workboks from their 3.x version to the new 7.0 version

BW Report Migration Issues

Common issues when migrating BW Reports
Posted by Prashanth K at 5:02 PM 0 comments
Labels:

Migration of Queries and Work Books from BW 3.x to BI 7

Introduction
This Blog Explains step by step procedure for Migration of Queries and Work Books from BW 3.x to BI 7.0 and also explains the lessons learned while migrating reports/work books from bw 3.x to BI 7.This Blog is useful for consultants who are going to work on migration of reports and work books Projects in BW.
Pre-requisites for Migration
Install the new SAP GUI release 7.10 with Latest Patch level.
Make sure that all the Migration team should have the same version of GUI and Excel.
After new GUI installation, make sure that you should have both 3.x BEX options and 2004s BEX options are available.
Migration Process:
Migration will happen when the Existing 3.x objects (Queries and Workbooks) are opened in the new tools (Using BI 7 Bex Options).
Query Migration:
Open the Existing Query in change mode with the new 2004s BEX Query Designer and Save the Query.
Once you save the Query it will be automatically migrated.
Query Migration Procedure:
Before Migration Check the Table RSZCOMPDIR:
Enter your Query Technical Name as input to the field COMPID in the table RSZCOMPDIR and execute.
Field VERSION in the Table RSZCOMPDIR should have the value below 100, It means Query is in 3.x version…
If it is Greater Than 100 means, it is already Migrated. Here it is ‘15’, means query is not yet migrated

image1

Open the existing query using the BI7 Query Designer and Save it. It will be automatically Migrated.

image2
Now you can check your RSZCOMPDIR table will have a value which is more than 100 for the field VERSION…Here it is ‘101’, means it is Migrated.

image3
Note: Once a Query is migrated to BI7, system will not allow editing the Query using 3.x Query Designer. However, it will allow execution of the Query in 3.x.
Workbook Migration:
Open the Existing 3.x Workbook by using the 2004s BEX analyzer and Save the Work Book. Once you save the Work Book, it will be automatically migrated.
Standard Workbooks are automatically upgraded.
Workbooks with customer coding (If there are any macros exists) will need manual adoption.
Work Book Migration Procedure:
Open the existing Workbook from BI 7 Bex Analyzer and Save it…It will be automatically Migrated.
image4
Note: Should delete data in the Work Book before Save it
Once a Workbook is Migrated, we will not be able to open it using the 3.x version.
Posted by Prashanth K at 4:52 PM 0 comments
Labels:

Thursday, October 7, 2010

Analyzing Throughput Times Process Chains


To analyze your process chains in SAP BI (but also other BI elements, SAP provides the program /SSA/BWT.
How to use:
Select the first bullet after running the program in SA38:
Enter the technical name of the process chain to be analyzed:
In the following screen you can see all details of the different process chain runs, but also compare different process chain runs with each other.
This program is very useful when you want to analyse why a certain process chain is taking longer.
Try it out!
Posted by Prashanth K at 6:41 PM 0 comments
Labels:

Extraction Logistics Datasources: Tcode and program


An overview of Datasources and the programs filling the relevant setup table (named MC*SETUP). With this handy table you can find the status of your current job or previous initialization jobs through SM37.
DatasourceTcodeProgram
2LIS_02*OLI3BW RMCENEUA
2LIS_03_BXMCNBRMCBINIT_BW
2LIS_03_BFOLI1BWRMCBNEUA
2LIS_03_UMOLIZBWRMCBNERP
2LIS_04* ordersOLI4BWRMCFNEUA
2LIS_04* manufacturingOLIFBWRMCFNEUD
2LIS_05*OLIQBWRMCQNEBW
2LIS_08*VTBWVTRBWVTBWNEW
2LIS_08* (COSTS)VIFBWVTRBWVIFBW
2LIS_11_V_ITMOLI7BWRMCVNEUA
2LIS_11_VAITMOLI7BWRMCVNEUA
2LIS_11_VAHDROLI7BWRMCVNEUA
2LIS_12_VCHDROLI8BWRMCVNEUL
2LIS_12_VCITMOLI8BWRMCVNEUL
2LIS_12_VCSCLOLI8BWRMCVNEUL
2LIS_13_VDHDROLI9BWRMCVNEUF
2LIS_13_VDITMOLI9BWRMCVNEUF
2LIS_17*OLIIBWRMCINEBW
2LIS_18*OLISBWRMCSNEBW
2LIS_45*OLIABWRMCENEUB
Posted by Prashanth K at 6:40 PM 0 comments
Labels:

Monday, October 4, 2010

FM RSBM_GUI_CHANGE_USTATE

I have loaded master data through DTP. The background job failed with a dump. Now I could not turn the status to red from DTP monitor. As it is not allowing to set the status for master data. As this request is in yellow state system is not allowing me to do another load also.
I tried doing in table RSREQDONE. It is not effecting the changes in DTP monitor.
I looked up in SDN forum there was a post to follow the below steps.

This request sits in table RSBKREQUEST with processing type as 4 in data elements USTATE, TSTATE and this 4 is actually "WIP" status which is obviously wrong.

All we need is, ask your basis person to change the status to 3 in both these data elements.Then you can repeat the load.....Once you repeat the load.......the request status gets updated as "4" in table RSBKREQUEST.
For manually status change you can use the function module RSBM_GUI_CHANGE_USTATE

Issue resolved.
Posted by Prashanth K at 12:38 PM 0 comments
Labels:

Frequently used Transaction Codes in BI

"Search Transaction"-Transaction: se93
S.No
Tcode
Description
1
RSA1
Administrator Work Bench
2
RSA11
Calling up AWB with the IC tree
3
RSA12
Calling up AWB with the IS tree
4
RSA13
Calling up AWB with the LG tree
5
RSA14
Calling up AWB with the IO tree
6
RSA15
Calling up AWB with the ODS tree
7
RSA2
OLTP Metadata Repository   
8
RSA3
Extractor Checker    
9
RSA5
Install Business Content   
10
RSA6
Maintain DataSources    
11
RSA7
BW Delta Queue Monitor  
12
RSA8
DataSource Repository    
13
RSA9
Transfer Application Components   
14
RSBBS
Maintain Query Jumps (RRI Interface)
15
RSD1
Characteristic maintenance    
16
RSD2
Maintenance of key figures  
17
RSD3
Maintenance of units   
18
RSD4
Maintenance of time characteristics  
19
RSDBC
DB connect    
20 
RSDCUBE
Start: InfoCube editing   
21
RSDCUBED
Start: InfoCube editing   
22
RSDCUBEM
Start: InfoCube editing   
23
RSDDV
Maintaining     
24
RSDIOBC
Start: InfoObject catalog editing  
25
RSDIOBCD
Start: InfoObject catalog editing  
26
RSDIOBCM
Start: InfoObject catalog editing  
27
RSDL
DB Connect - Test Program 
28
RSDMD
Master Data Maintenance w.Prev. Sel. 
29
RSDMD_TEST
Master Data Test   
30 
RSDMPRO
Initial Screen: MultiProvider Proc.  
31
RSDMPROD
Initial Screen: MultiProvider Proc.  
32
RSDMPROM
Initial Screen: MultiProvider Proc.  
33
RSDMWB
Customer Behavior Modeling   
34
RSDODS
Initial Screen: ODS Object Processng 
35
RSDS
Data Source Repository

36
RSIMPCUR
Load Exchange Rates from File 
37
RSINPUT
Manual Data Entry   
38
RSIS1
Create InfoSource    
39
RSIS2
Change InfoSource    
40 
RSIS3
Display InfoSource    
41
RSISET
Maintain InfoSets    
42
RSKC
Maintaining the Permittd Extra Chars 
43
RSLGMP
Maintain RSLOGSYSMAP    
44
RSMO
Data Load Monitor Start  
45
RSMON
BW Administrator Workbench   
46
RSOR
BW Metadata Repository   
47
RSORBCT
BI Business Content Transfer  
48
RSORMDR
BW Metadata Repository   
49
RSPC
Process Chain Maintenance   
50 
RSPC1
Process Chain Display   
51 
RSPCM
Monitor daily process chains  
52 
RSRD_ADMIN
Broadcasting (7.x) Administration  
53
RSRCACHE
OLAP: Cache Monitor   
54
RSRT
Start of the report monitor 
55
RSRT1
Start of the Report Monitor 
56
RSRT2
Start of the Report Monitor 
57
RSRTRACE
Set trace configuration   
58
RSRTRACETEST
Trace tool configuration   
59
RSRV
Analysis and Repair of BW Objects
60 
SE03
Transport Organizer Tools   
61 
SE06
Set Up Transport Organizer  
62 
SE07
CTS Status Display   
63
SE09
Transport Organizer    
64
SE10
Transport Organizer    
65
SE11
ABAP Dictionary    
66
SE18
Business Add-Ins: Definitions   
67
SE18_OLD
Business Add-Ins: Definitions (Old)  
68
SE19
Business Add-Ins: Implementations   
69
SE19_OLD
Business Add-Ins: Implementations   
70
SE21
Package Builder    
71
SE24
Class Builder    
72
SE80
Object Navigator    
73
SE91
Create Newsclasses     
74
SE93
Transaction Overview    
75
RSCUSTA
Maintain BW Settings   
76
RSCUSTA2
ODS Settings    
77
RSCUSTV*

78
RSSM
Authorizations for Reporting   
79
SM04
User List    
80
SM12
Display and Delete Locks  
81
SM21
Online System Log Analysis  
82
SM37
Overview of job selection  
83
SM50
Work Process Overview   
84
SM51
List of SAP Systems  
85
SM58
Asynchronous RFC Error Log  
86
SM59
RFC Destinations (Display/Maintain)   
87
SU20
Authorization Fields   
88
SU21
Authorization Objects   
89
LISTCUBE
List viewer for InfoCubes  
90
LISTSCHEMA
Show InfoCube schema   
91
WE02
Display IDoc    
92
WE05
IDoc Lists    
93
WE06
Active IDoc monitoring   
94
WE07
IDoc statistics    
95
WE08
Status File Interface   
96
WE09
Search for IDoc in Database 
97
WE10
Search for IDoc in Archive 
98
WE11
Delete IDocs    
99
WE12
Test Modified Inbound File  
100
WE14
Test Outbound Processing   
101
WE15
Test Outbound Processing from MC 
102
WE16
Test Inbound File   
103
WE17
Test Status File   
104
WE18
Generate Status File   
105
WE19
Test tool    
106
WE20
Partner Profiles    
107
WE21
Port definition    
108
WE23
Verification of IDoc processing  
109
DB02
Tables and Indexes Monitor  
110
DB14
Display DBA Operation Logs  
111
DB16
Display DB Check Results  
112
DB20
Update DB Statistics   
113
KEB2
DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3
114
RSD5
Edit InfoObjects    
115
SM66
Global work process Monitor
116
SM12
Display and delete locks
117
OS06
Local Operating System Activity
118
RSKC
Maintaining the Permittd Extra Chars
119
SMQ1
qRFC Monitor (Outbound Queue)
120
Changerunmoni

121
RSREP
Reporting Agent maintenance screen
Posted by Prashanth K at 12:20 PM 0 comments
Labels:

BI FAQ - Important Transaction Codes in SAP Business Intelligence

Compiled below is a list of  Transaction codes used in SAP BI - please correct or add to it if you feel that something is required.

Tcode Description
DB02 Tables and Indexes Monitor
DB14 Display DBA Operation Logs
DB16 Display DB Check Results
DB20 Update DB Statistics
KEB2 DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3
LISTCUBE List viewer for InfoCubes
LISTSCHEMA Show InfoCube schema
LBWE LO Data Extraction: Customizing Cockpit
LBWF BW Log
LBWG To Delete Setup Tables
OLI*BW To fill Setup Tables (* Application Component) [ie 7 for SD Sales Orders]
OS06 Local Operating System Activity
OB08 Currency Exchange Rates
RSA1 Administrator Work Bench
RSA2 OLTP Metadata Repository
RSA3 Extractor Checker
RSA5 Install Business Content
RSA6 Maintain DataSources
RSA7 BW Delta Queue Monitor
RSA8 DataSource Repository
RSA9 Transfer Application Components
RSA11 Calling up AWB with the IC tree
RSA12 Calling up AWB with the IS tree
RSA13 Calling up AWB with the LG tree
RSA14 Calling up AWB with the IO tree
RSA15 Calling up AWB with the ODS tree
RSBBS Maintain Query Jumps (RRI Interface)
RSBICA Modeling BI Integrated Planning
RSCUSTA Maintain BW Settings
RSCUSTA2 ODS Settings
RSCUSTV*  
RSD1 Characteristic maintenance
RSD2 Maintenance of key figures
RSD3 Maintenance of units
RSD4 Maintenance of time characteristics
RSD5 Edit InfoObjects
RSDBC DB connect
RSDCUBE Start: InfoCube editing
RSDCUBED Start: InfoCube editing
RSDCUBEM Start: InfoCube editing
RSDDBIAMON BI Accelerator Monitor
RSDDV Maintaining
RSDIOBC Start: InfoObject catalog editing
RSDIOBCD Start: InfoObject catalog editing
RSDIOBCM Start: InfoObject catalog editing
RSDL DB Connect - Test Program
RSDMD Master Data Maintenance w.Prev. Sel.
RSDMD_TEST Master Data Test
RSDMPRO Initial Screen: MultiProvider Proc.
RSDMPROD Initial Screen: MultiProvider Proc.
RSDMPROM Initial Screen: MultiProvider Proc.
RSDMWB Customer Behavior Modeling
RSDODS Initial Screen: ODS Object Processing
RSDS Data Source Repository
RSIMPCUR Load Exchange Rates from File
RSINPUT Manual Data Entry
RSIS1 Create InfoSource
RSIS2 Change InfoSource
RSIS3 Display InfoSource
RSISET Maintain InfoSets
RSKC Maintaining the Permitted Extra Chars
RSLGMP Maintain RSLOGSYSMAP
RSMO Data Load Monitor Start
RSMON BW Administrator Workbench
RSOR BW Metadata Repository
RSORBCT BI Business Content Transfer
RSORMDR BW Metadata Repository
RSPC Process Chain Maintenance
RSPC1 Process Chain Display
RSPCM Monitor daily process chains
RSPLAN Modeling BI Integrated Planning
RSPLSE BI Planning Lock Management
RSRCACHE OLAP: Cache Monitor
RSRT Start of the report monitor
RSRT1 Start of the Report Monitor
RSRT2 Start of the Report Monitor
RSRTRACE Set trace configuration
RSRTRACETEST Trace tool configuration
RSRV Analysis and Repair of BW Objects
RSSM Authorizations for Reporting
RZ20 To see log for Process Chains
SE03 Transport Organizer Tools
SE06 Set Up Transport Organizer
SE07 CTS Status Display
SE09 Transport Organizer
SE10 Transport Organizer
SE11 ABAP Dictionary
SE18 Business Add-Ins: Definitions
SE18_OLD Business Add-Ins: Definitions (Old)
SE19 Business Add-Ins: Implementations
SE19_OLD Business Add-Ins: Implementations
SE21 Package Builder
SE24 Class Builder
SE80 Object Navigator
SE93 to view Transaction Codes
SM04 User List
SM12 Display and Delete Locks
SM21 Online System Log Analysis
SM37 Overview of job selection
SM50 Work Process Overview
SM51 List of SAP Systems
SM58 Asynchronous RFC Error Log
SM59 RFC Destinations (Display/Maintain)
SM66 Global work process Monitor
SMQ1 qRFC Monitor (Outbound Queue)
SMQ2 qRFC Monitor (Inbound Queue)
ST22 ABAP Runtime Error (Dumps)
ST14 BW Evaluation Application Analysis
WE02 Display IDoc
WE05 IDoc Lists
WE06 Active IDoc monitoring
WE07 IDoc statistics
WE08 Status File Interface
WE09 Search for IDoc in Database
WE10 Search for IDoc in Archive
WE11 Delete IDocs
WE12 Test Modified Inbound File
WE14 Test Outbound Processing
WE15 Test Outbound Processing from MC
WE16 Test Inbound File
WE17 Test Status File
WE18 Generate Status File
WE19 Test tool
WE20 Partner Profiles
WE21 Port definition
WE23 Verification of IDoc processing
Posted by Prashanth K at 12:20 PM 0 comments
Labels: