企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 771|回复: 8

What if analysis in Cube!!!!!

[复制链接]

91

主题

407

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-3-17 18:01:49 | 显示全部楼层 |阅读模式
TASK What if Analysis)
There is a Cube with dimensions and some measures and we have lot of Users

Now User 1 open a cross section and writes some values into cube and he must save this view as his own view (View 1)
Again after some time USER 1 comes back and writes again into a cube with new values and saves VIEW2
In the same way User 2 ...USER 3.... so on..
User 2 must not see User1 data
All the users write into same cross section of a cube... ((Dont know how this can be accomplished)
There is a Main Admin User on Top who writes default values into the same cross section then all Users must see the default users
and then again users will Over writes into the same cross section and saves to their views......

please let me know.... any solution
Am using TM1 9.4.1
回复

使用道具 举报

70

主题

437

帖子

587

积分

高级会员

Rank: 4

积分
587
QQ
发表于 2014-3-17 19:06:25 | 显示全部楼层
In TM1 version 9.5 or later there is a new feature called SandBox - but unfortunately the TM1 version you are on does not have this.

You can add a dimension to your cube which you can use for What-If/Forecast/Version entries. You can add different elements to this new dimension e.g Version 1, Version 2, Version 3....

and then you can setup TM1 Security in such a way that User 1 will have access to only Version 1, User 2 will have access to only Version 2.....

while your Admin will have access to all the Versions.
回复 支持 反对

使用道具 举报

81

主题

429

帖子

608

积分

高级会员

Rank: 4

积分
608
QQ
发表于 2014-3-17 19:53:41 | 显示全部楼层
Thanks kaif will try to approach ur adviced way and will post back if any other huddles comes up..

Thanks
回复 支持 反对

使用道具 举报

85

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-3-17 19:55:47 | 显示全部楼层
rkaif wrote:In TM1 version 9.5 or later there is a new feature called SandBox
I've always been wondering about this Sandbox.

Let's say I have a scenario like this:
I have cube FX Rate which is managed by user A, and another cube called Expense managed by user B.
User A only has write access to FX Rate, and no access at all to cube Expense. Meanwhile, B has write access to cube Expense and read access to cube FX Rate.
The expenses are inputed in multiple currencies.

Now, B want to play around with the FX Rate and see the impact to his expenses. In this case, this cannot be achieved because B cannot change the FX Rate (yes, I can grant B write access to FX Rate, but usually rates are only managed by one user).
Asking A to create Sandbox in FX Rate and B to create Sandbox in Expense won't do either, because Sandboxes are like private views, they won't interconnect.

So the only way out that I can think of is to grant B write access to FX Rate, which will break the actual business process a lil bit.
Any thoughts anyone?
回复 支持 反对

使用道具 举报

74

主题

392

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-3-17 20:24:11 | 显示全部楼层
You can define different logic for the base version and the what if version(s).
The base FX rate should be maintained by only one user (A) and the other rate(s) by others.
回复 支持 反对

使用道具 举报

77

主题

397

帖子

570

积分

高级会员

Rank: 4

积分
570
QQ
发表于 2014-3-17 21:57:45 | 显示全部楼层
kpk wrote:You can define different logic for the base version and the what if version(s).
The base FX rate should be maintained by only one user (A) and the other rate(s) by others.

So do you mean instead of using Sandbox, I should create a Version dimension on FX Rate for a what if analysis?
Then, the Sandbox should be left for no good?
回复 支持 反对

使用道具 举报

77

主题

392

帖子

558

积分

高级会员

Rank: 4

积分
558
QQ
发表于 2014-3-17 22:08:01 | 显示全部楼层
comma wrote:So do you mean instead of using Sandbox, I should create a Version dimension on FX Rate for a what if analysis?
Then, the Sandbox should be left for no good?

I don't think you understand what the sandbox is designed for. The idea behind the sandbox is to let users try different values for the items they are responsible for "contributing" to the model, outside of the shared workspace, until they find the right amounts, then they commit those values to the main model. It's not really a "what if" tool, although it can be for the things you are allowed to change. If you as a user are not allowed to modify fxrates, then you're not going to be able to sandbox them. Simple as that. For a truly what-if model you'll have to modify the secured dimensions to add what-if elements users can be given access to, so they can play with them, or alternatively create a what-if cube that looks like the original cube, having identical, but differently named, dimensions so you can give out security access to them. If you add the }Clients dimension to the cube then each user can have their own what-if area to work with. You could pipe in, via a rule, the base anounts so each user has a starting point for the what-if. This is just one idea, the possibilities are endless with TM1.
回复 支持 反对

使用道具 举报

89

主题

395

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-17 22:18:22 | 显示全部楼层
You can define cell secuirty for this cross section and and as "tommok' said admin via rule or TI.
回复 支持 反对

使用道具 举报

94

主题

397

帖子

609

积分

高级会员

Rank: 4

积分
609
QQ
发表于 2014-3-17 22:21:14 | 显示全部楼层
Hmm, I think I get what you mean, tomok.
Thanks for the advice!
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-9-24 19:48 , Processed in 0.180635 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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