企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1573|回复: 3

TM1 Roll up issue

[复制链接]

86

主题

415

帖子

604

积分

高级会员

Rank: 4

积分
604
QQ
发表于 2014-6-29 13:51:33 | 显示全部楼层 |阅读模式
Hello Friends

I am having an issue with dollar amount roll-up and need your help. I have a cube in which user can enter budget and forecast for future. Issue I am facing with is once users enter budget the total value is showing up more than what user entered. Example user enters 100,000 budget at department level which distributes to divisions at 25,000 each for 4 divisions. When these 4 divisions rolling up I see the total value 100,400 or little more.

I am bit new to TM1 so please help me in troubleshooting the issue

Thanks in advance
回复

使用道具 举报

82

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-6-29 15:06:14 | 显示全部楼层
Most likely caused by a department being in two or more places in the hierarchy that rolls up to the total, in effect, adding it twice (or more).
回复 支持 反对

使用道具 举报

81

主题

389

帖子

575

积分

高级会员

Rank: 4

积分
575
QQ
发表于 2014-6-29 15:49:00 | 显示全部楼层
Its not doubling the amount.. It is just adding around 400 dollars for 100,000. I did flush out the data and loaded again. same issue
回复 支持 反对

使用道具 举报

75

主题

398

帖子

573

积分

高级会员

Rank: 4

积分
573
QQ
发表于 2014-6-29 16:57:10 | 显示全部楼层
mk12350 wrote:Its not doubling the amount.. It is just adding around 400 dollars for 100,000. I did flush out the data and loaded again. same issue

My thought was the same as Tomok's; it's highly improbable that if you're using spreading it's simply plucking an extra 400 out of the air. You might want to provide more details about exactly how you're doing this (and if it's spreading, what type it is), and the structure of your cube and hierarchies.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2022-9-30 12:01 , Processed in 0.063483 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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