Hide Posting Periods in Planning Book

[Former Member]

Hi Gurus,

One of our Clients Planning Periods is divided into 26 Period. I would like to Display Periods P1 to P6 and P21 to P26 of every year. Can I hide the rest of the period? (P7 to P20)

After achieving the above I want to add the P1 to P6 and P21 to P26 and display it in a separate key figure for every Year.

Sivabalan.K.S.

[Former Member · Accepted solution]

Hi Sai,

Thanks for the Quick response. Still I have the problem of Macro not getting applied for all the 14 iterations. Given below is the syntax I used. Can you guide how should I correct in order to mask all the 14 periods.

Macros in the Macro Book

COL_VISIBLE(): Column Visibility

DO

input : ( 14 Iterations : P 07.2006; P 20.2006 )

set Attribute X

LAYOUTVARIABLE_SET( 'X' ;

NUM_VALUES_INPUT( 'need_attribute_value' ;

'X=1/0:' )

)

IF

CONDITION ATTRIBUTE[x]

LAYOUTVAR_VALUE( 'X' ) = 1

OR

LAYOUTVAR_VALUE( 'X' ) = 0

EXIT

ENDIF

ENDDO

output : ( 14 Iterations : P 07.2006; P 20.2006 )

Column: P 07.2006 ( Attributes ) =

COL_VISIBLE(

LAYOUTVAR_VALUE( 'X' )

)

Thanks,

Sivabalan.K.S.

[Former Member · Accepted solution]

r u getting any error message or the macro is doing nothing?

[Former Member · Accepted solution]

I am not getting any error message. In fact due to the Macro a pop up ask 14 times (because of 14 iterations) and I fill up either 1 or 0 according to requirement, but afterwords when I open the planning book / data view there is no change.

Sivabalan K S

[Former Member · Accepted solution]

Hi Siva,

This is what I suggested in macro is to just use this syntax to hide a column:

New macro

STEP:col hide

Column (select attributes as chnage scope)

operation/function: COL_VISIBLE( 0 )

This hides the column selected in the Column function you selected.

[Former Member]

Visu,

Tried. But not working. Looks like I need help in Syntax. Kindly help. Also I would appreciate if you could refer any authentic book to practice APO MACRO Commands (With Examples).

Thanks in Advance.

Sivabalan.K.S.

[Former Member]

Please check the syntax. You can get the macro examples from Macro work bench. under macrobook 9AEXAMPLES VIEW

COL_VISIBLE(): Column Visibility

DO

input : ( 1 Iterations : INITIAL ; INITIAL )

set Attribute X

LAYOUTVARIABLE_SET( 'X' ;

NUM_VALUES_INPUT( 'need_attribute_value' ;

'X=1/0:' )

)

IF

CONDITION ATTRIBUTE[x]

LAYOUTVAR_VALUE( 'X' ) = 1

OR

LAYOUTVAR_VALUE( 'X' ) = 0

EXIT

ENDIF

ENDDO

output : ( 1 Iterations : INITIAL ; INITIAL )

Column: 2009/01/14 ( Attributes ) =

COL_VISIBLE(

LAYOUTVAR_VALUE( 'X' )

)

[Former Member]

The Fiscal Year Calender is year dependant and is divided into 26 period.

Sivabalan.K.S.

[Former Member]

Hi Siva,

You can not create your time bucket profile to achieve this but you can use a macro with function COL_VISIBLE() and hide the unwanted columns.

You can use the function SUM to calculate the sum of values from P1 to P7 and P21 to P26.

[Former Member]

Siva,

Specify whether your Fiscal Year Calender is year dependant or NOT. ..Rgds... TRR

Raghu Raman