Strange string rules in a cube

Post Reply
Wim Gielis
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

Post by Wim Gielis »

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?
Attachments
this does not work.JPG
this does not work.JPG (13.64 KiB) Viewed 2867 times
this works.JPG
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
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

Post by Wim Gielis »

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:
Attachments
this does not work_cube.JPG
this does not work_cube.JPG (12.83 KiB) Viewed 2867 times
this works_cube.JPG
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
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

Post by Wim Gielis »

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

Post by Wim Gielis »

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

Post by Wim Gielis »

Rebooting the TM1 server (model) shows me the correct results.
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
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

Post by Wim Gielis »

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