Go to DTP and hit the process chain maintance button --> this will show the process chains where this is used.
OR
Right click on DTP - If 'process chain' option is enabled for navigation it means it's already used by Process chain - click on it will take you to PC
If it's disabled then It's not locked in any PC
Monday, August 30, 2010
Wednesday, August 11, 2010
Displaying InfoProvider Contents using Tcode RSRT
The common method to display contents of an InfoProvider, is to right-click the Infoprovider in the EDW workbench (RSA1 screen) and choose ‘Display Data'. This technique is a bit tedious as one needs to search and select the necessary characteristics from the set of characteristics which make up the Infoprovider. This weblog is to provide information on a quicker way to view Infoprovider contents.
A faster way to view Infoprovider data without choosing characteristics is by using transaction code RSRT. The quick turn around time of this method in turn helps in reducing Unit testing time, in a typical BI implementation.
Step-By-Step
The below steps demonstrate this feature step-by-step:
1. Log-in to BI system and goto transaction code RSRT. In the selection for ‘Query', enter the name of the InfoProvider in exactly the following format
Infoprovider/! Infoprovider.
2. Choose Query Display as ‘HTML' and click on Execute.
3. The Infoprovider data (all key figures) is summarized in a single row and is displayed as a regular BEx Query output, in the next screen.
"
Now use the required ‘Free characteristics' (these are all characteristics present in the MultiProvider/ Infocube/ DSO) to analyse the InfoProvider data.
Since we have chosen the Query display to be in HTML, it is a much faster way to view InfoProvider data as compared to right click and choosing ‘Display Data'.
Alternately, one could also use the BEx Query Designer to display the InfoProvider data in Excel. This is a standard feature of BI 7.0. In the Create Query Dialog box, choose name of the InfoProvider for which you would like to display data. This method will agian have limitations of viewing BI data in excel format.
A faster way to view Infoprovider data without choosing characteristics is by using transaction code RSRT. The quick turn around time of this method in turn helps in reducing Unit testing time, in a typical BI implementation.
Step-By-Step
The below steps demonstrate this feature step-by-step:
1. Log-in to BI system and goto transaction code RSRT. In the selection for ‘Query', enter the name of the InfoProvider in exactly the following format
Infoprovider/! Infoprovider.
2. Choose Query Display as ‘HTML' and click on Execute.
3. The Infoprovider data (all key figures) is summarized in a single row and is displayed as a regular BEx Query output, in the next screen.
" Now use the required ‘Free characteristics' (these are all characteristics present in the MultiProvider/ Infocube/ DSO) to analyse the InfoProvider data.
Since we have chosen the Query display to be in HTML, it is a much faster way to view InfoProvider data as compared to right click and choosing ‘Display Data'.
Alternately, one could also use the BEx Query Designer to display the InfoProvider data in Excel. This is a standard feature of BI 7.0. In the Create Query Dialog box, choose name of the InfoProvider for which you would like to display data. This method will agian have limitations of viewing BI data in excel format.
Sunday, August 8, 2010
Infocube Creation Steps using SAP BI 7.0
There are some differences in SAP BI 7.0 while creating objects. We will see how to create InfoCube and other related Objects in SAP BI 7.0.
Infocube uses concept of star schema. Infocube is created using Characteristics and Key Figures.
Characteristics are levels on which reporting has to be performed. For example, Product, Customer and Plant.
Key Figures are measures used for characteristics. For example, sales quantity for a product, customer and location combination.
In this section we will discuss InfoArea and InfoObject Catalog creation steps in SAP BI 7.0.
1) Logon to SAP and Execute transaction RSA1, shown below is the left hand side panel
2) Select the InfoProvider at right hand side panel and select 'Create InfoArea;
3) Enter name and description for InfoArea
4) Go to InfoObjects at left hand panel, select the InfoArea created and right click to create 'InfoObject Catalog'
5) Create InfoObject Catalog for Characteristics and Key Figures
6) Select the InfoObjects for InfoObject Catalog as shown below
7) Enter the InfoObjects and select 'Continue'
8) Activate the InfoObject Catalog
9) InfoObject Catalog is created as shown below
In next section, we will see how to create InfoCube in SAP BI 7.0
Friday, August 6, 2010
How to Configure alert emails for Process Chain errors?
Would like to share this information regarding email alerts whenerrors occur in Process Chains.Step by step process to follow:
1. go to ALRTCATDEF
2. select classification "Process Chains"
3. click on display/change
4. double-click on "error in a process of a process chain"
5. click on "fixed recipients"
6. write in your username (you have to maintain your e-mail address in SU01 for that to work)
7. save
8. go to your process chain (rspc)
9. go into edit mode
10. from the menu, select Process chain -> attributes -> alerting
11. check "send alerts if errors occur"
1. go to ALRTCATDEF
2. select classification "Process Chains"
3. click on display/change
4. double-click on "error in a process of a process chain"
5. click on "fixed recipients"
6. write in your username (you have to maintain your e-mail address in SU01 for that to work)
7. save
8. go to your process chain (rspc)
9. go into edit mode
10. from the menu, select Process chain -> attributes -> alerting
11. check "send alerts if errors occur"
- Steps 1 to 7 should be done once to configure.
- Follow steps 8 to 10 for the process chains for which alert emails are required.