Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to define BPC architecture?

Hi All,

Iu2019m a BI and BPS consultant and Iu2019m doing a prototype for evaluating BPC for Sales Planning and I need some help.

Process flow as:

a. Extract sales from COPA (amount and quantities);

b. Copy Actual to Budget version;

c. Create new customers;

d. Delete old customers;

e. Calculate the seasonality of sales & and adjust budget;

f. Load & adjust prices

g. Load & adjust sales costs

h. Calculate Net Revenue

i. Calculate costs

My file format is as given below:

Account|Category|Time|RptCurrency|Entity|Customer|Product|Amount|Quantity

Questions:

1- There is a specific KF to load quantity or I should use another account? If so how do I load the unit measures?

2- I tried to load my file in u201CEuru201D but I received an error. The upload only finished OK when I changed the currency to u201CLCu201D. There is any trick?

3- In customer dimension, I add the sales org. attribute but it didnu2019t work out because a customer can have more than one sales org. There is any way to define a compound key for a dimension?

4- Where can I find relevant documentation about BPC?

Thanks for reading my post.

Regards, Fred

Not what you were looking for? View more on this topic or Ask a question