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
TI process does not pick non fed leaf level cells
-
- 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
Thanks
Micheline
Micheline
-
- 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
If you want a TI to read rule calculated cells from the data source you would need to set ViewExtractSkipRuleValuesSet to 0.
Declan Rodger
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: TI process does not pick non fed leaf level cells
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.
Suggest you do C = A - B as a subtraction hierarchy which will not need feeding - although it would not then be N level.
-
- 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
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
But I will definitely take David's idea of a hierarchy.
Thank you so much
Thanks
Micheline
Micheline