Page 1 of 1

Transfer of String Data from 1 cube to another

Posted: Thu Feb 18, 2010 7:11 am
by appleglaze28
I'd like to ask how to be able to show the string data coming from 1 cube to another.

For example, I want to generalize a specific string element in a dimension, to avoid errors I created 1 cube that removes certain dimensions from the elements I'm gonna put it.

This is the rule I wrote to transfer the data from the source cube to the destination cube

Code: Select all

['Lead #'] = S: IF(['Quantity']<>0, DB('general_so_setting',!base_sales_personnel,!base_so_number,'Lead #'),STET);
['Invoice #'] = S: IF(['Quantity']<>0, DB('general_so_setting',!base_sales_personnel,!base_so_number,'Invoice #'),STET);
I'm not sure if I need to write a FEEDSTRING since I'm still not too familiar to how its' used. And if I do use a FEEDSTRING or FEEDERS which cube do I write it in, the source or destination. Cause I want the data to show when I suppress zero.

Re: Transfer of String Data from 1 cube to another

Posted: Thu Feb 18, 2010 9:07 am
by Steve Rowe
HI apple,
You should use feedstrings, if you do not the values won't show up (if you have skipcheck at least). You should feed with quantity.
I can't remember off the top of my head which way round feedstrings and skipcheck go.

Skipcheck;
Feedstrings;

Rules

Feeders;

Quantity => Lead, Invoice ;

HTH

Re: Transfer of String Data from 1 cube to another

Posted: Thu Feb 18, 2010 9:29 am
by appleglaze28
Thanks Steve, it worked...cause i kept putting the feeder under the feedstrings since I assume its suppose to be there.