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
Sparce cubes with rules
-
schlemiel29
- Posts: 65
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
-
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
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
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
www.infocat.co.uk