FeedStrings - Cannot feed cell ref with string

[shockwave]

hi guys,

Need some help. I am trying to keep some cells fed with a sting in a particular location ( screenshot below ).
The calculation appears to work, but when I go to try and feed the area i wish to feed when i suppress my zeros ( in the
cube viewer) the cells
are not kep open...which means that the cells are not being fed...I have tried feeding the cells using the "FEEDSTRINGS"
declaration ( where should i put this.. is it after FEEDERS??) instead of the "FEEDERS" declaration but it does not like it. Any reasons as to why this would not work?? The value in the cube is a string value deifined by a string measure called "au_ext_mirror"

Thanks again, Shock.

This is my simple rule code:

SKIPCHECK;

['2004']=STET;
['2005']=STET;
['2006']=STET;
['2007']=STET;
['2010']=STET;
['2011']=STET;
['2012']=STET;


['e2e_Allocation','Au_ext_Mirror']=S:
DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!year,'3','Au_ext_Mirror');

FEEDERS;
#FEEDSTRINGS; ### cannot get this to work ##


['3','Au_ext_Mirror']=>
DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!Year,'e2e_Allocation','Au_ext_Mirror');

Screenshot of cube:

cubescreenshot_wcomment.jpg (96.34 KiB) Viewed 10213 times

[nhavis]

Rule-generated string values are not displayed when a view is zero-suppressed unless the string resides in a cell that is fed.
To enable feeding of string cells, insert the FEEDSTRINGS declaration as the first line of your rule:
FEEDSTRINGS;

[shockwave]

RTFM - Thanks

[shockwave]

Thanks Mate,

Tried that, and inserted per manual:

"Feeders for string cells should be
inserted following the FEEDERS declaration in your rule"... BUT it didin't like it says there is some syntax error".....

SKIPCHECK;
['2004']=STET;
['2005']=STET;
['2006']=STET;
['2007']=STET;
['2010']=STET;
['2011']=STET;
['2012']=STET;
['e2e_Allocation','Au_ext_Mirror']=S:DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!year,'3','Au_ext_Mirror');

FEEDERS;
FEEDSTRINGS;
['3','Au_ext_Mirror']=>DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!year,'e2e_Allocation','Au_ext_Mirror');

[Michel Zijlema]

Hi,

Try inserting the FEEDSTRINGS statement as the first line in your rulessheet (so above SKIPCHECK).

From the manual:

To enable feeding of string cells, insert the FEEDSTRINGS declaration as the first line of your rule:
FEEDSTRINGS;

Michel

[shockwave]

Hi Michel,

Inserted in as the first line of code before "skipCheck", and the rule saved but did not feed the cells. I cant see where I might be going wrong. My rule appears correct, but maybe I am missing something. Will a reboot of the server make a difference? Just wanted to rule out whether my code was incorrect before I proceed.

Cheers

Shock

[Michel Zijlema]

SKIPCHECK;
['2004']=STET;
['2005']=STET;
['2006']=STET;
['2007']=STET;
['2010']=STET;
['2011']=STET;
['2012']=STET;
['e2e_Allocation','Au_ext_Mirror']=S:DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!year,'3','Au_ext_Mirror');

FEEDERS;
FEEDSTRINGS;
['3','Au_ext_Mirror']=>DB('CostCentre_Mapping',!CostCentre,
if(ELLEV('Month',!month)=0,dimNM('Month', DIMIX('Month', !Month)),Stet),
!year,'e2e_Allocation','Au_ext_Mirror');

Hi,

The STET inside of a DB reference looks somewhat odd to me.
I would rewrite the rule like (the if-check outside of the DB-reference):

['e2e_Allocation','Au_ext_Mirror']=S: If(ELLEV('Month',!month)=0,
DB('CostCentre_Mapping',!CostCentre,DimNM('Month', DIMIX('Month', !Month)),!year,'3','Au_ext_Mirror'),Stet);

And the (conditional) feeder:

['3','Au_ext_Mirror']=>DB(If(ELLEV('Month',!month)=0,'CostCentre_Mapping',''),!CostCentre,DimNM('Month', DIMIX('Month', !Month)),!year,'e2e_Allocation','Au_ext_Mirror');

Maybe these changes help?

Michel

[shockwave]

Hi Michel,

Thanks for your help all appears to be working now. Your code seems more logical than mine start out with your if statment and then continue through to next if. To get it to work i had to restart the server.

>Can you explain why this needs to happen? if you have a technical explanation then great.
>Should I reboo the server after each rule change?

This is extremely annoying. I keep doubting what I am doing when all appears rights, then a reboot of the server puts everything right.

Thanks again for you help.

Cheers

Shock

[Michel Zijlema]

To get it to work i had to restart the server.

>Can you explain why this needs to happen? if you have a technical explanation then great.
>Should I reboo the server after each rule change?

This is extremely annoying. I keep doubting what I am doing when all appears rights, then a reboot of the server puts everything right.

Hi,

Usually a reboot is not needed after a rules change, saving the rulessheet should do the trick. Why this was needed in your case I don't know. Maybe this is an issue when feeding string cells? Another possibility is the fact that the STET in your original rule would lead to undefined results in case the month element was on a consolidated level. Maybe the server got a bit 'messed up' because of this. I'm only guessing.

Michel

[shockwave]

Thanks for your help Michel. Something appears to go a bit strange when I click on the cells to trace the feeders. Quite bizzaro. I have written some rules b4 and not encountered this, very strange..

[mce]

I have the similar problem with String Feeding. here is my code:

Code: Select all

FEEDSTRINGS;
SKIPCHECK;	
['Base']=N:STET;
['Base']=S:STET;
['Live','Employee ID']=S:IF(ATTRS('Oth_Periods',!Oth_Periods,'ActPlan')@='Plan', DB('Staff_StaffCosts',!Oth_Scenarios,'Base',!Dim_Divisions,!Dim_Positions,'Employee ID'),STET);

FEEDERS;	
['Live','Base','Employee ID']=>['Live', '2010','Employee ID'];
['Live','Base','Employee ID']=>['Live', '2011','Employee ID'];

where 2010 and 2011 are consolidaition elements in Oth_Periods dimension.
The problem is when suppressing zeros, fed string values are not displayed. They are displayed correctly when no zere suppression.

Thanks in advance for replies.