文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>SSAS Correlation MDX Function

SSAS Correlation MDX Function

时间:2010-12-30  来源:经典神话

Correlation (set, y numeric value expression [, x numeric value expression])
Standard (not in Essbase 9)
This function calculates a correlation coefficient between x-y pairs of values.
The y numeric expression is evaluated over the set to get the y values
for each pair. If the x numeric expression is present, then it is evaluated
over the set. Otherwise, the cells formed by the set are evaluated within
the current context, and their values are used as the x values. The formula
for the correlation coefficient is as follows:


If either the y or the x numeric expression is a logical or text value, or if the
value is NULL, then that tuple and its related values are not included in
the correlation. Zero values for y and x are included.

话不多说: 上代码示例

Correlation(
 {
       (
             [Subject].[Subject Name].currentmember,
             [Student].[Sutdent Name].[All].children  
       )
 },
 (
        [Measures].[Score],
        [Subject].[Subject Name].[All]
 ),
 (
        [Measures].[Score],
        [Subject].[Subject Name].currentmember
 )

)

这个是求学生单科成绩与学生总分的相关系数.

  效果图:

    

与Excel 计算公式所得结果相同.

本人也是该领域新手.~  边学边总结.  苦于资料有用的真的很少,郁闷~ ....

相关阅读 更多 +
排行榜 更多 +
浴血混战官方下载

浴血混战官方下载

飞行射击 下载
检票员模拟器免广告下载

检票员模拟器免广告下载

模拟经营 下载
最终前哨最终版手机版下载

最终前哨最终版手机版下载

休闲益智 下载