After maintaining the cube, for the rejected rows, we are seeing the error message "A column value is not a valid member of its target dimension." but the rejected record column shows junk characters. We want to be able to read this column so that we know the row which is causing the error. Could you please help in resolving this issue? Thanks.
From rejected_record column in cube_rejected_records table -
I saw something like this in release 220.127.116.11
Bug 9065415 - REJECTED_RECORD COLUMN LOGS UNEXPECTED CHARACTERS WHEN DB CHAR SET IS AL32UTF8
Which character set and database version are you using? The bug was marked as fixed for the 18.104.22.168 release, so if you are on that or later, then it is probably a different issue.