企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 736|回复: 1

Tree Structure Report

[复制链接]

64

主题

404

帖子

556

积分

高级会员

Rank: 4

积分
556
QQ
发表于 2014-6-28 08:55:50 | 显示全部楼层 |阅读模式
All,

I have a client that wants to do all their statutory consolidations in a system (lots of subsidiaries and associates) but don't wish to use a new tool.

I have informed them that I can build what they need in TM1/CX since that will already be in place for their budgeting/forecasting requirements.

The question I have however doesn't span creating the model as I am comfortable with that task, I am more intrigued as to the ability to produce a Company Hierarchy Structure Report such as the Tree Structure Report in Controller.

example of data to be input into a web report:

Company Owner Percentage
B A 100
C A 100
D C 100
E B 25
E C 25
E D 50

Company A is at the top with 2 lines to B and C which in turn have lines going to D and E, D also has a line to E.


As above I can't just export a dimension hierarchy as the structure will need to be more of a web/matrix affair.

Unless I have missed some seriously snazzy part of TM1 I am aware it will need the use of an external tool, so does anyone know of anything where I could export data in a similar format to that above (albeit a much larger csv) and then have a nice matrix style report created at the end of it?

Just to make the question a little bit trickier I am ideally looking for something free/cheap... we all like a challenge don't we?

Cheers in advance,
Declan



EDIT - "Just realised that the company may have a copy of visio which would solve the problem for me but I will leave the topic open as it never hurts to get a bit of extra input."
回复

使用道具 举报

58

主题

371

帖子

514

积分

高级会员

Rank: 4

积分
514
发表于 2014-6-28 12:32:17 | 显示全部楼层
Have you looked at the hierarchy chart in SmartArt, which is a tool in Excel 2007/2010? I've only used to to create simple hierarchy displays but it can create an organization/hierarchy report very easily. Don't know how well it would perform with large and/or complex hierarchies.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-25 12:55 , Processed in 0.091497 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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