alroyswain (11/18/2012)

---

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 COLUMNS
FROM [TESTCUBE]

This outputs data and dates, I only require the dates with MEMBER_CAPTION.

WITH
MEMBER
   [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 COLUMNS
FROM [TESTCUBE]