Skip to Content
0
Former Member
Feb 18, 2011 at 11:33 PM

derive 0costcenter from 0funds_ctr

52 Views

i m using BI 7.0 and I have the next question.

I m trying to build a input ready query where the variables are:

0comp_code

0fiscyear

0currency

0funds_ctr

0account (this is a node hierarchy variable)

and on the rows i have:

0funds_ctr

0costcenter

0account

What I need is this query must only show the costcenters related to the funds center selected... I guess I have to create a Z characteristic compounded by 0funds_ctr and 0costcenter, but how can I tell the query or level aggregation to read this Z characteristic and derive its costcenter related?

This new Z characteristic has to have only two fields?? I tried to build but trough RSA1 but always create one filed more...

Any suggests?

regards

joker