Can someone please explain the following behavior...
Please see 4 attachments:
"this works.jpg' for the rules
"this works_cube.jpg' for the cube view
"this does not work.jpg' for the rules
"this does not work_cube.jpg' for the cube view
I have no clue...
I only restrict the second rule to 1 element, and it has an effect on a different area?
A and B are String elements, all other elements are Simple. But the third dimension in the cube (not visible on the screenshots) is the }Processes dimensions where elements seem to be "ab"-type of elements. Not sure if this is the culprit.
Does it ring a bell?
Strange string rules in a cube
-
- MVP
- Posts: 3241
- 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:
Strange string rules in a cube
- Attachments
-
- this does not work.JPG (13.64 KiB) Viewed 2867 times
-
- this works.JPG (11.12 KiB) Viewed 2867 times
Last edited by Wim Gielis on Wed Mar 26, 2014 9:29 pm, edited 1 time in total.
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
-
- MVP
- Posts: 3241
- 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: Strange string rules in a cube
What is going on with measure 'A' in the 'this does not work'-case?
The cells are white and can receive input (some kind of STET ?)
2 other screenshots:
The cells are white and can receive input (some kind of STET ?)
2 other screenshots:
- Attachments
-
- this does not work_cube.JPG (12.83 KiB) Viewed 2867 times
-
- this works_cube.JPG (12.33 KiB) Viewed 2867 times
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
-
- MVP
- Posts: 3241
- 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: Strange string rules in a cube
I'm still investigating, so don't spend too much time on it now, unless you want to 

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
-
- MVP
- Posts: 3241
- 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: Strange string rules in a cube
I don't see it 
I got rid of the }Processes dimension and used a regular dimension (a mirror copy of the }Processes dimension). Still no luck.
Tomorrow hopefully more luck

I got rid of the }Processes dimension and used a regular dimension (a mirror copy of the }Processes dimension). Still no luck.
Tomorrow hopefully more luck

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
-
- MVP
- Posts: 3241
- 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: Strange string rules in a cube
Rebooting the TM1 server (model) shows me the correct results.
I'm still looking at what is causing this.
I'm still looking at what is causing this.
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
-
- MVP
- Posts: 3241
- 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: Strange string rules in a cube
Hello
After using the function DimensionUpdateDirect in the Epilog tab, it all works fine...
Losing 2 evenings over this 1 function!
Anyway, it's solved
After using the function DimensionUpdateDirect in the Epilog tab, it all works fine...
Losing 2 evenings over this 1 function!
Anyway, it's solved

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