Flowfields in business analytic

Maci

Another Business Analytics doubt:

Is posible to "simulate" a complex flowfield in a cube?

Example:
TableA.fieldA flowfield calcformula
lookup
from
tableB
where
tableA.fieldB-field-tableB.fieldB
and
tableA.fieldC-field-tableB.fieldC
and
tableA.fieldD-constant-XYZ.

I hope I explain this... I can get the tableA.fieldB-field-tableB.fieldB, but not the other 2.

Any idea?

Thanks