How to define BPC architecture?
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:
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.