Hi I have a dimension which has elements like
Beginning Balance , Ending Balance and All Movement Type.
Ending balance is the consolidation of Beginning balance and All Movement types .
Now there is a dimension called stock category which has values like Blank or in transit .
For intransit the cost is calculated at the time of load itself , but for blank category we have a rule to calculate the cost based on quantity .
And everymonth the values are carried over from Ending balance to Beginning balance of next month .
the rule I used to do the cost calculation is below , This rule is taking more time to open the view
['Ending Balance','Inventory Stock Category':'Blank','Total Extended Cost']= ['Total Qty on Hand','Inventory Stock Category':'Blank']* DB('Cost Sets' ,cost);
['Total Qty on Hand'] => ['Total Extended Cost'];
Any suggestions or if more detail is required please let me know .
Rule taking more time to load the cube view
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- MVP
- Posts: 2832
- 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 taking more time to load the cube view
At the risk of being a smart-aleck, what did you expect? The more calculations you add to a cube, the longer it's going to take to load. That's just the way it is and there is no way around it. Daisy-chaining periods together, like you are doing, is a very resource intensive rule. The more periods you bolt on to the future the slower it's going to get. The only thing I can offer to you is to break that link if you can by using TI to transfer the balances from period to period. I understand that if the system needs to calculate this stuff real-time that may not be an option.
-
- MVP
- Posts: 3117
- 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 taking more time to load the cube view
Ending Balance is a consolidation, or rule-based ?
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
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Rule taking more time to load the cube view
Actually the Ending balance is consolidation . I think I am doing some thing wrong here . Let me reexplain the scenario with example .
-
- MVP
- Posts: 3117
- 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 taking more time to load the cube view
Okay thanks
Also can we see the daisy-chaining of periods ?
Also can we see the daisy-chaining of periods ?
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