Dimix with Control Dimension

Post Reply
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:

Dimix with Control Dimension

Post by jim wood »

Guys,

I'm doing a simple check to see if the name a of a process being passed to my process is valid. I'm using dimix to do so:

Code: Select all

vCheck=IF(Dimix('}Processes',vProcessName)=0,0,1);
Even when I pass the process a valid process name dimix returns 0. Does anybody know if there is an issue with using dimix on control dimensions like this? I've never seen dimix do this in the past,

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
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Dimix with Control Dimension

Post by declanr »

Jim,

I have also come across this in the past and (although I didn't dig into it) I just assumed it to be standard for all } objects.

It was the same for DIMNM and DIMIX.
To get around it I just had a TI run every night that created a duplicate of the }dimension and named it zProcesses etc.

Cheers,
Declan
Declan Rodger
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 Control Dimension

Post by jim wood »

A damn fine plan. I'll include a dimension build within my process to make sure it's up to date just before the dimix check is completed. It would still be interesting to see why dimix doesn't work with control dimensions,

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
mberson
Posts: 30
Joined: Tue Jun 07, 2011 8:30 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Dimix with Control Dimension

Post by mberson »

Sounds like you have your solution.

FYI - I just tried this in version 10.1 and couldn't reproduce. Tried a variety of different scenarios with security and couldn't find a combination that caused the outcome that you had.

What version are you using?
Matthew Berson
ACG TM1 Consulting
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 Control Dimension

Post by jim wood »

I'm using 9.5.2. Now I've hit a different problem. It doesn't seem like me creating a subset on the said }Processes dimension. Has anybody else encountered this? I may have to resort to putting a dynamic MDX subest on the said dimension. Can you hear me shuddering??? :twisted:
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
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Dimix with Control Dimension

Post by tomok »

jim wood wrote:I'm using 9.5.2. Now I've hit a different problem. It doesn't seem like me creating a subset on the said }Processes dimension.
I just fired up 9.5.2 and had no problem creating a subset on the }Processes dimension.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Dimix with Control Dimension

Post by declanr »

After reading the subsequent posts I got intrigued and tested this myself.

Although I definitely remember experiencing the DIMIX and DIMNM failing on }processes dimension at some point a few years ago.
I just tried to recreate in V10.1 and it works perfectly fine in both the TI formula and the Excel formula version of DIMIX. Sadly I can't remember exactly what server etc I was working on when I did experience the issue you mentioned but I think it was in 9.5.1

Never had issues with the subset side of things as far as I remember though.
Declan Rodger
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 Control Dimension

Post by jim wood »

I didn't think it should be a problem that's why I suprised by it. Things are acting very strange with the process I have created tbh. I think I'm going to restart TM1 to see if it makes a difference. If it doesn't my laptop will be making a trip out of the window!!!!
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
Post Reply