Rule taking more time to load the cube view

[Analytics123]

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 .

[tomok]

This rule is taking more time to open the 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.

[Wim Gielis]

Ending Balance is a consolidation, or rule-based ?

[Analytics123]

Actually the Ending balance is consolidation . I think I am doing some thing wrong here . Let me reexplain the scenario with example .

[Wim Gielis]

Okay thanks

Also can we see the daisy-chaining of periods ?