CRM-BI Integration (Account Factsheet)

[former_member186644]

There are 11 BW blocks in the Account Fact Sheet.Each BW block has a unique BI report ID.

Block	BI report ID
Last Closed Activities	0TPLB_0CSAL_C01_Q0009_1
Account Classification	0TPLB_0BP_C00_Q0002_1
Account Revenue (Graph)	0TPLB_0CRM_FSC1_Q0002_1
Account Revenue (Table)	0TPLB_0CRM_FSC1_Q0002_2
Sales Pipeline	0TPLB_0CSALMC02_Q009_V01
Backorders	0TPLB_0CRM_SALO_Q001_1
Service Overview	0TPLB_0CSRVMC01_Q0101_V01_FS
Top 5 Products for Previous 12 Months	0TPLB_0CSRVMC02_Q0107_V01_FS
Customer Service	0TPLB_0CRM_FSC1_Q0001_V01_FS
Customer Attributes	0TPLB_0CRM_SOLDTO_Q0001_V01
Expiring Service Contract Items	0TPLB_0CSAL_C07_Q0107_V01_FS

Defining the BI reports in the Customizing System

• Launch the Transaction CRMC_UI_BI in the customizing system.

Define the all the 11 BI reports...

Defining the Assignment Blocks of the Account Fact Sheet overview

• Open the transaction SM34 and enter the View Cluster name as BSPVC_DLC_FS and click on Display.
• Select the BP_ACCOUNT_FACTSHEET and double click on View Assignment

• Click on the Change icon and maintain the View Assignments. The assignments that are maintained in this View will display
  as assignment blocks in Account Fact Sheet overview.

Maintaining the Account Fact Sheet overview configuration.

The Framework provides a component for the Account Fact Sheet overview configuration.

The Views that have been maintained in the BSPVC_DLC_FS view cluster under the Fact Sheet ID BP_ACCOUNT_FS
will be available in the configuration of the Framework component BSP_DLC_FS.
Hence they can be configured in the configuration of the BSP_DLC_FS/factsheet view of the BSP_DLC_FS component.

• Open the Component BSP_DLC_FS in the development system.
• Open the view BSP_DLC_FS/factsheet
• Go to the configuration of that view.
• Select Fact Sheet as “Account Fact Sheet” and Role Key as “<DEFAULT>”
• Click on Continue.

• For the BW assignment blocks select the BI Report views from the Available Fact Sheet views and move it to the Assigned
  Fact Sheet Views. One view can be assigned multiple times with different Title.
  For the 11 BW blocks the BI Report has to be moved to the Assigned Fact Sheet
  Views 11 times with each having different Title

• Click on the Show Technical Details button to display the technical details and make not of the Usage Counter of every block.

Maintaining the Configuration of BW views in BP_FACTSHEET view

The BP_FACTSHEET component is the Account Fact Sheet component.

• Open the Component BP_FACTSHEET
• Open the view BP_FACTSHEET/BIReportProxy
• Go to the Configuration of the view BP_FACTSHEET/BIReportProxy.
• The configuration of the view is provided by the Framework
• For each of the BW view one configuration needs to be created with the following parameters

      Role Key =
     <DEFAULT>

Component
Usage = Concatenation of BP_FACTSHEET and the Usage Counter of the Block in the configuration of BSP_DLC_FS component

(e.g. Component usage for Last Closed Activities = BP_FACTSHEET0010)

Object Type = BP_ACCOUNT_FS

Object Sub Type = <DEFAULT>

• Once the configuration is created click on the Attributes button on the configuration.

• Enter the REPID as the BI Report ID of the corresponding BW view
• Enter the ADDPARAMETER as the String &filter_iobjnm_1=&1&filter_value_1=&2&filter_iobjnm_2=&3&filter_value_2=&4

Here &1 is the name and &2 is the value of the first input parameter of the BI report.

The string will vary depending on the number of the input parameters of the corresponding BI report.e.g. for a BI report that takes 3 input parameter the
string will be &filter_iobjnm_1=&1&filter_value_1=&2&filter_iobjnm_2=&3&filter_value_2=&4&filter_iobjnm_3=&5&filter_value_3=&6

Same procedure needs to be followed for all the other BW views.

Passing the input parameter value to the BI reports

• Go to the IF_EX_BSP_DLC_FS~GET_BI_REP_PARAMETER method of the Enhancement Implementation BP_FACTSHEET  of the BAdI BSP_DLC_FS_BADI

In this method the code has to be written in order to pass the value of the parameters to the BI reports of the Account Fact Sheet overview.

This method has been called in the INIT_BI_CONTEXT method of the controller class of the component controller of the BP_FACTSHEET component.

Now inside this BADI a new when clause has to be maintained for the case statement which will pass the input parameters for the newly created BI Report.

Here below mentioned is the sample implementation for that:

Suppose you have a BI report which accepts just one filter parameter, then in the configuration you will maintain it as the string given below:

&filter_iobjnm_1=&1&filter_value_1=&2

First one ‘ &1’ is the parameter name on the BI report and the ‘&2’ second one is the parameter value that we need to pass into the report.

BI repoRt name should be replaced with your report name.

cv_add_parameter
will have the string maintained in the customizing i.e &filter_iobjnm_1=&1&filter_value_1=&2.

Now just replace &1 with object name and &2 with the value.

Repeat the same if the report has multiple values.

          WHEN 'BI report name'.
*         first add business partner number to parameters

            REPLACE '&1' IN cv_addparameter WITH '0BP_ACTIVIT'.

            REPLACE '&2' IN cv_addparameter WITH lv_bp_id.