Skip to Content
author's profile photo Rohit R
0
Rohit R

Key figure copy from one location to another in same PA

Posted on Aug 07, 2016 at 12:49 PM 122 Views

Hi,

We have a requirement to copy values of a particular keyfigure for Location 1 into values of same key figure for Location 2 in the same planning area/book - and both are time series KFs.

Is it possible to do it with macros? Can anyone please share a sample macro or guide how to go about it?

Note: I have gone through old scn discussions but did not find useful specific help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Ada Lv
    Ada Lv
    Posted on Aug 10, 2016 at 02:40 AM
    1

    Hi,

    This cannot be done via macro.
    You can try to do this using /sapapo/rlgcopy.

    Best Regards,
    Ada

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Rohit R
      Aug 24, 2016 at 08:18 AM

      Hi Rohit,

      In the COPY TABLE Panel, Click on MAINTAIN ENTRIES button,

      Create a Copy STEP with attributes which defines the logic

      Here you need to give the required details and save it.

      Then Execute the Realignment after filling all the necessary attributes in the main screen.

      Just my Thoughts

      Regards

      Vinoth

    Comment on This Answer
  • author's profile photo tabraiz khan
    tabraiz khan
    Posted on Aug 08, 2016 at 11:29 AM
    0

    You have two options:

    1) Copy from the backup cube using RTSCUBE report if data exists in the level you expect

    2) Macro: Run this at the required level. You will get the desired data copied.

    Level 1: Select Range

    Level 2: Select Step

    Level 3: Row <Target KeyFigure> =

    Level 4: Row <Source Key Figure>

    Thanks,

    Tabraiz

    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.