Page 1 of 1

Zero suppression and string values

Posted: Thu Sep 02, 2010 8:04 pm
by sachin
I am trying to transfer data from one version to another in the same cube. When I turn zero suppression on, it says 'No values available'. I understand that this is a case of under feeding. I'd appreciate if you can guide me on what needs to be the corrective action.

Dimension Input - has about 30 elements, half are string and the other half are numeric. Users key in all the details for the string values. A seperate d-cube calculates cash flow and populates the numeric field. See here for details.

I have this in rule and feeder -
['Overwrite' ] = S:
IF (ATTRS('Input', !Input, 'DataType') @= 'Attribute', DB('C1', 'Input', !Number, !Type, !Input), CONTINUE);
FEEDERS;
['Input'] => ['Overwrite'];

This show nothing when zero suppression is turned on. I have tried evrything to my knowledge and cannot seem to get it work with zero suppression.

I tried simplifying to this and still wouldn't work -
['Overwrite', 'Vendor Name'] = DB('C1', 'Input', '1', 'Asset', 'Vendor Name')
FEEDERS;
['Input', '1', 'Asset', 'Vendor Name'] => DB ('C1', 'Overwrite', '1', 'Asset', 'Vendor Name');

If I right click on vendor name and choose 'Check Feeder', it does not display anything in lower half window.

Any help is appreciated. Thank you!

Re: Zero suppression and string values

Posted: Thu Sep 02, 2010 8:57 pm
by Martin Ryan
Hi Sachin,

You can search the forum and/or documentation for "feedstrings;"

Martin

Re: Zero suppression and string values

Posted: Fri Sep 03, 2010 6:22 pm
by sachin
Boy, I am confounded :roll: ... Thank you Martin, it worked!