Does the dimension already exist ?

Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Does the dimension already exist ?

Post by Wim Gielis »

Who can explain the below result ? The text file is the one generated by the TI process.
05.png
05.png (26.29 KiB) Viewed 3441 times
Best regards,

Wim Gielis

IBM Champion 2024
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
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Does the dimension already exist ?

Post by Alan Kirk »

Wim Gielis wrote: Fri Apr 09, 2021 8:14 pm Who can explain the below result ? The text file is the one generated by the TI process.
I can't access TM1 at the moment, but my best guess would be either:
(a) A new dimension that has been registered in memory, but the system hasn't updated the control dimension yet (or it has updated a copy but hasn't committed it, in the way that dims are updated in the classic API); or the other way around
(b) A deleted dimension that has been removed from the control dimension, but hasn't been released from memory yet. We know that TM1 is something of a memory hoarder with garbage memory.

Unfortunately I can't test this at the moment, but those are the only things that make sense.
"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.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Does the dimension already exist ?

Post by Wim Gielis »

Hi Alan,

I can reproduce it with restarting the model, the entire laptop, ...

In fact, I know what is the reason but I thought: hmmm, maybe my Dimix() test isn't so fool-proof.
What we observe is valid and correctly working functionality that can be used in a TM1 model, which leads to the actual behavior.

Which is not to say that your reasons cannot lead to the same behavior of course.
Best regards,

Wim Gielis

IBM Champion 2024
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
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Does the dimension already exist ?

Post by Alan Kirk »

Wim Gielis wrote: Fri Apr 09, 2021 8:47 pm In fact, I know what is the reason but I thought: hmmm, maybe my Dimix() test isn't so fool-proof.
What we observe is valid and correctly working functionality that can be used in a TM1 model, which leads to the actual behavior.
You know that you haven't actually said "what the reason is" there? :?
"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.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Does the dimension already exist ?

Post by Wim Gielis »

Alan Kirk wrote: Fri Apr 09, 2021 8:55 pmYou know that you haven't actually said "what the reason is" there? :?
Well, I had to search for it couple of minutes, to understand what was going on. But yes, I found the / one of the reasons
You also pointed out other plausible reasons. I wanted to see what others would think and to stress that for example DimensionExists is safer than Dimix to the }Clients dimension.
Best regards,

Wim Gielis

IBM Champion 2024
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
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Does the dimension already exist ?

Post by Wim Gielis »

If a TM1 model needs to be made multi-language, it can be done with a Caption:
05.png
05.png (20.52 KiB) Viewed 3422 times
Cubes, dimensions, elements, views, subsets, processes, chores, ... can be made multi-language.

Too bad this does not work !

Code: Select all

DimensionElementPrincipalName( '}Clients', 'Measure' )
It gives back 'Measure' instead of Msr.
Best regards,

Wim Gielis

IBM Champion 2024
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
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Does the dimension already exist ?

Post by Alan Kirk »

Wim Gielis wrote: Fri Apr 09, 2021 9:39 pm If a TM1 model needs to be made multi-language, it can be done with a Caption:
Aaaah, I see! :D

That's kind of an "edge case" for most users (Swiss and Canadians being the most likely exceptions), but still very useful to know.
"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.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Does the dimension already exist ?

Post by Wim Gielis »

What about Belgium with 3 official languages (Dutch, French, German), even not including English ? 😉
Best regards,

Wim Gielis

IBM Champion 2024
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
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Does the dimension already exist ?

Post by Alan Kirk »

Wim Gielis wrote: Sat Apr 10, 2021 9:20 am What about Belgium with 3 official languages (Dutch, French, German), even not including English ? 😉
Pah, only three? Switzerland has four official languages; German, French, Italian and Romansch. They have an easy way of dealing with it though:
  • The entire population (aside from about 20 people in a village somewhere out east) pretends that Romansch doesn't exist. (It's the only one that doesn't even appear on the side of trains);
  • West of the Röstigraben they pretend that German doesn't exist;
  • East of it they pretend that French doesn't exist;
  • Anywhere north of the first mountain the only ones who can speak Italian are me and Commissario Montalbano reruns;
  • When anyone wants to speak to anyone outside of their own cultural area they just use English.
When I had to buy a SIM card in Zurich back in 2016 I apologised (in German) that my appallingly rusty German wasn't very good and asked the sales guy whether he spoke either Italian or English. (In that order, because of Italian's status as an "official" language.) "Ja, ja, Englisch!", he replied.

"Naturalmente inglese...", I thought to myself.

Next time I'll go equipped with an appropriately aliased TM1 model on my notebook.

(I suppose that I could use Google Translate instead... though while that's OK for jogging your memory it's perilous to rely on it for primary translation. Such is the level of reliability of that stunning piece of AI coding, you have a better than average chance of asking a shop owner to marry his goat when you actually go in to buy 300 grams of cheese.) :shock:
"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
PavoGa
MVP
Posts: 616
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: Does the dimension already exist ?

Post by PavoGa »

Wim Gielis wrote: Fri Apr 09, 2021 8:14 pm Who can explain the below result ? The text file is the one generated by the TI process.

05.png
Have not used the multi-language functionality (Southern English, aka: The Way God Himself Talks, is avoided in my naming conventions to avoid things like whirly-gig processes, hog waller cubes, shotgun dimensions, etc.). :shock:

However, is it because the caption is defined as text, not an alias?
Ty
Cleveland, TN
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Does the dimension already exist ?

Post by Wim Gielis »

Hello Ty,

While not definitive proof, I am almost certain Caption is an Alias here. I found back this part in a TI process of some time back:
05.png
05.png (37.07 KiB) Viewed 3346 times
Best regards,

Wim Gielis

IBM Champion 2024
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
Post Reply