We have users trying to perform slices on different cubes, and TM1 just sits there churning. Has anyone run into this and could possibly point me in the right direction towards a solution?
We are running TM1 9.1.4.
Thanks in advance!
Slices not working
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Slices not working
How many rows and columns are in the slice? Do you have the slice zero-suppressed? How high up in the hierarchy are the slices? Are there a lot of rules in the cube being sliced? All these can affect slicing performance. I recommend trimming down the number of rows to arround 100 or so to see if that helps. If it does then you can bump it up 100 at a time until you find out what the breaking point is.nmiller wrote:We have users trying to perform slices on different cubes, and TM1 just sits there churning. Has anyone run into this and could possibly point me in the right direction towards a solution?
We are running TM1 9.1.4.
Thanks in advance!
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Slices not working
In their Excel Options (Advanced => General) have you checked that the Ignore Other Applications box is NOT checked?nmiller wrote:We have users trying to perform slices on different cubes, and TM1 just sits there churning. Has anyone run into this and could possibly point me in the right direction towards a solution?
We are running TM1 9.1.4.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
nmiller
- Posts: 18
- Joined: Tue Jul 02, 2013 1:32 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2010
Re: Slices not working
Alan,
That box is not checked.
That box is not checked.