企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1718|回复: 5

TurboIntegrator Calculation Functions

[复制链接]

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-17 18:31:43 | 显示全部楼层 |阅读模式
Hello all,

in the documentation for TM1 01.1 (Reference guide, Chapter 6. TM1 TurboIntegrator Functions pp. 205) you can find calculation functions for consolidation.

For 9.5.2 it can be found .

The functions are marked as valid in TI and in rules.

After trying to use the ConsolidatedCountUnique and ConsolidatedAvg in my development environment and failing to get other results than #N/A, i did build a small 3 dimensional cube as state in the example to better understand the use of these functions.

My Rule
Code: ['Average' ]  =  c: ConsolidatedAvg( 0,  'Income Statement', 'All Regions', '2010', 'Gross Sales' );
still returns a #N/A.

Rules Tracer throws a 'RULE LINE ERROR' and 'Calculated: -1.#QNB '.

Unfortunately my searches via google and n tm1forums didn't came up with any more than the function reference.

Did anyone successfully implemented the functions or can help me implementing the function in a rule?

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

64

主题

404

帖子

556

积分

高级会员

Rank: 4

积分
556
QQ
发表于 2014-3-17 20:02:33 | 显示全部楼层
Hello

Please try:

Code: ['All Regions', '2010','Average' ]  =  c: ConsolidatedAvg( 0,  'Income Statement',!Region, !Year, 'Gross Sales' );

Change the Region and Year dimension names if needed to suit.

On the left hand side, you can take out the selections but I bet you will know this

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

85

主题

427

帖子

621

积分

高级会员

Rank: 4

积分
621
QQ
发表于 2014-3-17 20:13:30 | 显示全部楼层
Hi Wim,

i tried the code with the whole dimension (!dimensionname) it resulted in the same error.  The error seems to be independent which Area.

But, after rereading the Example i found my mistake.

Income statement in the example is a cube and a Dimension. The first Occurence in the example is referencing the cube. Since my usage is in a rule i can leve it blank resulting in:
Code: ['Average' ]  =c:  ConsolidatedAvg( 0,  '',!Area, !Time2, 'Gross Sales' );

Without the restriction to consolidate elements i still get a #N/A for my leaf level Averages.  I will post if get an answer to that.

Thanks a lot for your help.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-3-17 21:13:33 | 显示全部楼层
My pleasure.
Sebastian Paulussen wrote:Without the restriction to consolidate elements i still get a #N/A for my leaf level Averages.  I will post if get an answer to taht.

Do you mean that you have the same rule at N level too, so you want to show the average of 1 data point (Gross Sales) in the measure Average ?
回复 支持 反对

使用道具 举报

78

主题

397

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-3-17 23:19:22 | 显示全部楼层
That is correct. I know it would not be of much use since the average of 1 Datapoint is the Value of the Datapoint itself. The purpose is here that i would not have to write another Rule.  That could be handy in a Scenario where the Line of Business is allowed to change Rules via a Rules Workbook
回复 支持 反对

使用道具 举报

81

主题

429

帖子

608

积分

高级会员

Rank: 4

积分
608
QQ
发表于 2014-3-17 23:23:16 | 显示全部楼层
I would just carry over the data at N level using a different rule on the same area.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-7-5 15:31 , Processed in 0.159425 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表