Transfer of String Data from 1 cube to another
Posted: Thu Feb 18, 2010 7:11 am
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
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.
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);