cancel
Showing results for 
Search instead for 
Did you mean: 

How to do Delta upload and consolidate in SSM, how to use transformer.ini

Former Member
0 Kudos

Hi,

Can anybody explain me how to do Delta data upload and also how to do delta data consolidation in SAP SSM.

Also how can i create and use transformer.ini file.

Thanks and reagrds

Edited by: Himanshu Bisla on Mar 25, 2009 2:09 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Where from are you planning to upload data?

When you mention a delta upload, does it mean loading new data for a new PERIOD, where no data yet existed, or loading values to measures for periods where data already exists, doing a SUM?

When loading from an external source, you use a READ command, which by default replaces existing values with those that are being loaded. If you add the parameter ADD or SUBTRACT to that IDQL command you are able to change this default behaviour to enable delta loads (with SUM or SUBTRACTION operations).

As for the CONSOLIDATIONS, you can define a date range for the consolidation, or run it for a single period (month, quarter) if needed, or restrict the number of measures you want to consolidate. There is no way to automatically define that only the measures and periods that have new data will be consolidated. This has to be made explicit in the CONSOLIDATE instruction.

Regarding the Transformer.ini, are you planning to use PAS as an ETL tool? Unfortunately, I can only point you to the information that is available on the PAS Help, but that's probably where you found the reference to this function in the first place...

Hope this helps!

Best regards,

Ricardo

Answers (1)

Answers (1)

Bob_McGlynn
Product and Topic Expert
Product and Topic Expert
0 Kudos

Himanshu,

If you are referring to the initial, sample data that is loaded during installation of SSM. In the Installation Guide, you find reference to it at 5.2.5 Loading Bootstrap Data. This procedure utilizes the Transporter. To find the Transporter go to Tools ( http://[localhost or server location]:50000/strategy/tools. The Transporter tool is also how you export and import databases during upgrades or when moving from DEV to PRODUCTION environments.

If you have data that you want to use in SSM, you have to build a model in PAS, following the steps of creating the database within PAS, then link to the data source. You can also query SAP BI by using the BICA tool, see note 1156224 for more information. The third way, if looking to import manual data, you can create a simple model with the HTML Cube Builder, note 1156272, and use Entry and Approval for data.

You do not use a transformer.ini file with SSM. You would create a Link ID to define the connection between between the Application Server and the database system. In the SSM Configuration guide, this is covered in section 3.1 Creating a Link ID

Hope this helps,

Bob