Skip to Content
avatar image
-1
Former Member

'member XXX is invalid or is a calculated member' error while validating transformation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Nov 28, 2016 at 07:29 PM

    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

    ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2016 at 08:04 PM

    Thanks for the response Vadmin. My bad for not providing the detailed information. Following are the necessary documents.

    Transformation file & Rejected list after validation.

    Sample flat file

    Dimension Screen shot

    Hope these documents will help in looking into the issue.

    Best,
    Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 08:17 PM

    But can you show 20002534 member on the Plan_Number dimension screenshot?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 08:21 PM

    And what do you mean by:

    If in the transformation file you have DELIMITER=TAB


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2016 at 09:50 PM

    Dimension processing is done. I was unable to take a snap shot with hierarchy view for the base memebers.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 09:31 PM

    "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...)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2016 at 10:58 AM

    Please check the flat file consists of any space at the end of dimension member ID's..?

    Thanks

    SRG

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2018 at 12:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded