Best option to forecast line item details

[Former Member]

Here is high level need, wondering what is the best option to forecast line item details.

An option that I have used in the past is to add a dimension called line item detail (Detail 1, Detail 2, etc.) then use the comments functionality to capture the free form text. Any other suggessions?

[former_member186338]

P.S. Another option is to plan item details in Excel files only and to store only total result in BPC!

Then later you can refresh Excel file with total actual and compare total actual against total planned 🙂

[former_member186338]

Anyway, extra dimension is required!

Theoretically you can try to use Master data on the fly - adding members in the input form with required description (using DM package with Master Data on the Fly badi).

https://blogs.sap.com/2015/08/30/create-master-data-on-the-fly-in-sap-businessobjects-planning-and-c...

But even in this case the problem of matching planned id with actual Id is still present!

[Former Member]

Thanks Vadim

Is there any other option that any one have used to capture line item details other than the artificial/dummy dimension and IDs along with comments?

[former_member186338]

Yes, it's possible to use list of some artificial ID's (Detail1, Detail2...) and comments. The issue is how to compare forecast and actual result - no easy way.