Microsoft SQL Server MDX step by step 第五章

Properties 用于返回成员的属性， member.Properties( Name [, TYPED] )   

一般情况下是以字符串的形式返回。如果我们使用Typed关键字，那么将按照这个属性本身的数据类型来返回。下面两个语句的执行结果相同

指定typed 关键字，返回是Level_Number本身的数值类型

未指定typed 关键字，返回类型是字符串

WITH MEMBER [Measures].[Parent Member Name] as    IIF(       [Product].[Product Categories].CurrentMember.Properties("Level_Number",TYPED)=0,       "Not applicable",       [Product].[Product Categories].CurrentMember.Parent.Name       ) MEMBER [Measures].[Percent of Parent] as    ([Measures].[Reseller Sales Amount])/    ([Product].[Product Categories].CurrentMember.Parent, [Measures].[Reseller Sales Amount])    ,FORMAT_STRING="Percent" SELECT    {       ([Measures].[Parent Member Name]),       ([Measures].[Reseller Sales Amount]),       ([Measures].[Percent of Parent])    } ON COLUMNS,    {[Product].[Product Categories].AllMembers} ON ROWS FROM [Step-by-Step] ;

WITH MEMBER [Measures].[Parent Member Name] as    IIF(       [Product].[Product Categories].CurrentMember.Properties("Level_Number")= '0',       "Not applicable",       [Product].[Product Categories].CurrentMember.Parent.Name       ) MEMBER [Measures].[Percent of Parent] as    ([Measures].[Reseller Sales Amount])/    ([Product].[Product Categories].CurrentMember.Parent, [Measures].[Reseller Sales Amount])    ,FORMAT_STRING="Percent" SELECT    {       ([Measures].[Parent Member Name]),       ([Measures].[Reseller Sales Amount]),       ([Measures].[Percent of Parent])    } ON COLUMNS,    {[Product].[Product Categories].AllMembers} ON ROWS FROM [Step-by-Step] ;