on 11-28-2016 6:46 PM
Hi Guys,
I am trying to do load transaction data using flat file. During the process I have created and trying to validate the transformation file. I am facing an issue for one dimension, 'memeber XXX is invalid or is a calculated member'. But the member is maintained in master data.tried multiple ways like creating a DUMMY member etc to process. Still no luck please look into this and do the needful.
Thanks in advance for the help.
Best,
Pavan
Did you figure this out? I am having exactly the same issue in BPC11. Random records are getting same errors but others are getting processed with same dimension members.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check the flat file consists of any space at the end of dimension member ID's..?
Thanks
SRG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dimension processing is done. I was unable to take a snap shot with hierarchy view for the base memebers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Yes, they are both the plan numbers are rolling upto ALL_PLAN" - I am not asking about 20005662 and 20002534 rolling to some parent, I am asking if some other members are rolling to 20005662 and 20002534!
What about dimension processing (third time asking...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But can you show 20002534 member on the Plan_Number dimension screenshot?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, do you really think that it's possible to help you without detailed info:
1. Flat file sample
2. Transformation file
3. Conversion files if any
4. Validation error screenshot
5. Dimension administration screenshot
...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
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.