mdx脚本中的Uniquename函数

Question

我真的需要你的帮助。

对于SSRS报告，我有以下mdx脚本：

select 
 {[Geographie].[Commune].[AHUY], [Geographie].[Commune].[BRETENIERE]} on columns
,{[Activite].[Branche].&[B], [Activite].[Branche].&[C]} on rows
from [ACSEL2]
where ([Measures].[CATTC], [Perimetre].[Perimetre].&[2], [Temps].[Annee].&[2006])

请注意，我需要在列中包含成员的唯一名称

({[Geographie].[Commune].[AHUY], [Geographie].[Commune].[BRETENIERE]})

请你能帮我写这个mdx脚本吗？

立斗

Answer 1

    WITH 
-- Geography metadata
MEMBER [Measures].[Geographie]
AS StrToValue ( @SelectionGeographie + ".Hierarchy.Currentmember.Uniquename" )
MEMBER [Measures].[Geographie_Label]
AS StrToValue( @SelectionGeographie + ".Hierarchy.CurrentMember.Member_Caption" )

SELECT NON EMPTY {
[Measures].[Geographie],
[Measures].[Geographie_Label],
[Measures].[11 VA]


} ON COLUMNS, 

( STRTOSET ( "{" + @SelectionGeographie + "}") ,


    STRTOSET   ("{" + @SelectionActivite + "}" ))


ON ROWS

 FROM [MyCube]

WHERE STRTOTUPLE ( "(" +@Annee + "," + @Perimetre + ")" )

Answer 2

使用With语句声明一个成员，如下所示：

WITH MEMBER [Measures].[UniqueName] as [Geographie].[Commune].CurrentMember.UniqueName
Select
--Your select here

有关CurrentMember的更多详细信息