Thursday, 21 November 2013

Generating Comma Delimited String In MDX

We can get comma Delimited string MDX with the help of Generate Function as shown in below Query.
  
Example 1:

WITH MEMBER MEASURES.CommaDelimitedString
AS
GENERATE(
            [Date].[Calendar Year].[Calendar Year].MEMBERS,
            [Date].[Calendar Year].CURRENTMEMBER.NAME, " , "
        )
SELECT
    {MEASURES.CommaDelimitedString} ON 0
FROM [Adventure Works]

No comments:

Post a Comment