Actual/Plan Data

[Former Member]

Hi,

I heard the words Actual/Plan many times in BW. Could you plz tell what exactly they are and how they are useful in BW.

Thnx.

[Former Member · Accepted solution]

Hi Reddy,

This is related to CRM area - Sales Target Planning.

If i am right please refer the online SAP help.

http://help.sap.com/saphelp_sem40bw/helpdata/en/81/3b90467b396e40b2d904aa25a712bd/content.htm

Thanks,

Srinivas.

[Former Member]

hi

plan and actual data is common in all functionals. for example in production planning there will be a plan production start date and actual production start date. these two dates will be compared by having these two datas in two cubes separately . there will be a multi provider/multi area to compare these datas.

In BW:

- 1 basic cube for actual data (NOT transactional), where u do uploads as usual

- 1 transactional cube for plan data, with no update rule ...

- 1 multiprovider based on this 2 cubes, to do reports with actual & plan data

In BPS :

- 1 planning area based on your 'actual cube' (it is working just for the area)

- 1 planning area based on your 'plan cube'

- 1 multi-area based on these 2 planning areas

[Former Member]

Hi,

1 transactional cube for plan data, with no update rule ...??? Why do we need a transactional cube for plan data and why we dont need update rule for Plan data.

[Former Member]

Hi Reddy,

We can make use of SEM-BPS. Have a look at the overview of the SEM-BPS.

http://www.accessarkansas.org/dfa/budget/fy04/bps_annual_overview_presentation.pdf

Thanks,

Srinivas.

[Former Member]

SDN Reddy

Your question is more generic. Actuals and Plan we use in various scenerios for example if we want to compare actual budget and plan budget for particular year in BW we can handle this in various ways.One way of handling is create different cubes one for actuals and other for budgets and create multiprovider with both these cubes for comparision of reports.

Hope this helps

Thanks

Sat

[Former Member]

Hi,

So actual Data is the real data which we get frmo the various transactions done in the business right? SO how do we get Plan Data? On what basis plan data i prepared?

Thnx.

[Former Member]

Actual is real cost and revenues; plan is the Budget.

I don't know what to say more.

Hope this help.

Regards