Transformation validation Error:dimension member is an invalid member id in Dimension

[karan_kothari2]

Hi Everyone,

I am trying to update my CostCenter dimension through DMP. For the same I am using the following simple transformation mapping:

Conversion:

After validating the transformation, I am getting the following error:

Please guide me on the same.

[Former Member · Accepted solution]

Hi Karan,

Probably there is an Blank ID in cost center which while loading is giving  this error...Please check....

and keep DELIMITER = TAB.

Regards,

JP

[karan_kothari2 · Accepted solution]

Hi JP,

Thank you for the prompt revert.

I am loading the above dimension from BW info provider.Further please let me know that how could I skip the blank ID into transformation/conversion.

Thanks,

Karan

[Former Member · Accepted solution]

Hi Karan....you can skip the blank id by using the if condition and mapping the blank to any dummy id like cc_none.

Regards,

JP

[karan_kothari2 · Accepted solution]

It's successfully working now.

Thank you so much JP !!

[Former Member]

I think that in the source you have double id. Then we have the error in admin module. You need to check which elements are indeed at the output of the transformation and conversion.

[karan_kothari2]

Hi Tomasz,

I have checked that there is no duplication in source info provider for member IDs. I have filtered on Controlling Area for required members and that all are unique.

Thanks,

Karan

[former_member186338]

Please, provide full info!

Including conversion file!

[karan_kothari2]

Hi Vadim,

I have mentioned transformation, conversion and validation error details into original post. Please refer the same and let me know in case any more details required.

Thanks,

Karan

[former_member186338]

Ups, I can see it!

But you have to exclude or replace all illegal characters from ID... Using js

[karan_kothari2]

Thanks vadim!!