我用滞后时间说,给我暗淡时间层次结构中指定年份成员的第一季度的第一季度之前的三个季度,直到第一季度。之所以有效,是因为我在计算所得的成员中使用currentmember,然后在行轴上指定了这些成员。
WITH MEMBER [LTII_NIRS_E] AS'Sum({[DIM TIME].[YEAR - QUARTER - MONTH].currentmember.firstchild.lag(3): [DIM TIME].[YEAR - QUARTER - MONTH].currentmember.firstchild}, [Measures].[LTII NIRS E])'SELECt [LTII_NIRS_E] ON COLUMNS, { [DIM TIME].[YEAR - QUARTER - MONTH].[2006], [DIM TIME].[YEAR - QUARTER - MONTH].[2007], [DIM TIME].[YEAR - QUARTER - MONTH].[2008]} on ROWS FROM [NH_INCID] WHERe [Business Component].[Region].[Novelis North America]


