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