SPM related queries

[Former Member]

HI,

I have few queries with regard to SPM, please share if you have any info:-

1. If we are using flatfile mechanism(data extraction) to load data in SPM, is there any program to FTP the file from ECC to SPM(BI). We have extracted the data in ECC side and file is present in AL11.

2. When we are using direct upload mechanism(data extraction) to load data to SPM, data is succesfully loaded till PSA level. As per my understanding it cannot be loaded to Direct update DSO(Inbound layer) as per the SPM Data Model, is there any standard transformartion to take data from PSA to SPM inbound/Detail layer.

3. If we are going by direct upload mode, how can we handle DSC.

4. If we are going by direct upload mode then is there any standard method/Process chain by which we can load data to SPM data targets after handling the data in DSC.

Thanks in advance.

Regards

Sakshi

[Former Member · Accepted solution]

Hi Sakshi

1. If we are using flatfile mechanism(data extraction) to load data in SPM, is there any program to FTP the file from ECC to SPM(BI). We have extracted the data in ECC side and file is present in AL11.

Ans: If you are within the firewall and the EC and SPM systems are conneted, not sure why you would use flat files approach. But to answer your question, you would ask the network admin to move the flat files, either manually or thru some scheduled script. Donot download files from AL11 as this transaction tends to truncate wide files.

2. When we are using direct upload mechanism(data extraction) to load data to SPM, data is succesfully loaded till PSA level. As per my understanding it cannot be loaded to Direct update DSO(Inbound layer) as per the SPM Data Model, is there any standard transformartion to take data from PSA to SPM inbound/Detail layer.

Ans: There is a data mgmt tool in SPM which moves data from the PSA to the inbound layer. This tool does things like currency/unit conversions, system uniqueness concatenations, export and re import of data for data classification and normalization (like the DSE service) etc... And then data gets moved from inbound to the cubes thru process chains.

3. If we are going by direct upload mode, how can we handle DSC.

Ans. If you take over the data mgmt function, which is your choice, by writing a transformation from PSA to inbound, in that case you would need to figure out how you would import and export for DSE. You could think of using the BW Open Hub...

4. If we are going by direct upload mode then is there any standard method/Process chain by which we can load data to SPM data targets after handling the data in DSC.

Ans. If you are bypassing the data mgmt tool then you would need to figure out the interconnectivity of data with DSE, as mentioned in the previous answer, you would then connect those transformations to the standard proess chains - check the table OPMDM_TYPES for the process chains mapped to the respective objets (both master data and transaction data)

Hope that answers.

Regards

Rajesh