TI process does not pick non fed leaf level cells

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

TI process does not pick non fed leaf level cells

Post by mnasra »

Hi Experts,
I have a measure C = A - B (A is static during the day) B is where Users enter their numbers
C is used ONLY to capture where the user has changes during the day. ( I don't need C to be fed)

I created a TI process that reads C to update A (when needed).
The TI does not EXTRACT non fed leaf level cells. Is that normal?
In my extract, I obviously have:
ViewextractskipZeroesSet to 1 (to exclude the zeroes).

Thank you
Thanks
Micheline
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TI process does not pick non fed leaf level cells

Post by declanr »

If you want a TI to read rule calculated cells from the data source you would need to set ViewExtractSkipRuleValuesSet to 0.
Declan Rodger
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: TI process does not pick non fed leaf level cells

Post by David Usherwood »

If you suppress zeroes then yes, unfed cells will be skipped.
Suggest you do C = A - B as a subtraction hierarchy which will not need feeding - although it would not then be N level.
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: TI process does not pick non fed leaf level cells

Post by mnasra »

Thank you so much both Declan and David. Yes Declan I had the rules to be picked up, but it was not doing it.
But I will definitely take David's idea of a hierarchy.
Thank you so much
Thanks
Micheline
Post Reply