Hi,
The below three statements populate the measure in a TM1 cube with either a 1 if it is the 15th of the month, or a 0 if it isn't.
However Rule 1, populates 11 of the 12 months, Rule 2 populates 4 of the 12 months and rule 3 doesn't populate any of the months..... I have inherited this cube from another developer and cannot figure out for the life of me where the set up is limiting the population as the rules are identical!
All dimension Elements have been set up as Simple with 1 as the weight.
The Elcomp statement just returns the 15th of every month in a format the cube recognizes - ;2018-01-15'
['Actual Margin'] = N:IF(!Days @= ELCOMP('Days', AttrS('Days', !Days, 'Cal Month'), 15), 1, STET); ##Rule 1
['Loaded Margin'] = N:IF(!Days @= ELCOMP('Days', AttrS('Days', !Days, 'Cal Month'), 15), 1, STET); ##Rule 2
[Loaded Margin_TEST'] = N:IF(!Days @= ELCOMP('Days', AttrS('Days', !Days, 'Cal Month'), 15), 1, STET); ##Rule 3
There must be something strange with the dimensions or something as when I replace the formulas as below only the same months are populated.... :
[Actual Margin'] = N:IF(!Days @= ELCOMP('Days', AttrS('Days', !Days, 'Cal Month'), 15), 1, STET);
[Loaded Margin'] = N:5;
[Margin_TEST'] = N:5;
Would really appreciate if anyone can help me understand this, I cannot find where Tm1 is blocking the cell from being populated.
Thanks
Nashco
Rule Not Working for Certain Cells
-
- MVP
- Posts: 3103
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Rule Not Working for Certain Cells
Hello,
Are there other rules in the rules editor above the rules you show here ?
If yes, these rules would take precedence over the rules that you show.
Are there other rules in the rules editor above the rules you show here ?
If yes, these rules would take precedence over the rules that you show.
Best regards,
Wim Gielis
IBM Champion 2024
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
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