企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 169|回复: 1

Hide lowest level in a hierarchy

[复制链接]

82

主题

429

帖子

624

积分

高级会员

Rank: 4

积分
624
QQ
发表于 2014-3-15 07:54:39 | 显示全部楼层 |阅读模式
Hi gurus

I'm using a TI-process to fill an hierarchy. Since I'm getting data from a star schema the ID column is the lowest level but this is not something I want to show the users drilling the dimension.
Let's look at the account hierarchy for instance.

Level 1 - 4
Level 2 - 41
Level 3 - 411
Level 4 - 4111. ( this is will be the lowest visible level for the user )
Level 5 - x ( this is an arbitrary number that will change but it should not be shown if the user drills on 4111 but the data is loaded to this level)

Is there a way of doing this using a TI?

I'm using cognos 10 BI ontop of this so I won't be able to use subsets.

Br
Peter
回复

使用道具 举报

82

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-3-15 09:32:55 | 显示全部楼层
Do you need the data to be loaded at the lowest level? ie is there someone else who does view it at that level?

If not:-

Load directly to the higher level by having a "reference dimension", this either exists outside of any cube and contains elements for all of the "level 5" element and an attribute stating what level 4 they belong to. You could also add it into a 2-dim cube with the other dim containing 1 string element and hold the "level 4" group in there instead.

When the TI does the loading have it reference what level 4 it should go to and accumulate them into that level in your main cube. Obviously with this method your main cubes dimension doesn't have a level 5 and level 4 is its lowest level.


If you do need it in TM1 at level 5:-

A/ Use security to let certain users only have read access to level 4 - level 1, and no access to level 5.

or

B/ Create an extra cube with all the same dims except the one in question which is replaced with a dim that only has Level 4 - Level 1.
Rule drive the elements from your "full" input cube to this summarised one and only give users access to the summary cube.

HTH
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-9-21 13:30 , Processed in 0.184366 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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