Does the dimension already exist ?
-
- MVP
- Posts: 3120
- 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 ?
Who can explain the below result ? The text file is the one generated by the TI process.
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
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
- 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 ?
I can't access TM1 at the moment, but my best guess would be either: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.
(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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3120
- 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 ?
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.
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
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
- 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 ?
You know that you haven't actually said "what the reason is" there?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.
"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.
-
- MVP
- Posts: 3120
- 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 ?
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
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
-
- MVP
- Posts: 3120
- 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 ?
If a TM1 model needs to be made multi-language, it can be done with a Caption:
Cubes, dimensions, elements, views, subsets, processes, chores, ... can be made multi-language.
Too bad this does not work !
It gives back 'Measure' instead of Msr.
Cubes, dimensions, elements, views, subsets, processes, chores, ... can be made multi-language.
Too bad this does not work !
Code: Select all
DimensionElementPrincipalName( '}Clients', 'Measure' )
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
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
- 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 ?
Aaaah, I see!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:
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3120
- 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 ?
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
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
- 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 ?
Pah, only three? Switzerland has four official languages; German, French, Italian and Romansch. They have an easy way of dealing with it though:Wim Gielis wrote: ↑Sat Apr 10, 2021 9:20 am What about Belgium with 3 official languages (Dutch, French, German), even not including English ?
- 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.
"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.)
"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.
- PavoGa
- MVP
- Posts: 617
- 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 ?
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.).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
However, is it because the caption is defined as text, not an alias?
Ty
Cleveland, TN
Cleveland, TN
-
- MVP
- Posts: 3120
- 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 ?
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:
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:
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
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