Tm1 Rules for string element

Post Reply
sairajsoma
Posts: 6
Joined: Wed Nov 06, 2024 2:55 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 10

Tm1 Rules for string element

Post by sairajsoma »

We can write N: right instead of S : for string element 'comment'
Attachments
Screenshot_2025-02-14-14-06-05-72_f9ee0578fe1cc94de7482bd41accb329.jpg
Screenshot_2025-02-14-14-06-05-72_f9ee0578fe1cc94de7482bd41accb329.jpg (359.97 KiB) Viewed 15236 times
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Tm1 Rules for string element

Post by lotsaram »

sairajsoma wrote: Fri Feb 14, 2025 8:39 am We can write N: right instead of S : for string element 'comment'
So is that a question?
Or a statement of fact?
Do you have an issue with writing a string rule?

You can use N: it won't be a syntax error, but it also won't do anything! If you want to assign a string value to a rule calculated cell, then you must use the S: qualifier (and the cells in question defined by the area statement must in fact be string cells! Which means the element type of the last dimension must be S.) Oh, and don't feed string rules! Feeding is for consolidation. As text doesn't consolidate there is really no reason to feed a string rule, this just wastes memory and increases compute time.

As of now I'm confused what you actually want to ask.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3222
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Tm1 Rules for string element

Post by Wim Gielis »

sairajsoma wrote: Fri Feb 14, 2025 8:39 am We can write N: right instead of S : for string element 'comment'
Can you please write a proper question ?

Are you still working on the rules of November 2024 ?
viewtopic.php?t=16787
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
sairajsoma
Posts: 6
Joined: Wed Nov 06, 2024 2:55 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 10

Re: Tm1 Rules for string element

Post by sairajsoma »

okay got it. this was the full ques actually. thansks!!
Attachments
Screenshot 2025-02-15 194427.png
Screenshot 2025-02-15 194427.png (197.4 KiB) Viewed 13414 times
Adam
Posts: 122
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Microsoft 365 x64

Re: Tm1 Rules for string element

Post by Adam »

With threads like these, no wonder ChatGPT is suggesting CubeNext();
I've started blogging about TM1, check it out: www.havaslabs.com

Take care,
Adam
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Tm1 Rules for string element

Post by lotsaram »

Wim Gielis wrote: Fri Feb 14, 2025 5:16 pm
sairajsoma wrote: Fri Feb 14, 2025 8:39 am We can write N: right instead of S : for string element 'comment'
Can you please write a proper question ?
So Wim made a very reasonable request since your question made little, if any sense.
sairajsoma wrote: Sat Feb 15, 2025 2:19 pm okay got it. this was the full ques actually. thanks!!
And you responded with something completely irrelevant making even less sense than the 1st "question."

I don't think it's even worth directing you to the request for assistance guidelines. Some people can't be helped.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
PavoGa
MVP
Posts: 622
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Tm1 Rules for string element

Post by PavoGa »

lotsaram wrote: Mon Feb 17, 2025 10:49 am
Wim Gielis wrote: Fri Feb 14, 2025 5:16 pm
sairajsoma wrote: Fri Feb 14, 2025 8:39 am We can write N: right instead of S : for string element 'comment'
Can you please write a proper question ?
So Wim made a very reasonable request since your question made little, if any sense.
sairajsoma wrote: Sat Feb 15, 2025 2:19 pm okay got it. this was the full ques actually. thanks!!
And you responded with something completely irrelevant making even less sense than the 1st "question."

I don't think it's even worth directing you to the request for assistance guidelines. Some people can't be helped.
Man, I've missed checking the Forum on a regular basis. :lol:
Ty
Cleveland, TN
Post Reply