Hello all
I have set up the full Fishcakes International model that you find in the Rules guide, using the rules in the guide. In the Production cube on any given day, the Production Costs/Kg are equal for all fishcakes. Is this normal?
As fishcakes are made up of different fish types with different costs per kg, that seems very strange. Did someone have this as well? I tested with a production of 100 kg Poseidon's Platter and 50 kg of Ancient Mariner on January 31. Production Costs/Kg is $121,38 in both cases. For other numbers, cost/kg are equal too.
Also, I noticed that some of the screenshots in the guide wrong (e.g. the Inventory cube screenshot on page 113). True?
Wim
Fishcakes Int. Rules guide model
-
- MVP
- Posts: 3223
- 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:
Fishcakes Int. Rules guide model
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
-
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Fishcakes Int. Rules guide model
Wim,
I wouldn't rely on the docs. There are mistakes in it. For example in tm1_rules_guide_en_9_4.pdf
regarding the order of rules it says on p. 229:
"Recall that rules statements should always be ordered most-restrictive to least-restrictive according to area definition."
and on p.132 of tm1_developers_guide_en_9_4.pdf it says:
"If you have multiple rules statements that address the same area, you should order them least-restrictive to most-restrictive."
So fish is fish...
Cheers,
Marcus
I wouldn't rely on the docs. There are mistakes in it. For example in tm1_rules_guide_en_9_4.pdf
regarding the order of rules it says on p. 229:
"Recall that rules statements should always be ordered most-restrictive to least-restrictive according to area definition."
and on p.132 of tm1_developers_guide_en_9_4.pdf it says:
"If you have multiple rules statements that address the same area, you should order them least-restrictive to most-restrictive."
So fish is fish...
Cheers,
Marcus
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Fishcakes Int. Rules guide model
That is so obviously hogwash that I just had to satisfy my curiosity and go check and golly you are right. In the 9.4 MR1 developers guide I found this exact same and obviously wrong statement (on p61. in Chapter 3: Advanced Calculations for Business Data.)Marcus Scherer wrote:...and on p.132 of tm1_developers_guide_en_9_4.pdf it says:
"If you have multiple rules statements that address the same area, you should order them least-restrictive to most-restrictive."
At least in the rules guide in 9.4 MR1 they got it right "Note how the rule for ['6','Required'] comes before the rule for ['Required']. This is in keeping with the practice of placing rules statements in order from most-restrictive area definition to least-restrictive area definition." (very fittingly on p. 101)
Not sure what's up with the discrepancy in page numbers of the pdf guides between 9.4 and 9.4.1 ...
-
- MVP
- Posts: 3223
- 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: Fishcakes Int. Rules guide model
Thanks for the replies.
I retain from this that the rules guide is not free of errors
With regards to the outcome of the Fishcakes model, I think it's inherent in the model that average costs/kg should be equal, but I don't have a formal reason other than that.
Wim
I retain from this that the rules guide is not free of errors

With regards to the outcome of the Fishcakes model, I think it's inherent in the model that average costs/kg should be equal, but I don't have a formal reason other than that.
Wim
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