on ‎2017 Apr 05 4:17 PM
Dear SAP BPC experts,
We have the following records that should be copied to the data entry layout with the member recognition function (this function ticked in the sheet options):
PC COST ELEMENT ORDER
T1000 61000000 88888888
T1000 70000000 99999999
T2000 80000000 66666666
T3000 90000000 55555555
But if I am copying the above records to the rows where the PC, cost element, orders are defined then the following happens:
1.Certain records are not recognized by the EPM-add-in despite of the fact that the master data is existing in the master data table and these records are not converted into EPMOlapmember EPMfunction
2.All the combinations are generated by the EPM-add-in based on the copied PC's, cost elements and orders and the dynamic data entry layout template is generated.
I am using EPM-add-in SP27 patch 1 and SAP BPC 10.1
Thanks for your help,
Tamas
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
The member recognition is working fine If I am copying the four dimensions at the same to the data entry layout that's why I am closing this issue. Thanks for your comments, Vadim.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If we copy the four columns at the same time to the four dimensions together in this case there will be no combinations generated by the system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your answer, Vadim:
My example was not a good one please see the new ones below:
PC dim Order dim Partner PC dim Cost account dim
T3103 773411 PT3325 702100014
T3103 775411 PT3325 702100014
T3103 733412 PT3341 702100015
T3103 733412 PT3342 702100015
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First I suspect that you have same member ID's in different dimensions - absolutely bad idea! Member recognition will not work in this case. Use prefix!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My questions:
1. Is it common that the data entry layout does not recognise the copied master data to the sheet with the function member recognition?
2. Is there a way that I can define a static report based on the copied members?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 17 | |
| 8 | |
| 7 | |
| 6 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.