In BPC template columns to be generated automatically

[former_member566000]

Hi,

I am currently working on SAP BPC 11.0 Standard and we have a requirement as below,

In a template we need the columns to be generated automatically for the next 10 years based on FY period selection and Below is the screenshot of the existing template,

We need the template structure as below for the next 10 years i.e up to FY2030 as below,

Kindly advise.

Thanks !

Samhita

[former_member186338]

Sorry, but you report has asymmetric column axis:

Pre Adjustment, Adjustment, Post Adjustment - 3 members

INPUT, BPC_CAL - 2 members

EPM will generate 6 columns. not 3. Automated generation of columns can't be used without VBA.

You have 2 options:

1. Use fully static column axis (calculating TIME member with Excel formula)

2. Create a dynamic column axis and use VBA to delete incorrect columns after report refresh.