Member Description from external source database for Tabular source system
- Daniel Nikolovski
- *Willem Van Den Brink (Deactivated)
For the Tabular source system we can define an external database from where Member Descriptions can be loaded.
This database can be defined in the field ODBC Connection String. Clicking the Help button will show examples on how to set up that connection string.
Once the database is set, we can set up individual queries per dimension with which we can load Member Descriptions for each dimension in the Dimension Mapping submenu. In the Member description SQL statement we define queries for retrieving Member Description.
What is important is 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 the keyword AS and set name MemberKey and MemberDescription as it is visible in the example below
If the ODBC connection string is not set for Tabular source system default Member Description will be used.
If the ODBC connection string is set but for a specific dimension the “Member description SQL statement” is not set, then the default Member Description will be used.