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

creating macro for key figure "period of the preceding year"

Hello together,

i have a question regarding the use and options of macros and would be very grateful for your help/feedback.

Let`s take an example for my problem:


As u can see: i have 2 years: 2012 (past) and 2013 (future).

Key Figure 1 (Sales Volume) is generated form former Sales Demand (Data is available from historical data).
Key Figure 2 (Forecast): Planned by Demand Planner (automatically generated)
Key Figure 3 (Period of the preceding year):


- Red arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 02 2012)
- Green arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 01 2012) AND DIVIDE it into Weeks instead of month.

My question is:
- Is it possible to create a macro which is getting the data from an existing datafield and generate it automatically in the right time-period-unit? (month is always the basis for the past-data)


Tanks in advance,

Holger

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2012 at 04:39 PM

    maybe my question is a little bit confusing. :-?

    to make it short: is it basically possible to add a Key Figure including data from a preceding time period (month) to compare it with actual data (forecast) (e.g. sales-data)?!

    would be very thankfull for any feedback. I am not sure if i could make out my problem?!

    Thank You!!

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Holger,

      You can use either VEC_LAYOUTVARIABLE or TIMESHIFT_FORWARDS methods to meet your requirement. Please check the following procedure with VEC_LAYOUTVARIABLE methods.

      1. Create another data view with a TB profile consisting of only weeks.

      2. Create a macro to copy the values

      Step 1. Collect past data (User defined time period - 1 iteration - week1, 2012)

      Action box Element

      VEC_LAYOUTVARIABLE_SET( 'var1' ;

      AREA: [$SALES ($week1, 2012) ; $SALES(week52, 2012) ] )

      Step 2. Copy the collected data to future periods ( 1 iteration - week1, 2013)

      AREA: [$PAST_SALES ($week1, 2013) ; $PAST_SALES(week52, 2013) ] ) =

      VEC_LAYOUTVARIABLE( 'var1' )

      Thanks,
      Rajesh

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.