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]
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