Sparce cubes with rules
Posted: Wed Oct 30, 2024 2:30 pm
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
[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