![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_4.png\")
<\/a><\/p>\nIn the field SQL you should set the query which returns two fields: a key and a name. This query should return all possible parameter values. In most cases you will build a query which returns a key and a name of any level of the dimension or attribute. In our case to get the list of all countries we\u2019ll need the following query:<\/p>\n <\/p>\n select distinct EnglishCountryRegionName, EnglishCountryRegionName<\/p>\n from AdventureWorksDW2008.dbo.DimGeography<\/p>\n <\/p>\n Pay attention to the fact that if you are using \u201cAdventure Works 2005\u201d database instead of 2008 version, then in your query you\u2019ll have to change the database name from \u201cAdventureWorksDW2008\u201d to \u201cAdventureWorksDW\u201d.<\/p>\n Press the \u201cExecute\u201d button to see the results of the query execution.<\/p>\n In case you\u2019ll get the message, saying that the SQL Server user, under which the application server establishes connection to the repository DB, has no access to the database from which the data is selected (\u201cAdventureWorksDW\u201d) \u2013 give the appropriate (\u201cdata reader\u201d) access to the user on the \u201cAdventureWorksDW\u201d database. After that press the \u201cExecute\u201d button once again.<\/p>\n After executing the query successfully you will get the window with a result:<\/p>\n<\/a><\/p>\n