MDX如何动态命名成员

Question

在下面的MDX中，如果参数@{AnneeSelected}等于"2015“，我想将我的计算成员命名为”Evolation2012-2015“。

with CALCULATED MEMBER [Periode].[Periode].[Evolution] AS percChange(@{AnneeSelected}, @{AnneeSelected}.lag(2) ) 
SET [Years with data] AS  @{AnneeSelected}.lag(2):@{AnneeSelected} 
select {[Years with data]} + {[Periode].[Periode].[Evolution]} on 0,
{[Measures].[NbSejours], [Measures].[Séjours Théoriques], [Measures].[Séjours Réels], [Measures].[Nombre Lits], [Measures].[Population]}  ON 1
 FROM [Cube]

有没有办法做到这一点？

Answer 1

您不能更改其名称，但可以定义CAPTION属性。

with member xx as 42, CAPTION = "Marc"
select xx on 0 from [Sales]

希望这能有所帮助。