Enhanced selections to load transactional data from any infoprovider

SAP BusinessObjects Planning and Consolidation 7.5 version for Netweaver successfully leverages the Netweaver infrastructure and we can use data stored in infocubes in the Enterprise Data Warehouse. In this blog we will discuss the functionality that we can use to specify the selections to load a specific data slice from any infoprovider.

We can use a data manager package to load data from any infocube to SAP BusinessObjects Planning and Consolidation version for Netweaver. You can get more details about this at: http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3414700)ID1897954850DB00258195100095085303End?blog=/pub/wlg/14002

The first option to specify selection is the option that is available in the transformation file. Please see the example of the following transformation file:

Note that in the OPTIONS section, we have entered a selection to select data from only two characteristic values C2000 and C1000 of the characteristic ZACCT01. Hence we are selecting only a subset of the source Infoprovider. You can enter selections from multiple characteristics here in the selection and thus load data from a specific data slice in the source from Infoprovider.

In addition to this, we can also have enhanced user interface to specify the selections. The delivered process chain for this enhanced user interface is /CPMB/LOAD_IFOPROV_UI.

When we run the data manager package that is linked with this process chain, we can specify the technical name of the source infocube.

In the user interface that we get in the next screen, we can see the characteristics for the infocube that we selected in the earlier screen and we can specify the individual values as well as the ranges for the selections for each characteristic in the source infocube as you can see in the screenshots below..

What if your source cube has multiple key figures? In that case, one option is to convert the key figure based model into an account based model (https://help.sap.com/saphelp_crm60/helpdata/en/0f/903d41d4cc4c0de10000000a1550b0/content.htm) prior to loading the data. If you don't want to adopt that approach, SAP BusinessObjects Planning and Consolidation 7.5 version for Netweaver also provides us a keyword MVAL. For us to use this keyword, the dimension must be one existed column in the cube. The dimension members in dim_mem must be the base members of the dimension (CALC = ‘N'). The key figure type must be the field name of the source data. Here is an example of using this keyword:

[Users can directly input the dimension members in the dim_mem, or input any existing mapping command in the dim_mem, such as *newcol, *col or *newcol(cash)+*col(1)].

Thus we can see that using a combination of these, we can effectively load a specific data slice easily from any infoprovider.