A BW system is configured with all the required settings. This includes processes to:
Set up the BW system
Configure communication between the BW system and SAP Solution Manager
Activate the BI Content
Edit Web templates
Specify data extraction from the SAP Solution Manager system
The SAP Business Information Warehouse (BW) system of SAP Solution Manager provides a new InfoCube. It gives you the opportunity to run periodical reports on CCLM objects from the library. The InfoCube retrieves the CCLM data using the CCLM extractor on a specified point in time and saves them. Apart from the default CCLM object attributes you can map free fields of the InfoCube with your additionally defined CCLM object attributes for BW reporting.
Prodeed as follows:
In the BW Reporting
screen area click Attributes Mapping to CCLM InfoCube
. The system opens a new window to add new attributes or map attributes to the CCLM InfoCube.
Click Edit
.
In the Object Attributes
screen area you can select the desired custom object attribute from the input help next to the numbered free fields representing the InfoObjects. The system provides 20 free fields for mapping.
In the System Attributes
screen area you can map system attributes defined in the object library to the corresponding InfoObject of the InfoCube.
Note
Data are not filled retrospectively, they are always used for the next reporting run.
Click Save
.
Note
InfoCubes are filled continously.
You start the analysis as follows:
Click Load Data From BW
to define the report and to start the analysis.
The system opens a new window to select the variables for BW reporting.
Select the System ID
.
Select the Custom Object Type Variables
. You can also select multiple types by using the input help.
Select the Creation From
and Creation To
Months.
Click Execute
.
The system opens a new window showing all objects created according to your selection.
Navigation Block
The table displays all available fields of the report including the mapped fields. You distinguish between fields that are selected for the report and fields that are not included.
You can change the report by using the options provided in the columns beside:
Drilldown in the rows
To display the available fields as a row in the CCLM BW Reporting
table, choose Drilldown in the Rows
.
To remove the option Object Creation Month
, choose Remove Drilldown
. The report is changed instantly.
Drilldown in the columns
To display the available fields as a column in the CCLM BW Reporting
table, choose Drilldown in the columns
.
Select Filter Value
To specify your results , choose Select Filter Value
.
For example, if you want to narrow down or add more of the object types, use this filter option and select or deselect the desired object types. Then choose Transfer
to confirm the selection.
If you want to exclude objects which have a deletion flag, you can use the filter and select the #
checkbox. To undo your selection, choose the dustbin.
CCLM BW Reporting
The table displays all objects created with Object Creation Month
, System ID
, Object Type
and the total number of objects per object type.
Note
The BW reporting result is a historical view on custom code data because data are retrieved periodically, for example weekly. So if you have selected several months, the entries exist multiple times.
To get the result exactly to the day, you can use the Snapshot Day
field in the Navigation Block
table. Choose the filter, select a snapshot list from the list and choose Transfer
. The snapshot day uses the data of the last report run and updates the CCLM BW Reporting
table .
For more information, see the SAP Solution Manager Wiki on SAP Community Network at http://wiki.scn.sap.com/wiki/x/zYE2FQ. Then under choose Custom Code Lifecycle Management (CCLM)
and choose chapter BW Reporting
.