用到as的时候,如果用到了某个纬度,例如:
with
member mydate as now()
member [告警投诉数量a] as lookupcube("[ALARM_RECORD]","[Measures].[告警投诉数量]")
member [故障总量啊] as lookupcube("[EOMS_FAULT_RECORD]","[Measures].[故障总量]")
member [本周故障总量] as
(
strtomember("[时间].[日期层次].[月].&["+format(mydate,"yyyy年MM月"+"]")).parent.prevmember
,[故障严重程度].[故障严重程度名称].&[重大故障],
[Measures].[故障总量啊]
)
SELECT
{
[Measures].[本周故障总量]
}
ON COLUMNS
FROM
[EOMS_FAULT_RECORD]
如上面的,如果是用到了某个纬度来筛选某个指标,那么最后的cube([EOMS_FAULT_RECORD])中一定要
包含这个纬度([故障严重程度].[故障严重程度名称].&[重大故障]),否则会出错的。
上面的lookupcube -----本来下面是 [ALARM_RECORD]这个cube的,
但是因为没有纬度([故障严重程度].[故障严重程度名称].&[重大故障]),所以报错,
换为有([故障严重程度].[故障严重程度名称].&[重大故障])这个纬度的cube便正确了。