Feeder Issue

[amritha.tm1]

Hi All,

When i am trying to copy the data from one version to another using TI Process ...I am able to copy data only for input cells but not for derived cells.

I have defined the VIEWEXTRACTSKIPRULEVALUESSET =1 and CellIsUpdateable(Cube, e1, e2 [,...en]) in the TI but still i could not copy or export the data for the derived cells.

Rules for that cube:

Feedstrings;
SKipcheck;

['A','B','Current Version']=S: IF(Dimix('Entity', ATTRS('Geography',!Geography, 'MC')|ATTRS('Entity', !Entity, 'Code')) =0, STET, ATTRS('Geography',!Geograph, 'MC')|ATTRS('Entity', !Entity, 'Code'));

['C', 'Current Version'] = S: IF(DIMIX('Entity',DB('PL',!Geography,!Entity,!Account,!Version,'A'))=0,'No','Yes');

['D','Current Version']= S:IF(DIMIX('Entity',DB('PL',!Geography,!Entity,!Account,!Version,'E'))<>0,DB('PL',!Geography,!Entity,!Account,!Version,'E'),STET);


Am i missing anything any here?

Can any let me know ...where is the issue.

[David Usherwood]

Looks to me as if you have no feeder statements. Entering Feedstrings doesn't obviate the need to have them.

[asutcliffe]

Hi All,

When i am trying to copy the data from one version to another using TI Process ...I am able to copy data only for input cells but not for derived cells.

I have defined the VIEWEXTRACTSKIPRULEVALUESSET =1 and CellIsUpdateable(Cube, e1, e2 [,...en]) in the TI but still i could not copy or export the data for the derived cells.

If you want to copy the rule derived values, why are you setting VIEWEXTRACTSKIPRULEVALUESSET to 1? This will exclude them from your source view.

[amritha.tm1]

I have tried now with 0 ...even then its not copying the rule derived cells or exporting the values for rule driven cells.

Do, i need to have a feeder for these rules...If so what feeder statements do i need to have?

Thanks for the immediate response and for your time.

[mvaspal]

Hi

If the cells you try to copy are rule derived but not fed, they will considered as zeroes when the view extract is calculated, so you will have to write the feeders.

[amritha.tm1]

Hi,

I am a newbie...not sure what feeders i need to write.

['A','B','Current Version']=S: IF(Dimix('Entity', ATTRS('Geography',!Geography, 'MC')|ATTRS('Entity', !Entity, 'Code')) =0, STET, ATTRS('Geography',!Geograph, 'MC')|ATTRS('Entity', !Entity, 'Code'));

['C', 'Current Version'] = S: IF(DIMIX('Entity',DB('PL',!Geography,!Entity,!Account,!Version,'A'))=0,'No','Yes');

Can anyone help me with some example for above rules....

Thanks in advance!

[tomok]

I'm not exactly sure what you are expecting those rules to do but what they are actually doing is putting a string value consisting of the concatenated MC attribute of the Entity dimension and the Code attribute of the Entity dimension into Current Version for A and B(????) and a string value consisting of either Yes or No into Current Version for C. Are these string values the "Data" you are talking about? No apparent feedable possibilities I can see from the limited info you have provided. Is there any actual data in this cube somewhere?

[amritha.tm1]

Hi Tomok,

Its just a Lookup cube ...

1 rule statement Populating the Concatenation of Geo+ Entity code for A&B Cells
2. Checking if that value exist in the Report dimension ...if exists say 'Yes' or 'No' for C

Thanks in Advance

[tomok]

Its just a Lookup cube ...

Then why would you need a zero-suppressed view of it? Wouldn't the data source for your TI process be a zero-suppressed view of the actual cube where the data you are trying to copy is??????