characteristic relationship?

Hi pals,

Am in urgent need of a solution for this one.

I am using a cube which has cost center, company code and controliing area along with material group.My requirement is that i want cost center as a variable and in the header.I want to derive company code and controlling area from cost center which is also in the header.

I have material group in the lead column and quantity in the data column.

I am not sure of how to do this.I have tried this before but now am in mess.pls help me.Wud appreciate sooner responses.Thank you.