Insert blank lines as separators?

小蚂蚱

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

黄华民

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....

bxmsw

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

jhh6yf

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.

玩美123

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

想想111

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.

chenbaolei

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.

wzsycdh

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. ;;;)

赏狗网

Thanks guys.  We have covered headers/groupings without data but seems there is not way to insert a blank line then.  

Cheers

shaochaowei

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)