InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:08:51 GMT20http://www.sqlservercentral.com/Forums/Topic1386119-17-1.aspxthank youMon, 19 Nov 2012 20:47:55 GMTalroyswainhttp://www.sqlservercentral.com/Forums/Topic1386119-17-1.aspx[quote][b]alroyswain (11/18/2012)[/b][hr]Hi,I'm using an MDX statement to fill a listbox with available dates: Current statement is SELECT NON EMPTY [Period].[Period by Financial Year].[Period] on COLUMNSFROM [TESTCUBE] This outputs data and dates, I only require the dates with MEMBER_CAPTION. [/quote]See if this link helps: [url]http://www.databasejournal.com/features/mssql/article.php/3748506/Intrinsic-Member-Properties-The-MEMBERCAPTION-Property.htm[/url][code="sql"]WITHMEMBER [Measures].[Period].[Period by Financial Year].[Period - Caption]AS '[Period].[Period by Financial Year].[Period].MEMBER_CAPTION'SELECT NON EMPTY [Period].[Period by Financial Year].[Period - Caption] on COLUMNSFROM [TESTCUBE] [/code]You'll have to play with that a bit, as my syntax may be off.RobMon, 19 Nov 2012 06:55:21 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1386119-17-1.aspxHi,I'm using an MDX statement to fill a listbox with available dates: Current statement is SELECT NON EMPTY [Period].[Period by Financial Year].[Period] on COLUMNSFROM [TESTCUBE] This outputs data and dates, I only require the dates with MEMBER_CAPTION. Any help is appreciated.Sun, 18 Nov 2012 18:18:21 GMTalroyswain