Snapshot KF

[OliverA41]

Hello,

I create a snapshot. the Input KF called STATISTICALFORECASTQTY2 and has maintainerd the UOM

After this I create the snapshot with the konfiguration APP and this was also working

Now I want crete a forcast error calculation and If I start to maintained I get the error message that the snapshot has not a conversion factor. And this a fact. The Statistical Snapshot kf has not a conversion factor. But the input kf. But my question is, how I can maintain the snap shot KF. This KF was automatic create by the system and I cannot maintained it.

The error message, which appear If I would maintained the snapshot kf is

The snapshot key figure is inconsistent. To correct the inconsistency, edit the original key figure. But the original kf has a UOM

[lingaiahvanam · Accepted solution]

Hi,

Create an intermediate or copy key figure which is a copy of the input key figure used in the snapshot operator and ensure no direct conversion calculation is configured. So, we need a source key figure without any conversions as input to the snapshot operator. Create snapshots key figures for this intermediate or copy key figure and define operator accordingly.

This helps in improving snapshot job performance and ensuring correct values are copied / displayed in the planning view.

An Example: Key figure FINALCONSENSUSDEMANDQTY have UOMCONVERSIONFACTOR and we would like to create snapshot key figures.

Step 1: Create a Calculated intermediate or copy key figure FINALCONSENSUSDEMANDQTYCPY with calculations as shown below:

Input key figure FINALCONSENSUSDEMANDQTY@PERPRODLOCCUST is marked Stored Value at PERPRODLOCCUST level, as FINALCONSENSUSDEMANDQTY is a Stored key figure.

Covert Using needs to be empty.

Step 2: Create snapshot key figures for the FINALCONSENSUSDEMANDQTYCPY using Manage Snapshot Configurations app.

Step 3: Change the calculations of the created snapshot key figures as shown below:

Input key figure FINALCONSENSUSDEMANDQTYCPY_SNP_1@PERPRODLOCCUST is marked Stored Value at the REQUEST level.

Input key figure UOMCONVERSIONFACTOR@PERPRODUOM is marked Stored Value at the PERPRODLOCCUSTUOMTO level.

Input key figure FINALCONSENSUSDEMANDQTYCPY@PERPRODLOCCUST is not a Stored Value at the PERPRODLOCCUSTUOMTO level, as FINALCONSENSUSDEMANDQTYCPY is a Calculated key figure.

The second calculation defined at PERPRODLOCCUSTUOMTO in the snapshot key figure FINALCONSENSUSDEMANDQTYCPY_SNP_1 will ensure that summation of conversion factor is not performed, values are seen with respect to the UoM-To or Curr-To selected in the planning view.

Make similar changes to other snapshot key figures FINALCONSENSUSDEMANDQTYCPY_SNP_2, FINALCONSENSUSDEMANDQTYCPY_SNP_3, likewise.

Step 4: Activate the planning area.

Step 5: Run snapshot operator to validate the result.

Refer to SAP note - https://launchpad.support.sap.com/#/notes/2789490

Best Regards,

Lingaiah

[former_member654033]

Hi Oliver,

Snapshot should always be created on KF having no UOM/CURR conversion, Once we create the snapshot key figure and if require we can enable UOM/CURR conversion configuration directly in snapshot key figures to display them in alternate UOM. This also helps to minimize number of combination created during snapshot creation as you create snapshot only in Base UOM and later can display them in any other UOM just by UOM conversion calculation configuration.

Thanks

Girish