Hi
For my SNP planning book, I have a requiredment to add multiple vector areas in a vector variable using vec_layoutvariable_app() function. I belive this macro function appends area key figures into vector like a two dimentional data. For instance I am going to use:
Action: Attach values to my_vector variable for a group of Products in the planning table
Step 1: Append group totals
VEC_LAYOUTVARIABLE_APP( 'MY_VECTOR' ;
Area: [ $Sales Order ( INITIAL ) ; $Sales Order ( M 12/2014 ) ]
)
This will generate a vector variable MY_VECTOR which have values like:
| M01/12 | M02/12 | M03/12 | M04/12 | M05/12 | M06/12 |
|---|
| 1200 | 1300 | 5000 | 2000 | 1200 | 2000 |
| 1500 | 2000 | 3000 | 1000 | 1000 | 1500 |
| 2000 | 1500 | 2500 | 1000 | 2000 | 2200 |
But I do not know how to read this and assing to a Area: Key figure. If I use layoutvariable as shown below:
Area: Total Demand (Forecast/Sales Order) ( INITIAL ) =
VEC_LAYOUTVARIABLE( 'MY_VECTOR' )
The above laoutvariable reads only the first row value.
I want to all three rows added and assign to Total Demand Key figure like:
| M01/12 | M02/12 | M03/12 | M04/12 | M05/12 | M06/12 |
|---|
| 4700 | 4800 | 10500 | 5000 | 4200 | 5700 |
Any idea on this? Appreciate your time and thanks in advance.
