Ways of create pseudo hierarchies

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Ways of create pseudo hierarchies

Post by EP_explorer »

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 )
04.JPG
04.JPG (22 KiB) Viewed 3526 times
But it seems this idea doesn't work properly

The only way which comes to my mind is create alias which look like
06.JPG
06.JPG (9.61 KiB) Viewed 3526 times
And it looks in view like
05.JPG
05.JPG (21.68 KiB) Viewed 3526 times
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.
lotsaram
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

Post by lotsaram »

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

Post by EP_explorer »

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.
When I tried to input alt+255 in Attributes Editor it saves only without first empty places - think it is a space anyway.

But helps

Code: Select all

  str1=Char(160) |  '  Regions_lev1';
  AttrPutS(str1, 'Regions', 'Regions_lev1', 'Reg_name');
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Ways of create pseudo hierarchies

Post by rmackenzie »

EP_explorer wrote:
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.
When I tried to input alt+255 in Attributes Editor it saves only without first empty places - think it is a space anyway.

But helps

Code: Select all

str1=Char(160) | ' Regions_lev1';
AttrPutS(str1, 'Regions', 'Regions_lev1', 'Reg_name');
So shouldn't your code use Char(255)? Are you getting the desired effect with Char(160)?
Robin Mackenzie
EP_explorer
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

Post by EP_explorer »

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
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Ways of create pseudo hierarchies

Post by Duncan P »

Post Reply