Sparce cubes with rules

Post Reply
schlemiel29
Posts: 64
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

Sparce cubes with rules

Post 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
User avatar
Steve Rowe
Site Admin
Posts: 2444
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Sparce cubes with rules

Post 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
Technical Director
www.infocat.co.uk
Post Reply