Skip to Content
0
Aug 04, 2009 at 02:10 PM

BI factsheet Integration (CRM 2007) - parameters issue req BI 7.x reports?

36 Views

Has anyone got any ideas on this?

I have integrated a number of BW reports into our web factsheet accessed via the sales web client. We are trying to enable the factsheet to pull up data specific to the selected business partner. The bw factsheet section however is not passing back the specific customers data - the general filter is there requiring the user ti input the BP ID as well as a couple of other required fields.

I came across the following documentation which states that this functionality works for BI 7.x reports. We are linking to BI 3.5 reports - is this feature not supported in this version of BI?

Specify Additional Parameters

You can enter the values you want to use for filtering purposes as additional parameters for BI 7.x reports.

To do this, you map InfoObjects contained within the BI report to values derived from the application. They are written in the form

<InfoObject Name_1>=<CRM Name_1>;<InfoObject Name_2>=<CRM Name_2>

Example

0CRM_SOLDTO=BP_ID

Note

The entries must be separated by a semicolon (u201C;u201D).

The following mappings are available:

BI Report InfoObject CRM Object

0CRM_SOLDTO BP_ID

0CRMSA_OG_R SAL_ORG

0DISTR_CHAN DISTR_CHAN

0DIVISION DIVISION

Note

In the account fact sheet, you can see which filters are set in the information provided about the report (dynamic filters).

Thanks in advance

Eddie

Edited by: Eddie O'Leary on Oct 15, 2009 3:43 PM