Zero suppression and string values
Posted: Thu Sep 02, 2010 8:04 pm
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!
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!