SPM Customization Series: Loading data in Customer Defined Dimension
The Spend Performance Management (SPM) data model already covers all the necessary dimensions for the Procurement Analytics scenarios. In addition to the Procurement specific dimensions there is a provision for 15 additional custom dimensions shared across all the SPM analytical objects (like Invoice, Contracts etc…).
But even with these built in provisions there can be a need for having additional customer defined dimensions. So how would you go about adding such a dimension and loading data in SPM?
Let’s take a ‘make believe’ example. Let’s say that we want to add a Spend Quality Dimension. Let’s call this characteristic infoobject as ZXASPENDQ. And in this example, the characteristic does not have any attributes (although it could just as easily have them) but is enabled for texts.
Now let’s create this infoobject. Make sure to turn on the texts flag and leave the Master Data flag as checked. And then activate the infoobject (make sure to attach it to a transport if needs to be delivered thru the system landscape).
Next step is to create a test file (csv format with semicolon as separator and double quotes as escape character). SPM also supports BW datasources to load data on top of the flat file based mechanism, for our example the flat file would suffice.
To load this file in SPM, first this new upload type must be registered in the table OPMDM_TYPES. Go ahead and do so, use the following values. The target type is “IOBJ” for infoobject (“DSO” if it’s a data store for loading transaction data). The target name is the infoobject tech name, the upload group is “MDAT” for master data. Feel free to ignore the rest of the fields except for the last one. Just set it to “XSA”.
Additional details can be found at Upload Types in SPM and Source System Independence considerations during data load in SPM.
Save the new entry.Additionally, in the text table, OPMDM_TYPEST, make the text entry for internationalized view.
And now you are set to load data for this customer defined dimension/attribute and you can proceed to use the SPM Data Mgmt. Tool for loading our data file into this infoobject. And that’s it!
(For more details on how to use the data mgmt. tool, refer to the following documentation in this location (link). Go to the 2.1 documentation and open up the Application Help >> Data Management.)