Skip to Content
author's profile photo Former Member
Former Member

Currency conversion configuration on snapshot key figures

Hi experts,

I am enabling our value key figures to use currency conversion. I'm almost done, but the only ones that I have left are the snapshot key figures. I am able to update the calculation definitions (BL and Request Level), but the header section that has the "Convert Using" field is grayed out as much of the header section is "locked" on snapshot key figures.

Do you have a suggestion for enabling snapshot key figures for currency conversion?

Thank you,

Marco

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 15, 2015 at 06:19 PM

    Hello,

    Please refer to the consulting note:

    2192688 - Best Practice for creating snapshots for converted Key figures

    Thanks,

    Pramod

    Add a comment
    10|10000 characters needed characters exceeded

    • Hey Marco

      unfortunately you cannot upload data into a snapshot keyfigure, which is one more reason why I am not such a fan of Snapshots. Hence, the way you proposed is a good way to keep your data.

      Or, you create copy operator and with executing copy operator and snapshot one after the other, you can work without files

      Example: You may have 4 allowed snapshots in your snapshots-settings, but only 2 are used so far (so minimum two unused). Than you do as shown in the pic below. Not nice (as the unused snapshots have values now that don't make sense, but an interesting game ...)

      In my current project, we had requirement to change the planning level after GoLive. Easy if you have backups by copy operator, because you just change the planning levels of boths you KF and the backup-KF, because you can upload values into your Backup-KF from file. You just need to somehow manually adjust your file to the new planning level (aggregation or disaggregation).

      Imagine what happens when you need to do that with a KF that makes backups with Snapshot functionality, and what steps you would need than?

      So here is some advise you have not asked for:

      You should really decide depending on your business requirements, if you prefer Snapshots or taking a "snapshot" by means of copy operators.

      So what is your requirement????

      If you want to use Snapshots as a kind of "Clipboard" on-demand on random times, Snapshots are good and easy to configure, nice with the rolling overwrite. And if people could live with loss of their snapshots when you really would need to adjust the planning level (which is a major change), all is fine with that as well.

      But you still have the danger that someone accidentally executes the wrong snapshot for a KF for which he / she has no authorization, for which as of today we don't have yet possibility to prevent by authorization concept: The Planner could execute even if he has no authorization for the KF itself

      If you need snapshots on regular base, for example in a classical S&OP process to backup your final planning, I personally prefer creating a backup KF manually and fill it by copy operator. Or if you need to have the "Backup" in a follow-up calculation, such as BIAS measurement of previous-month-planning for forecast accuracy measurement, backup with copy operator is more save

      • KF1 is the source,
      • source in your copy operator is KF1WOCONV (a calculated KF that just takes KF1WOCONV@BPL = KF1@BPL and has NO conversion),
      • KF1BACKUP would be the target KF in copy operator and keep your backup, than here you configure your currency conversion KF1BACKUP@BPLCURRTO.

      You can have proper authorization by creating different copy-groups, which is not (yet?) possible for snapshots. I hope that authorization on snapshots will come in the near future, than I will change my mind immediately 😊

      So for the moment, because of the authorization restrictions, in my current project we even have the real on-demand-snapshots built by copy operator. As soon as that authorization restriction is changed, my on-demands will be configured as real Snapshots. But for regular backups, I will continue working with copy operators

      Cheers

      Irmi

  • Posted on Jul 15, 2015 at 02:19 PM

    You do not need to currency conversion for Snapshot KF. When you do an SS for an Currency KF it should have an base planning level as CURRTO added to planning level.

    Add a comment
    10|10000 characters needed characters exceeded

    • What is the request level for your KF1 which has a base planning level of PERPRODCUSTCURR ?

      If you request level for KF1 is PERPRODCUSTCURRCURRTO then SS KF1 will be created at PERPRODCUSTCURRCURRTO level which includes CURRTO. The data which SS KF1 will he held at PERPRODCUSTCURRCURRTO level.

      If you can send me screen print of KF1 and SS KF1 I can clarify it to you as what is going wrong within configuration.

      Regards,

      Parag

  • Posted on Jul 15, 2015 at 03:25 PM

    it depends on when you created the snapshot:

    1) You create KF 1, still without conversion setting, on level PERPRODCUSTCURR

    Than you create the snapshot

    -> snapshot is created at same level PERPRODCUSTCURR

    Now you add the conversion --> the snapshot is NOT adjusted, kind of inconsistent now and

    cannot be changed except by deletion and re-creation of the snapshot config

    2) You create KF 2 and do first the conversion setting

    Than you create the snapshot

    -> snapshot is created at level PERPRODCUSTCURRCURRTO automatically!!!!

    And with that, conversion works identically for the KF and it's snapshot, very convenient.

    The above mentioned is valid both for UoM and for currency conversion.

    You cannot adjust anything else than what you figured out yourself, and you have some other downsides in snapshots, which is why I don't use them for everything and especially not as a backups:

    - you don't have authorization concept behind, so either you provide authorization for snapshot or not, but you cannot allow snapshot only for KF1 and KF2 but not KF3

    - you cannot really use it in any follow-up-calculation, because if you need adjustment to the original KF1 (e.g. planning level adjustment) you will need to delete and recreate the snapshot and with that if you use in KF2 the snapshot-KF1 you have a lot of work

    That is why I use more copy operator and just call it processwise "snapshot", which allows both adjustments of the snapshot-KF and usage in follow-up-calculation, as well as more sophisticated backup concept

    Snapshot I mainly use for on-the-fly snapshot that are NOT used anywhere else

    Yours

    Irmi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.