Sometimes it is necessary to show for users pseudo hierarchies which are looking like a hierarchy but they are not
For example like this
(see theme about it here
http://www.tm1forum.com/viewtopic.php?f=3&t=8833 )
But it seems this idea doesn't work properly
The only way which comes to my mind is create alias which look like
And it looks in view like
But first variant looks better because in the second one I have to add symbol '-' in start of element in alias - unfortunattely I can't start from spaces ' ' in names
So may be somebody could give me idea how to show pseudo hierarchies which would look like the first case.
Ways of create pseudo hierarchies
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Ways of create pseudo hierarchies
You can use the ASCII ALT-255 character as a indenting prefix in an alias. This is a space character but is not ignored by TM1 as are regular spaces.
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Ways of create pseudo hierarchies
When I tried to input alt+255 in Attributes Editor it saves only without first empty places - think it is a space anyway.lotsaram wrote:You can use the ASCII ALT-255 character as a indenting prefix in an alias. This is a space character but is not ignored by TM1 as are regular spaces.
But helps
Code: Select all
str1=Char(160) | ' Regions_lev1';
AttrPutS(str1, 'Regions', 'Regions_lev1', 'Reg_name');
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Ways of create pseudo hierarchies
So shouldn't your code use Char(255)? Are you getting the desired effect with Char(160)?EP_explorer wrote:When I tried to input alt+255 in Attributes Editor it saves only without first empty places - think it is a space anyway.lotsaram wrote:You can use the ASCII ALT-255 character as a indenting prefix in an alias. This is a space character but is not ignored by TM1 as are regular spaces.
But helpsCode: Select all
str1=Char(160) | ' Regions_lev1'; AttrPutS(str1, 'Regions', 'Regions_lev1', 'Reg_name');
Robin Mackenzie
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Ways of create pseudo hierarchies
Yes.
If I useChar(255) in TI process it puts the symbol of national alphabit - not space, but if I put Char(160) - it works.
If I put Alt+255 by hands in Attribute Editor it puts space but it doesn't save with space - simply delete spaces before first letter
If I useChar(255) in TI process it puts the symbol of national alphabit - not space, but if I put Char(160) - it works.
If I put Alt+255 by hands in Attribute Editor it puts space but it doesn't save with space - simply delete spaces before first letter