Transaction SICF – Internet Connection Framework
On the selection screen, enter the service name as; DSNODATA as shown below:
On the resulting screen, expand the list of hosts / services to display the service named 060_SRV as shown below;
Next, right click on the service 060_SRV and then choose the option Activate Service, when prompted choose as shown below;
Transaction /DSN/060Z – SSPF Configuration
In this configuration step, define cost type and system which is to be used, enter the following;
- Cost Type
- Parent Cost Type
- System Code
- System Description
- Stem Flag
In this configuration step, define the planning versions and the cost type (Internal or external) for which each version is applicable.
The following section demonstrates how to set up a connection to the Dassian Data feed for additional reporting requirements.
Ensure that PowerPivot is installed and activated on the computer, this is evident by the presence of the Tab labelled PowerPivot as shown below;
Click on the PowerPivot Tab and click on the PowerPivot Window icon, as shown below;
Click on the Data Feed icon on the Home Tab;
The Table Import wizard will appear. Click on the Advanced button;
In the Advanced table change the Security from SSPI to Basic as below;
Type the SAP username and password for the SAP system being used, then click OK.
Type in your URL feed for the OData service, e.g. http://<yourservername>/dsnodata/DSN/060_SRV/
Click Test Connection
The following box should appear. Click OK
Click Next to proceed with the connection.
Only select the first table for this test and then click finish
The PowerPivot will now import the data into the window. The popup screen below will appear when complete.
This is the expected outcome of the link. This Data is what the SSPF reports will be populated from.