Transfer of String Data from 1 cube to another

[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.

[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

[appleglaze28]

Thanks Steve, it worked...cause i kept putting the feeder under the feedstrings since I assume its suppose to be there.