Zero suppression and string values

Post Reply
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Zero suppression and string values

Post 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!
Check out my blog for some good information on TM1, SPSS
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Zero suppression and string values

Post by Martin Ryan »

Hi Sachin,

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

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Zero suppression and string values

Post by sachin »

Boy, I am confounded :roll: ... Thank you Martin, it worked!
Check out my blog for some good information on TM1, SPSS
Post Reply