How to use the BUCKET_BDATE

[israel_cano]

Hi member of forum

I trying to do a locking row in a weekly bucket, I take the samples of DP for function BUCKET_BDATE, I wondering if the function could do this. I want to determine the bucket month and compare to the today month to turn on or off the edition capacity. But seems the function doesn't´t return the correct value to compare versus the month (today) value

I'm looking to freeze n, n+1 months that is a regular practice on planning process

Any suggestion I kindly appreciate

[Former Member]

Hi Israel,

If you want to freeze n, n+1 months, so you want to freeze two columns right?

If so, i have the same scenario and i did this:

Período Congelado Operativo

-

-

---

Congela el período : ( 2 Iteraciones : S 30.2007; S 31.2007 )

-

-

---

Línea: Factor Proporcional ( Atributos ) =

-

-

---

COL_INPUT( 0 ) .

Function COL_INPUT is the function that freeze the columns and 0 parameter is to turn off edit mode.

This macro allows you to freeze two periods (week in this example), from actual period.

If you want to freeze only the row and not all the column you can change COL_INPUT(0) for CELL_INPUT(0).

I hope this can help you.

Regards.

Marín.

[israel_cano]

Hi Ulises

Thanks for you response to my two thread I test your recommendation but as you mention in the other thread the rolling process must be automatic

I follow the structure of your macro but the rolling doesn't occur.

My macro looks yesterday as follows

01a. Periodo congelado

Paso 0 : ( 2 Iterations :25.07.2007;26.07.2007 )

Row: Plan de Ventas Mensual ( Attributes ) =

CELL_INPUT( 0 )

Today the macro looks

01a. Periodo congelado

Paso 0 : ( 1 Iterations :26.07.2007;26.07.2007 )

Row: Plan de Ventas Mensual ( Attributes ) =

CELL_INPUT( 0 )

in the window to configure the step horizon I defined as a User-defined with 2 iterations

and automatically the check button to Automatic Column adjustment To-Column is uncheck. i tried to check but doesn't works

May you tell me if you system has the same behavior

[Former Member]

Ok, i have the following parameters in the step horizon:

User-Defined

Iterations: 2

Automatic Column Adjustment From-Column unchecked

Automatic Column Adjustment To-Column unchecked

Processing direction:

In Future.

I hope this can help you.

Regards.

Marí