Hello,
What do you think ?
I misspelled a dimension name lately in a TI process.
I used the wrong dimension name in a Dimix formula, to check in the metadata tab whether an element is new or not. The Dimix gives 0 as the result. Wouldn't it be an enhancement if it gave an error rather than 0, for dimensions that do not exist ?
Dimix with non-existing dimension
-
- MVP
- Posts: 3237
- 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:
Dimix with non-existing dimension
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
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
- jim wood
- Site Admin
- Posts: 3960
- 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: Dimix with non-existing dimension
I'm not sure they'd go for this, after all you can combine it with DimensionExists. I guess you could argue that any of the statements that involve TM1 object checks should have something built in that would react in this kind of way? I wonder if the new coming development interface will cover this?
Jim.
Jim.
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
-
- MVP
- Posts: 3237
- 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: Dimix with non-existing dimension
Hi Jim,
It would be quite a change (also in other clients next to TI ) and I am also rather confident that IBM won't do this.
Wim
It would be quite a change (also in other clients next to TI ) and I am also rather confident that IBM won't do this.
Wim
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
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