Hi
Does anyone know of a way to conditionally prevent a DBRW cell from performing it's calculation? I've got a lot of TM1 formulae in my workbook and it takes an age to reload. Depending on the data, a lot of these cells don't actually need to be loaded and can be skipped.
I think wrapping inside an =IF formula would still perform the calculation in the background regardless of the condition, and so still chew up resource. I thought about zeroing one of the dimension values the formula looks at so it would result in a #VALUE! error, though I'm not sure whether TM1 is expending much resource when calculating this.
Running a macro to turn TM1 formulae into values also seems to take a long time to run and causes Excel to sometimes crash, so if anyone has any good workarounds that would be greatly appreciated!
Prevent calculation of TM1 cells
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Prevent calculation of TM1 cells
Every calculation to decide if you have to do a DBRW is itself a calculation. And a DBRW only reads the data from the Cube (and writes it if you make changes to this cell). All calculations for the cell is done regardless you read the cell or not.
It seems to me that you have to think about the design of the model. Do you use SKIPCHECK and FEEDERS. Do you have overfeeding. Are you using only DBRW or do you mix with DBR. Do you use Starviews. ...
It seems to me that you have to think about the design of the model. Do you use SKIPCHECK and FEEDERS. Do you have overfeeding. Are you using only DBRW or do you mix with DBR. Do you use Starviews. ...
-
- Posts: 13
- Joined: Mon Sep 26, 2016 9:59 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2010
Re: Prevent calculation of TM1 cells
Yeah I was worried that might be the case. I was hoping to avoid reading from the cube if a certain condition was satisifed, as the local calculations in Excel are much faster than the TM1 ones.
I'm not familiar with SKIPCHECK and FEEDERS / Starview/ DBR, I only really use TM1 as a basic end user, though I'll read up on this.
-
- MVP
- Posts: 2832
- 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: Prevent calculation of TM1 cells
The answer to that question is no so what you need to do is go back to the drawing board and look at why you think you need DBRW formulas in a workbook in the first place that don't need evaluation. Perhaps having a kitchen sink workbook is not the best design. Maybe use an Active Form workbook?