Dimix with non-existing dimension

Suggest and discuss enhancements for TM1
Post Reply
Wim Gielis
MVP
Posts: 3103
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:

Dimix with non-existing dimension

Post by Wim Gielis »

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 ?
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
jim wood
Site Admin
Posts: 3951
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

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Wim Gielis
MVP
Posts: 3103
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: Dimix with non-existing dimension

Post by Wim Gielis »

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
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