on 06-12-2013 2:55 PM
Hi experts,
I have a following question:
For demand planning process we are using 2 cubes: 1. History Data 2. Prices Data
First cube has following chars: Material, Plant, Customer, Warehouse.
Second cube has only Material and Plant as chars.
MPOS in DP includes full set of chars from first cube. CVC's are generated also based on first cube.
All Data from History Cube is visible in Demand Planning and absolutely correct.
Problem is that data from Prices cube is not available.
So for instance for first cube I have following cvc: mat1, 2000, cust1, warehouse1 - and all data is ok.
For second cube I have a combination like a subset of first one - mat1, 2000 and those data is not visible in DP even when I select exact combination in Interactive planning (mat1, 2000)
What is the problem? Should we have an equal set of chars in booth cubes? Or..??
Thanks a lot in advance for your suggestions!
Thanks, Andrey.
Hi experts,
Thanks a lot for set of useful recommendations.
Problem is resolved now.
Problem was in disaggregation type N for Prices KF's.
So now this problem is resolved.
Thanks once again for your input!
Thanks, Andrey.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From your message I can vaguely assume that you are creating CVCs from both cubes before running TSCUBE. If so, then you should check the TSCUBE variant whether you have mapped the key figures and characteristics properly in the variant.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Andray,
Please proceed as follows:
Thanks & regards,
Chan
Hi,
From what source you are populating the Price infocube. I am assuming you are using external data source (e.g. csv file/excel file) to load data into cube. Second step might be loading from infocube to DP planning area.
In both the steps verify you data fields are mapped correctly in the transformation rule. You will have history data planning area/infocube to compare with.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.