For Tabular source system we can define external database from where Member Descriptions can be loaded.
Database can be defined in the field ODBC Connection String. Clicking Help button will show example how to set up connection string.
Once database is set in Dimension Mapping we can set up individual queries per dimension with which we can load Member Descriptions for each dimension. In the Member description SQL statement we define queries for retrieving Member Description.
What is important that the query should return two columns MemberKey and MemberDescription. If the defined columns where the values are contained for member key and member description have different names they should be selected using key word AS and set name MemberKey and MemberDescription as it is visible in the example bellow
If ODBC connection string is not set for Tabular source system default Member Description will be used.
Also if ODBC connection string is set but for specific dimension “Member description SQL statement” is not set default Member Description will be used.