Skip to Content

In BPC template columns to be generated automatically

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 05, 2020 at 07:27 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.