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
