數據倉庫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,

文章來源于領測軟件測試網 http://www.kjueaiud.com/

TAG: 數據倉庫 mdx