Why a SAP BW dimension shows only Selektion X - placeholder descriptions instead of the correct dimension values.
SAP BusinessObjects 3.1, Crystal Reports 2008, BusinessObjects Integration Kit for SAP, BEX Query
It took me days to solve the following problem, so I want to share a solution if someone else has the same issue.
In my case the problem occurred, when I wanted to access with Crystal Reports 2008 via the BusinessObjects Integration Kit for SAP a BEX Query using a SAP BW MDX Query-Connection. When I used the query objects in my report, instead of the actual dimension member descriptions, I just got the placeholder-descriptions “Selektion 1”, “Selektion 2”, etc. When I opened the same query in SAP, it showed the correct values.
When I looked at the connection string Crystal Reports was using, I saw the parameter “LANG: DE” therein, which means, that it tried to query a german version of the dimension values. As there was only an english version defined, it returned those “Selektion X” descriptions.
I could not find out how to change that language-parameter directly. But finally I found the configuration file "DefaultMapping.properties“ in the folder “PVLMapping” of the Integration Kit for SAP. There you can define a mapping between system language codes to SAP language codes. I mapped the german language codes to english SAP language codes (de=EN, etc.), which changed the LANG-parameter in the connection string to “LANG:EN” and made the correct dimension decscriptions appear.
