TotalActivities,TotalPossibleActivities,NotApplicableActivities的计算方法

NotApplicableActivities = TotalActivities - TotalPossibleActivities

含义是针对每一个问题的Aspect是否包含IntegrationAspect的情况进行统计和计算。

 

原来的IntegrationAspect是{Protocol Aspects}。现在改进为{Scoped Aspects} 与{Protocol Aspects}的交集。

确保筛选出来的IntegrationAspect是有意义的，避免了

 

这里的Activity可以理解为本次Assessment的Scoped 问题。

 

TotalActivities : 包含{IntegrationAspect} Scoped 的问题总数。===> MaxScore

TotalPossibleActivities, : 包含{IntegrationAspect} 可用Avaliable的Scoped问题总数  =====>AvaiableScore

 

有用的MDX:

 

***************Total Acitivity个数**************

然后根据MaxCore<>null进行筛选，得到总数。

 

 

 

 

 

 

 

 

 

 

with

 

 

member [Measures].[Average Score] as Sum ([Protocol].[r Parent].[Level3], Measures.[Max Score]*100)/ avg

([Protocol].[r Parent].[Level3], Measures.[Max Score]*100)

member

 

 

[Measures].[Min Score] as Min

([Protocol].[r Parent].[Level1], Measures.[% Score]*100)

 

 

member [Measures].[Protocol Code] as [Protocol].[r Parent]. CurrentMember . Properties

( "m Code" )

 

 

select

{[Measures].[% Score],[Measures].[Score],[Measures].[Max Score], [Measures].[Available Score],

[Measures].[Protocol Code],Measures.[Average Score],Measures.[Min Score]}

 

on columns

,

{[Protocol].[r Parent].[Level3]}

 

on

rows

 

 

-- {[Aspect].[m Name].[All],[Aspect].[m Name].[All]} on rows

 

 

from ( select

( { [Question Property].[Question Property].[Question Property] } )

 

 

 

on columns from

[Scoring STMicroelectronics Rev 33_2009 12 16 ST181201])

 

 

 

where

[Assessment].[r Parent].&[{e94c6dec-59a7-4d93-8564-e13f5b003e0a}]

 

 

*********************************PossibleAcrtivity

{[Protocol].[r Parent].[Level3]} =============>

[Protocol].[r Parent].[Level3]*[Aspect].[m Name].[m Name]

然后根据AspectName进行统计，其中包含{IntegrationAspect}的符合条件。