Rule Editor converting "£" to "?"

User avatar
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 "?"

Post by garry cook »

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
User avatar
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 "?"

Post by jim wood »

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
User avatar
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 "?"

Post by stephen waters »

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.
I think this is a "feature" not a bug since the "Advanced" rules editor does not support the extended character set including £ sign.

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.
User avatar
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 "?"

Post by garry cook »

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.
User avatar
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 "?"

Post by garry cook »

And thanks too Steve.

Super speedy response btw - you guys sitting hitting F5 constantly or just lucky with the timing? ;)
User avatar
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 "?"

Post by jim wood »

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.
Apologies, I forgot that TM1 is the most feature rich bit of kit out there!! :shock:
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
ParisHilton
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 "?"

Post by ParisHilton »

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.
tomok
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 "?"

Post by tomok »

ParisHilton wrote:I'm curious , why would you need '£' in a rule?
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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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 "?"

Post by jim wood »

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
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
ParisHilton
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 "?"

Post by ParisHilton »

ah, that makes sense.

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.
Alan Kirk
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 "?"

Post by Alan Kirk »

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.
Well... either that or using those format-rich .xru files... ;)
"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.
User avatar
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 "?"

Post by stephen waters »

Hi Alan,
Surprised to see you posting, I thought you would be off watching the cricket ;-)
Alan Kirk
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 "?"

Post by Alan Kirk »

stephen waters wrote:Hi Alan,
Surprised to see you posting, I thought you would be off watching the cricket ;-)
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.
User avatar
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 "?"

Post by jim wood »

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..."
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.
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
Alan Kirk
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 "?"

Post by Alan Kirk »

jim wood wrote:
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..."
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.
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.
"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.
User avatar
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 "?"

Post by jim wood »

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
User avatar
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 "?"

Post by garry cook »

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

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 :shock:
User avatar
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 "?"

Post by jim wood »

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
Alan Kirk
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 "?"

Post by Alan Kirk »

jim wood wrote:I didn't write the bit about the consolidations either. I'm guessing the database has gone a bit funny.
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.)
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... ;)
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: PPS Belinda Snell??? You've got weird tastes dude :shock:
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! :D

(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. :lol: )
"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.
User avatar
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 "?"

Post by Martin Ryan »

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