No Data Displayed (No Data Found) in Excel Planning View SAP IBP

[former_member310060]

Hi all, I need your quick help.

For some reason, we can't display our key figure data on Planning views anymore. Master Data with Planning Object sheet is showing, that the data for the key figure is available. Also the planning objects exists. We got Product_Location, Customer_Product, Customer_Source, Unit of Measure conversion Master Data maintained.

Even if we add new Data and Planning objects manual, together with the Master Data and Key Figure Data they are not displayed on Excel Planning View. In one Planning Area all the old data, which was shown the day before, is also not displayed anymore. In another Planning Area, the Old Data (IBP Best Practice Data) is still shown, but new created Objects are not shown. I tried in a third planning area the same thing, and there it worked.

Anyone got an idea what else I can check? I'm running out of ideas.

best regards

Bastian

[Irmi_Kuntze · Accepted solution]

well, I would need to see the system to tell for sure, you should open a ticket to not loose time, and mention the upgrade in the header as that may speed it up.

However:

What happens to your new kf on WKPRODLOCCUSTBU if you do NOT work with Ulm conversion, do values show up then? And what is BU, is it based on an own MD type or just an attribute of whatever? Does BU provide an own new root to the planning level? Can you provide an overview of the roots and non-roots of both (or better to all four) planning levels? And did you add the new non-roots to WKPRODLOCCUSTBUUOMTO as well? (you have to). And if those new attributes would be valid to WKPRODLOCCUST, you should add them there as well, and to all other levels that contain the same roots of the new attributes. With the new configuration you finally can do mass assignments to planning levels.

Check online document on what’s new in model config: https://help.sap.com/viewer/ed738cdf19b24426a396321195f6c65d/1911/en-US/ddbc1baa02824b479a34bd65bc65...

I think you have at least to solve your last error ‚Input Planning Level Does Not Contain All Root Attributes of Base Planning Level; Calculation Is Not Used‘ as docu states ‚Furthermore, the calculation is not used in any REQUEST level calculation in the calculation graph.‘ I don’t have much experience yet myself with 1911, but this does sound as if it could have impact on the request level...

good luck, and please post the result as this may happen to others as well

Irmi