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!
Zero suppression and string values
- 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
Check out my blog for some good information on TM1, SPSS
- 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
Hi Sachin,
You can search the forum and/or documentation for "feedstrings;"
Martin
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
Jodi Ryan Family Lawyer
- 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
Boy, I am confounded
... Thank you Martin, it worked!

Check out my blog for some good information on TM1, SPSS