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,
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.
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,
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.
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???
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.
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!!!!