Fishcakes Int. Rules guide model

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

Post by Wim Gielis »

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

Post by Marcus Scherer »

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

Post by lotsaram »

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."
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.)

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 ...
Wim Gielis
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

Post by Wim Gielis »

Thanks for the replies.

I retain from this that the rules guide is not free of errors :D

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