I get this error “The server sent an unrecognizable responses. ‘’, hexadecimal value 0x10, is an invalid character error while browsing my cube hierarchy.
In my case I had a linefeed character in one of the hierarchy attributes and in the data source of the cube I change the source table to a named table and replace the column that gave the that error by removing the linefeed character.
SELECT REPLACE(ColumnName , CHAR(10), '') as ColumnName FROM SourceTableName; |
Then I reprocessed the cube and I manage to avoid getting the same error anymore.