Question Re: chart is not showing data correctly in Supply Chain Management Q&A

chart is not showing data correctly

former_member594111 — Wed, 24 Oct 2018 09:29:28 GMT

Hi all

The IBP chart is not showing data as per key figure value i already attached chat in excel add-in still its not showing correct data

Re: chart is not showing data correctly

lingaiahvanam — Wed, 24 Oct 2018 09:59:21 GMT

Hi Abhijeet,

I had this issue many times.

I would suggest clearing the clear metadata cache and log in to IBP and make changes to the key figures and check the chart values in excel and analytics app.

While logging to IBP excel add-on select the connection name and click on Edit and clear metadata cache.

Check the data at base planning level first and SAP delivered chart template.

Best Regards,

Lingaiah

Re: chart is not showing data correctly

gurucharanscm — Wed, 24 Oct 2018 10:52:12 GMT

Go into the edit mode of your IBP connection, you will find the option 😉

Thanks,

Re: chart is not showing data correctly

former_member594111 — Wed, 24 Oct 2018 11:03:58 GMT

i cleared the metadata cache still its not working

Re: chart is not showing data correctly

gurucharanscm — Wed, 24 Oct 2018 11:27:06 GMT

Hi abhijeet_shirke - In your snapshot, I see the KF data for 2018 while the chart is displaying for 2016/2017. Hope you are looking at the data rightly 😉

Thanks,

Re: chart is not showing data correctly

former_member594111 — Wed, 24 Oct 2018 12:11:44 GMT

i looking data of 2018 i don't know why chart showing data for 2016/17

Re: chart is not showing data correctly

gurucharanscm — Wed, 24 Oct 2018 12:16:23 GMT

Hi abhijeet_shirke,

So, is the data for 2018 not matching with that of chart still? If yes, can you please remove the selection of your chart and re-maintain the KFs you view in your chart, mostly - it works.

Thanks,

Re: chart is not showing data correctly

lingaiahvanam — Wed, 24 Oct 2018 16:54:37 GMT

Hi Abhijeet,

SAP delivered chart template restricted chart horizon to improve performance, check the chart horizon correctly if required extend the horizon for your testing purpose and compare the values.

If the above solution is not working, can you create the analytics app chart with the same selection criteria and check whether values updating properly or not.

IBP analytics app chart working fine then need to check the excel planning template.

IBP analytics app chart showing wrong values then raise incident to SAP support for further analysis.

Best Regards,

Lingaiah

Re: chart is not showing data correctly

ankpatel — Wed, 24 Oct 2018 18:46:04 GMT

Hi Abhijeet,

Check what is the horizon you have in the SAP IBP Chart Feeder in your template. Normally you face this kind of issue because of chart horizon. You can find Chart Feeder by un-hiding the sheet in the Excel Template.

Regards

Ankur

Re: chart is not showing data correctly

former_member594111 — Thu, 25 Oct 2018 09:57:24 GMT

its working in analytical app but in excel chart showing same value for all product

Re: chart is not showing data correctly

Irmi_Kuntze — Thu, 25 Oct 2018 10:28:24 GMT

Are you working with the old or the new VBA-enabled templates?

With the shown screenshot, it could be both. But as the chart shows a different year, I expect it to the old charts where you use the chart feeder

And when you are still using the old ones, there can be 100 of reasons why it does not work, most likely related to settings in chart feeder and you would need to post full screen shots and the chart feeder

With the new ones, I never had issues in the amount of data displayed, so I can only recommend to change to them

Irmi