Hello,
I have an element in a cube whose value is defined by a rule. The rule just uses DIMIX to check for the existence of an element in a dimension.
The rule works correctly for the most part but does not change its value when the dimension is updated to include an element that was previously missing. If I open the rule, change and save it then it will update with the correct information.
Am I doing something wrong?
Thanks in advance.
Rule using DIMIX doesn't update
-
- MVP
- Posts: 2836
- 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: Rule using DIMIX doesn't update
Yes. You've ignored the Request for Assistance Guidelines. How do you expect anyone to be able to help you without more information? You can start with the code for the rule and make sure to include the feeders.glittle wrote:Am I doing something wrong?
-
- Posts: 42
- Joined: Fri Apr 19, 2013 7:07 pm
- OLAP Product: TM1
- Version: 10.1 RP1 FP1
- Excel Version: 2003 SP3
Re: Rule using DIMIX doesn't update
It sounds like updating the referenced dimension isn't invalidating the cache of the cube. IBM is missing a necessary dependency. Try a less heavy handed (than rule recompilation) invalidation of the cube (edit a cell) to see if that too clears out the old value.