Page 1 of 1

Sparce cubes with rules

Posted: Wed Oct 30, 2024 2:30 pm
by schlemiel29
I have several cubes with very limited data on a very large number of elements. So there is an information, how much output of a product (# > 10.000) can a specific maschine (# > 5.000) produce in one time period.
[Maschine][Product] <> 0 is only set for 1 or 2 products.
Then I have costs per maschine per time period in another cube and number of needed products in a third one. So I have to multiply all three cubes, but the first cube is very sparce.

Is there a good recommendation for improving performance when using a rule?
Thanks in advance
Dirk

Re: Sparce cubes with rules

Posted: Wed Nov 06, 2024 3:43 pm
by Steve Rowe
Hi Dirk,

The standard practice here would be to
A. Make sure you have written a Feeder statement, this would be in the sparse cube pointing at wherever the rules is.
B. Make sure you have skipcheck on where the rule is.

Can't say much more than that without more detail