Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX to fill listbox Expand / Collapse
Author
Message
Posted Sunday, November 18, 2012 6:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 8:47 PM
Points: 2, Visits: 9
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.
Post #1386119
Posted Monday, November 19, 2012 6:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 6:57 AM
Points: 1,163, Visits: 1,188
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
Post #1386369
Posted Monday, November 19, 2012 8:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 8:47 PM
Points: 2, Visits: 9

thank you
Post #1386658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse