TM1 Forum

Hello,

If all base_so_number has only one parent (one hierarchy) then you can send the feeder to their 1st parents with the ELPAR() rule function.
Instead of [...]=>DB(................!base_so_number.............);
You have to use [...]=>DB(................ELPAR('base_so_number',!base_so_number,1)............);

If at least some of your so numbers has several parents then the safe solution is to create an attribute in your base_so_number dimension (e.g. base_lead_number) and send the feeder that with the ATTRS() function.
Instead of [...]=>DB(................!base_so_number.............);
You have to use [...]=>DB(................ATTRS('base_so_number',!base_so_number,'base_lead_number')............);

Regards,

Peter

appleglaze28 said:

This is the first time I try this out....since I'm getting used to the other rules functions of TM1 maybe someone can help me out.

I got one cube with dimensions:
-base_client
-base_account_manager
-base_other_cost
-base_so_number
-value_other cost

My destination cube with dimensions:
-base_client
-base_account_manager
-base_other_cost
-base_lead_number
-value_other cost

Now problem comes here....my base_so_number dimension contains the additional hierarchy where the element in base_lead_number is the parent of the elements in base_so_number.

So how I do feed the value from my source cube to my destination cube?