CubeClearData removes feeder flags

Post Reply
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

CubeClearData removes feeder flags

Post by jstrygner »

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).
User avatar
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

Post by qml »

Good find! Worth moving to "Useful code, tips and tricks"?
Kamil Arendt
lotsaram
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

Post by lotsaram »

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.
Post Reply