數據倉庫mdx的使用

with member [measures].[基站站名] as '[基站控制器_基站_小區].CurrentMember.PropertIEs("基站載頻數")'
member [measures].[基站] as '[基站控制器_基站_小區].CurrentMember.PropertIEs("基站設備型號")'
select {[measures].[基站],[measures].[基站站名]} on columns,
{[基站控制器_基站_小區].[所有 基站控制器_基站_小區].[成都BSC83].[BSS83:BSS83:SITE-1:]}on rows from Radio_cell

跨過一個hIErachy的查詢

with member [measures].[基站載頻數] as '[基站控制器_基站_小區].CurrentMember.PropertIEs("基站載頻數")'
member [measures].[基站設備型號] as '[基站控制器_基站_小區].CurrentMember.PropertIEs("基站設備型號")'

select {[measures].[基站設備型號],[measures].[基站載頻數]} on columns,

except(
     generate([基站控制器_基站_小區].members,
             {
                        descendants(
                                        [基站控制器_基站_小區].currentmember,
                                        [基站控制器_基站_小區].[基站],
                                        self_and_before
                        )
              }
),
{ [基站控制器_基站_小區].[基站控制器].members}
)
on rows
from Radio_cell

七點的時候看紅蘋果，想到了牛。