Hiding the selected Colomns in the Interactive demand Planning

[Former Member]

Hi

I have a future period Jan - Dec2009.

I wanna to Hide Periods June, July and August.As we have Option of hiding Coloumns in the Excel Sheet.

Can we achieve this in the APO Demand Planning Functionality.

Regards'

Krishna

[Former Member]

you macro function COL_VISIBLE() to hide the column. you get the syntax in the SAP Examples in the macro workbench

[Former Member]

Hi Sai

Thanks For ur Quick Reply.

Are you Sure that Col_Visable() can be used to Hide the Selected Colomns.

Jan2009 Feb2009 Mar2009 April2009 May2009 June2009 Sep2009 Oct 2009 Nov 2009 Dec2009

100 120 110 100 120 123 140 150 160 170

From the above example i can achieve if i Use Col_visable() to hide July and August in between the Future period.

[Former Member]

Yes. You should be able to. Check this [post|]. You can search in the forum with key word COL_VISIBLE and you can find more...

[Former Member]

Thanks Venkat and Sai for your advice.

[Former Member]

Hi Experts

Hiding the Colomns in Dynamically.

In the Macro we can use Colomn_Visable But it is fixed to Number of periods which we mention in the Macro.

Is there any facilty by which i can achieve this.