Using a Relational Dimension on a Olation Database, member names that has a carraige return value on the end of the memeber name will result to #NAME value upon creating a slice either PO Slice or PowerExcel Slice.
The SQL Script below will locate the position of a carriage return value "CHAR(13)" on a member