Rule Editor converting "£" to "?"
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Rule Editor converting "£" to "?"
Hey all, bit of a strange one this.
Playing about with 9.1's rule editor over Citrix and came across an unusual and incredibly annoying bug. The editor seems to convert a "£" symbol into a "?" symbol. I can't get it to put a £ symbol into the editor however I try - copy / paste from notepad, etc.
Only way of getting round it I can see is to call the CHAR function but this seems ridiculous.
Given I've not played with 9.1's rule editor much yet and can't find any ref to it on a search, I'm trying to pin this down to a TM1 or Citrix issue and wondered if anyone had come across this?
TIA
Playing about with 9.1's rule editor over Citrix and came across an unusual and incredibly annoying bug. The editor seems to convert a "£" symbol into a "?" symbol. I can't get it to put a £ symbol into the editor however I try - copy / paste from notepad, etc.
Only way of getting round it I can see is to call the CHAR function but this seems ridiculous.
Given I've not played with 9.1's rule editor much yet and can't find any ref to it on a search, I'm trying to pin this down to a TM1 or Citrix issue and wondered if anyone had come across this?
TIA
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
I encountered this one. You have to revert your rules editor back to the basic editor. It's a known bug with the editor.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Rule Editor converting "£" to "?"
I think this is a "feature" not a bug since the "Advanced" rules editor does not support the extended character set including £ sign.garry cook wrote: The editor seems to convert a "£" symbol into a "?" symbol. I can't get it to put a £ symbol into the editor however I try - copy / paste from notepad, etc.
Along with other iritations this is why we don't really use it and I think IBM Cognos have come to a similar conclusion since it is disabled by default in currrent installation of versions 9.4 and 9.5 ( not sure about 9.1)
This is a shame because it has some nice layout and colouring features.
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: Rule Editor converting "£" to "?"
Thanks Jim - sadly I suspected that may be the case.
I really wanted to play with that nice shiny rule editor too
Ah well, thanks for confirming. Guess it's back to notepad sytle rules then as I can't be bothered calling CHAR functions everywhere.
I really wanted to play with that nice shiny rule editor too

Ah well, thanks for confirming. Guess it's back to notepad sytle rules then as I can't be bothered calling CHAR functions everywhere.
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: Rule Editor converting "£" to "?"
And thanks too Steve.
Super speedy response btw - you guys sitting hitting F5 constantly or just lucky with the timing?
Super speedy response btw - you guys sitting hitting F5 constantly or just lucky with the timing?

- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
Apologies, I forgot that TM1 is the most feature rich bit of kit out there!!stephen waters wrote: I think this is a "feature" not a bug since the "Advanced" rules editor does not support the extended character set including £ sign.

Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 73
- Joined: Fri Apr 23, 2010 11:35 am
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2007 2010
Re: Rule Editor converting "£" to "?"
I'm curious , why would you need '£' in a rule?
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Rule Editor converting "£" to "?"
The same reason you would need any other character, if you used it in either the name of a cube, dimension, dimension element, or attribute.ParisHilton wrote:I'm curious , why would you need '£' in a rule?
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
You could do this with a consolidation instead of a rule - weight the £000 with 0.001. If this rule is the only mention of £ then this might allow you to go back to the shiny editor.garry cook wrote:We have it in a dimension called scale. It has 2 elements £0 and £000.
Martin
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 73
- Joined: Fri Apr 23, 2010 11:35 am
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2007 2010
Re: Rule Editor converting "£" to "?"
ah, that makes sense.
I was thinking of it in terms of a measure.
I was thinking of it in terms of a measure.
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule Editor converting "£" to "?"
Well... either that or using those format-rich .xru files...garry cook wrote:Thanks Jim - sadly I suspected that may be the case.
I really wanted to play with that nice shiny rule editor too
Ah well, thanks for confirming. Guess it's back to notepad sytle rules then as I can't be bothered calling CHAR functions everywhere.

"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Rule Editor converting "£" to "?"
Hi Alan,
Surprised to see you posting, I thought you would be off watching the cricket
Surprised to see you posting, I thought you would be off watching the cricket

