企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 743|回复: 13

Insert blank lines as separators?

[复制链接]

89

主题

395

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-17 22:41:34 | 显示全部楼层 |阅读模式
Folks

Would like to separate sections of measure dimension using blank lines.

clearly i can create the 'separators' using dash/underscores etc but ....

Any tips?

Thanks

Newbie
回复

使用道具 举报

93

主题

423

帖子

630

积分

高级会员

Rank: 4

积分
630
QQ
发表于 2014-3-18 00:16:18 | 显示全部楼层
Mark,
You night want to give more information about where you are trying to do this in the TM1 world, it is pretty difficult to answer as currently phrased....
回复 支持 反对

使用道具 举报

73

主题

409

帖子

584

积分

高级会员

Rank: 4

积分
584
QQ
发表于 2014-3-18 00:24:26 | 显示全部楼层
Fair enough Steve - will try again.

On my measure dimension i have different groups such as 3 expense lines then 3 revenue lines or simply consider the sections of a PnL.  To avoid one straight list I wish to make it a little easier on the eye:

revenue_1
revenue_2
revenue_3
blank line
expense_1
expense_2
expense_3
blank line

In absence of this technique i am doing this:
revenue_1
revenue_2
revenue_3
--
expense_1
expense_2
expense_3
--------

I have seen this achieved in other technologies by using the pipe '|' symbol

I could use a hierrchy to group expenses and revenue but there are times when i would just prefer a blank.


Thanks
回复 支持 反对

使用道具 举报

70

主题

437

帖子

587

积分

高级会员

Rank: 4

积分
587
QQ
发表于 2014-3-18 01:03:16 | 显示全部楼层
It would be an exceedingly bad idea to add any type of "dummy" element or pseudo measure to a dimension in order to make the presentation easier on the eye. Each element must be denoted by a valid character string consisting of letters, numerals, and the other valid characters like underscore, etc. TM1 ignores blank spaces in element names so I'm pretty sure it won't work. This is not to mention how bad an idea this is from a data modeling standpoint. You should never bastardize your model just for presentation purposes. This type thing is better done in the reports you will create in the tool. I'm pretty sure you don't have any options in the cube viewer or subset editor to achieve this but it can be done in Excel or TM1 Web reports with a little creativity with VBA or Active Forms. You should use the search function in this web site for that topic. there's probably a post or two about this very thing.
回复 支持 反对

使用道具 举报

64

主题

373

帖子

515

积分

高级会员

Rank: 4

积分
515
QQ
发表于 2014-3-18 01:14:51 | 显示全部楼层
I can see where you are coming from but which environment are you going to view this in?

If it is any of the dynamic views of TM1, like the cube viewer, dynamic slice etc then your users will nearly always have zero suppression on and so won't see the gap any way.

If you are in a static Excel report I'd just be inserting some blanks rows in the report.

As far as bastardising your model goes, I think that you should build whatever you need that gives your users the best experience subject to the constraints you have in the support you can offer.  I just can't see how you could build what you want in a useful way...

Cheers
回复 支持 反对

使用道具 举报

66

主题

395

帖子

544

积分

高级会员

Rank: 4

积分
544
QQ
发表于 2014-3-18 01:20:32 | 显示全部楼层
I wouldn't go as far as Tomok on this one.  If the use interface is going to be cube view, contributor or active form then you can make a case for having blank or header elements that hold no data.  If it something has a purpose in a model then it has a purpose, I wouldn't be so purist to insist that that purpose must be to hold data or perform a calculation.

Note that if proper use is made of subsets then you don't actually need multiple blanks as you can reuse the same element multiple times.  However if you are talking section headers as opposed to blanks (which I think is more useful) then this is normally better handled by a consolidation as this allows users to expand and collapse sections.  If the purpose of the element is purely organizational not as a genuine consolidation point then just make the element weightings all 0 and use element formatting to display a 0 as a blank cell.
回复 支持 反对

使用道具 举报

82

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-3-18 01:52:31 | 显示全部楼层
lotsaram wrote:If the purpose of the element is purely organizational not as a genuine consolidation point then just make the element weightings all 0 and use element formatting to display a 0 as a blank cell.

and give up on zero-suppressed rows, which seems to be the prerequisite throughout the discussion.
回复 支持 反对

使用道具 举报

76

主题

403

帖子

586

积分

高级会员

Rank: 4

积分
586
QQ
发表于 2014-3-18 01:56:26 | 显示全部楼层
Wim Gielis wrote:and give up on zero-suppressed rows, which seems to be the prerequisite throughout the discussion.
True, where I have used this has been for web input forms using active forms. As the forms have been to capture data from a blank base zero supression wasn't on and so this was a non issue.  If you wanted to get tricky you could have the element weights as standard 1 not 0 and use element formatting to make all values display as blank (i.e. ;;;)
回复 支持 反对

使用道具 举报

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-3-18 01:57:29 | 显示全部楼层
Thanks guys.  We have covered headers/groupings without data but seems there is not way to insert a blank line then.  

Cheers
回复 支持 反对

使用道具 举报

75

主题

409

帖子

574

积分

高级会员

Rank: 4

积分
574
QQ
发表于 2014-3-18 02:16:47 | 显示全部楼层
I have often wanted this.  (Well, actually, my management wants this.  Formatting to senior management seems to be as important as the numbers themselves, but, I digress.)
Reports just look better if there is a spacer line between one section and the next.
As was pointed out, this is easy enough to do with a Slice report (just add a blank line where you want it.)
But I use a lot of Active Forms.
I thought you might be able to have the section total line in the format section have a bigger row height.  But, alas, row height is not one of the format elements carried from the format section to the data section.  (At least, not in 9.5.2.  IBM ... how about adding this in 10.2)
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-9-20 06:45 , Processed in 0.174688 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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