企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 752|回复: 11

Dimension with multiple levels hierarchy

[复制链接]

87

主题

397

帖子

595

积分

高级会员

Rank: 4

积分
595
QQ
发表于 2014-3-17 10:24:26 | 显示全部楼层 |阅读模式
Hi all,
I'm a newbie about TM1 and I'm reading many tutorial (above all IBM documents and the book "TM1 Cookbook") but I have some problems to develope a dimension having a hierarchy with multiple levels.
In my environment, I have a table in Sql Server as reguard as time with the following columns:
- year
- quarter
- month
- day

Dates in this table are between 01-01-2000 and 31-12-2020

I use Turbo Integrator process to create in TM1 a time dimension with the above hierarchy but the result isn't that I hoped :
process groups quarters so, e.g. in the 2010 1st quarter, I see all the dates are in all 1st quarters (all years)
Does anybody can advice me some videos or tutorials that can guide me simply?
I'm reading many documents that build the hierarchy in excel but they don't help me.
Thanks in advance for your time
回复

使用道具 举报

83

主题

421

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-3-17 11:47:54 | 显示全部楼层
Your best bet is to post the code in the TI that you written if you want explicit help.

Alan Kirk has done some videos though I don't know if there is one that covers your area.
Cheers
回复 支持 反对

使用道具 举报

71

主题

393

帖子

560

积分

高级会员

Rank: 4

积分
560
QQ
发表于 2014-3-17 11:51:11 | 显示全部楼层
Hi,

I attached 3 jpegs showing my process configuration.
In the 1st image I set Data as Element and others Year, Month, Quarter (corresponding to "anno", "mesestring" and "trimestre") as consolidation

                                                                                        1.jpg (44.47 KiB) Viewed 1509 times                               


In the 2nd image I set the name of my dimension

                                                                                        2.jpg (30.48 KiB) Viewed 1509 times                               


In the 3rd image I setup the hierarchy indicating the children elements
This same image shows the results of the dimension

                                                                                        5.jpg (92.73 KiB) Viewed 1509 times                               


As you can see, data are not in the desired hierarchy
What's wrong?
Thanks in advance for your help
回复 支持 反对

使用道具 举报

84

主题

404

帖子

593

积分

高级会员

Rank: 4

积分
593
QQ
发表于 2014-3-17 12:19:12 | 显示全部楼层
What about the Consolidamento tab? Whats's the code on that one?
回复 支持 反对

使用道具 举报

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-3-17 12:47:45 | 显示全部楼层
sorry....

                                                                                        6.jpg (31.86 KiB) Viewed 1504 times
回复 支持 反对

使用道具 举报

81

主题

411

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-17 13:25:24 | 显示全部楼层
Your dimension is being built exactly as you have specified in the Consolidations tab. I can't help you correcting it because I can't read or write (Italian????) so I don't know what the correct designation of the variables should be.
回复 支持 反对

使用道具 举报

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-3-17 13:50:43 | 显示全部楼层
Hi tomok,
thanks for your time.
Yes, my TM1 is setup in italian language.
Unfornutately I haven't english language in my TM1 installation.
But, because I need your help, what information do you need to debug my process and help me to solve this issue?
Regards
回复 支持 反对

使用道具 举报

73

主题

390

帖子

558

积分

高级会员

Rank: 4

积分
558
QQ
发表于 2014-3-17 14:04:32 | 显示全部楼层
Hi Roasanero

Not sure if this is the problem, as my grasp of Italian doesn't much go past the names of football teams!

It looks like the consolidations are not unique so get rolled up into multiple places!

For example, October is not unique to 2012 - there is one in 2011, 2010 etc. The same for weeks as well - week 01 is not unique to January 2012 as there is one in January 2011..... you get the point!

By creating new variables you could join together the year and month to get 2012_10 or 2012_October, and the same for the weeks - 2012_October_Week01. Weeks then role up into Months, which role up into Years.

Hope this helps
回复 支持 反对

使用道具 举报

86

主题

402

帖子

589

积分

高级会员

Rank: 4

积分
589
QQ
发表于 2014-3-17 14:22:51 | 显示全部楼层
Hi Anthony,

I was suspecting just that you wrote.
But this isn't a pretty solution (even if I think is THE solution), aren't you agree?   
I used Transformer and the dimensional functionalities of Framework Manager and there all is more simple and hierachies  are created in a few minutes.
So, I'll adopt this workaround...  
Thank you so much

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

73

主题

397

帖子

567

积分

高级会员

Rank: 4

积分
567
QQ
发表于 2014-3-17 14:37:53 | 显示全部楼层
now it works (see the attached picture), but why dates are also outside the consolidation?
                                                                                        7.jpg (101.29 KiB) Viewed 1488 times
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-24 14:03 , Processed in 0.116069 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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