How to get comma separated list of members for Dimension Attribute

Q:- I want a comma separated list of all members of attribute
How can I get it?



Thanks
Arvind

Ans:-
WITH SET [ABC] AS [CUSTOMER].[CUSTOMER GEOGRAPHY].[COUNTRY].MEMBERS
MEMBER [MEASURES].[TEST] AS GENERATE([ABC], [ABC].CURRENTMEMBER.NAME, ",")
SELECT [MEASURES].[TEST]
ON 0
FROM [ADVENTURE WORKS]

No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts