Skip to Content
author's profile photo Peter Casper
0
Peter Casper

IBP ChartVBA_Embedded.xlsm multiple members in column axis hidden by chart

Posted on Jul 01, 2020 at 08:06 AM 76 Views

Dear community,

we came across an issue that only the last member of the column axis will be displayed in the planning view in case someone assigns multiple members.

Example (Layout > column axis members)

  1. Period
  2. Key figure

In this case only the key figure will be shown mulptiple times on the column axis dependent on the number of selected periods.

We recognized that the other member gets hidden behind the embedded chart for SAP template ChartVBA_Embedded.xlsm.

This looks like a conceptual design gap for me. Does anyone have the same issue and potentially a workaround for that problem?

Best regards, Peter

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

View more ...

Related questions

1 Answer

  • Best Answer
    author's profile photo Ivan Andreis
    Ivan Andreis
    Posted on Jul 29, 2020 at 08:45 PM
    0

    Hi Peter,

    I am wondering if you already found a solution for this behavior? If yes, please feel free to share it here.

    If not, I am not totally sure that I understood the full thing about it. You could give it a try with the up to date .XLSM sample file which was last updated on July 13th:

    https://github.com/SAP-samples/integrated-business-planning-excel-add-in-templates/tree/master/VBA_Template_2005_andOnwards

    Luckily, this could have been addressed on the recent version.

    If not, would you mind sharing some screenshots about the behavior as well for better understanding?

    Best,

    Ivan

    Add a comment
    10|10000 characters needed characters exceeded

    • Peter Casper
      Jul 30, 2020 at 12:07 PM

      Hi Ivan,

      so far we solved it by using a non chart based template which actually works properly in this regards. We did not try to use one of the latest templates due to the fact that we are not in shape to upgrade all our IBP add-ons to version 2005 at the moment.

      Please find below 2 screenshots to illustrate the described behaviour in case of using the chart based VBA template with KF at column level.

      Layout: Time horizon and Key figure in column axis
      Chart: visible


      Chart: hidden and row 4 manually enlarged

      best regards, Peter

      horizontal-kf-setup-hidden-row.jpg (115.8 kB)
      horizontal-kf-setup-unhidden-row.jpg (93.9 kB)

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.