Post reply

MDX to fill listbox

  • November 18, 2012 at 6:18 pm

    #150126

    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.

    Any help is appreciated.

  • November 19, 2012 at 6:55 am

    #1560344

    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.

    See if this link helps: http://www.databasejournal.com/features/mssql/article.php/3748506/Intrinsic-Member-Properties-The-MEMBERCAPTION-Property.htm

    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]

    You'll have to play with that a bit, as my syntax may be off.

    Rob

  • November 19, 2012 at 8:47 pm

    #1560586

    thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply