By accident I just came to a finding that might be good to be aware of, especially in the context that there have been some posts wondering about difference between using CubeClearData and ViewZeroOut(here, here, here and here).
My finding is that CubeClearData does not only clear the data in the cube, it also clears feeder flags (which ViewZeroOut does not do).
So if your cube has some rules that are fed from other cubes, you need also to use the CubeProcessFeeders function for all cubes that feed your cube.
I tested it on 9.5.1 HF17 and 9.5.2 (probably no HF, but not sure).
CubeClearData removes feeder flags
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: CubeClearData removes feeder flags
Good find! Worth moving to "Useful code, tips and tricks"?
Kamil Arendt
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: CubeClearData removes feeder flags
I'm not sure at which here, here, here and here this might have been mentioned or whether it has been fixed now in one of the later 9.5.2 hot fixes but one thing to watch out for with CubeClearData is a bug related to the tendency for "spontaneous data regeneration" following a server restart. CubeClearData only clears the cube in memory and executing a SaveDataAll doesn't update the .cub file unless there has also been a data change subsequent to the CubeClearData either via direct entry or CellPutN. This is very different behavior from ViewZeroOut which doesn't suffer this problem.
This is a real watchout. If anyone can point to a technote on whether this is now fixed in a 9.5.2 HF (or 9.4.1 HF) and then which HF I for one would be grateful.
This is a real watchout. If anyone can point to a technote on whether this is now fixed in a 9.5.2 HF (or 9.4.1 HF) and then which HF I for one would be grateful.