-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule Editor converting "£" to "?"
Hey, I'm quite happy for you (Jim, the other Steves, John) to indulge in your Anglophile celebrations since (a) As I understand it, it has been a while!, (b) The last time I paid attention to a cricket score Greg Chappell was still the captain and frankly, I have no idea who won what or when except that apparently England won the series and (c) The last time I paid attention to anyone (other than me) playing any sport, Belinda Snell was still captain of the Sydney Flames and saying "Oh well, there's always next year. Of course, I'm getting sick of saying that every year..."stephen waters wrote:Hi Alan,
Surprised to see you posting, I thought you would be off watching the cricket
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
I'm glad your happy for us as we are happy for us as well. There is nothing better than watching Ricky Ponting squirm on telly.Alan Kirk wrote:Hey, I'm quite happy for you (Jim, the other Steves, John) to indulge in your Anglophile celebrations since (a) As I understand it, it has been a while!, (b) The last time I paid attention to a cricket score Greg Chappell was still the captain and frankly, I have no idea who won what or when except that apparently England won the series and (c) The last time I paid attention to anyone (other than me) playing any sport, Belinda Snell was still captain of the Sydney Flames and saying "Oh well, there's always next year. Of course, I'm getting sick of saying that every year..."
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule Editor converting "£" to "?"
If you believe that then clearly, you've never seen Belinda Snell sink a three point throw when a great deal of lunging and stretching was involved.jim wood wrote:I'm glad your happy for us as we are happy for us as well. There is nothing better than watching Ricky Ponting squirm on telly.Alan Kirk wrote:Hey, I'm quite happy for you (Jim, the other Steves, John) to indulge in your Anglophile celebrations since (a) As I understand it, it has been a while!, (b) The last time I paid attention to a cricket score Greg Chappell was still the captain and frankly, I have no idea who won what or when except that apparently England won the series and (c) The last time I paid attention to anyone (other than me) playing any sport, Belinda Snell was still captain of the Sydney Flames and saying "Oh well, there's always next year. Of course, I'm getting sick of saying that every year..."
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
Who is Belinda Snell??? Should I google her in work or wait until I get home??
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: Rule Editor converting "£" to "?"
Impostor-tastic! I didn't write that (indeed, the problem I'm dealing with isn't even mine and refers to an element name with £ in it rather than GBP - yuck), Jim's signed off as Martin and my account had exceeded no of logon attempts when I went to reply to this forum when I've had no sign on issues recentlyby jim wood » Thu Jan 06, 2011 1:42 pm
garry cook wrote:
We have it in a dimension called scale. It has 2 elements £0 and £000.
You could do this with a consolidation instead of a rule - weight the £000 with 0.001. If this rule is the only mention of £ then this might allow you to go back to the shiny editor.
Martin
I'm suspicious...

PS I hate cricket, don't really like the English and I still find the cricket funny
PPS Belinda Snell??? You've got weird tastes dude

- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rule Editor converting "£" to "?"
I didn't write the bit about the consolidations either. I'm guessing the database has gone a bit funny.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule Editor converting "£" to "?"
Something a bit more prosaic, I'm afraid; the Moderator log shows that Martin inadvertently edited your post. I'd guess that he hit the [Edit] button when he meant to hit the Quote button. (This is the down side to the "one ring" that is Admin rights; I've done the same thing myself in the past, then muttered and swore as I reconstructed the original post from the e-mail copies.)jim wood wrote:I didn't write the bit about the consolidations either. I'm guessing the database has gone a bit funny.
I smell cookies! Specifically, I've been having that a bit myself recently but I know why it is; I recently had to log into the Forum on a "foreign" computer so I changed my password afterwards. The cookies on my own computers kept trying to log me in with the old password. The notebook just did it when I went to log into the Administrator Control Panel (for which it apparently keeps a separate login record). Might be time to do a cookie purge on your browser if the password doesn't "stick".garry cook wrote: Impostor-tastic! I didn't write that (indeed, the problem I'm dealing with isn't even mine and refers to an element name with £ in it rather than GBP - yuck), Jim's signed off as Martin and my account had exceeded no of logon attempts when I went to reply to this forum when I've had no sign on issues recently
I'm suspicious...![]()
She's hot! Athletic, tall, long, dark hair, did I mention athletic? The only downside is that she doesn't like flying. Hey, I like what I like!garry cook wrote: PPS Belinda Snell??? You've got weird tastes dude

(Although it may be politic to mention that rather shorter with long dark hair is working for me at the moment. I'm not as unconcerned as Jim is about whether my posts are looked up by significant others.

"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Rule Editor converting "£" to "?"
Ah right, I wondered why there was no red star on the icon of this post on the listings page.
I did indeed make that post about weightings. Sorry Jim. And thanks for looking at the logs Alan, I immediately assumed a screwy database too.
I did indeed make that post about weightings. Sorry Jim. And thanks for looking at the logs Alan, I immediately assumed a screwy database too.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer