数据仓库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,

文章来源于领测软件测试网 https://www.ltesting.net/

TAG: 数据仓库 mdx