Question:
Hi all,
I have a query- Project Summary, which needs to be modified with company code as one of the parameters in the selection screen.
Now for this query which is executed on Infocube - 0OPA_C11, we have two InfoObjects 'Order' and 'Responsible Cost Center'. These two InfoObjects have Company Code as attributes.
My question is, does selection of Company Code attribute(in Query Properties while designing) from any of the InfoObject ('Order' and 'Responsible Cost Center') as the selection screen's parameter give the same Query result after execution?..OR selection of attribute Company Code from 'Order' InfoObject as selection screen parameter(in Query Properties while designing) does make any difference to that selected from 'Responsible Cost Center' in the Query Result??.
Hos does the Quer yresult get affected ??..
does this have any change in the query results?....
Please explain..
prasad
Answer:
The result will probably be different. Explanation: Navigation attributes affect only the characteristic that they belong to (I think).
I would suggest to create a new characteristic in your cube: co_area. By making sure that each record has this field you can truly filter on it.
Another option is to create 2 variables, one for the co_area of each characteristic. You could even make only one 'ready for input' and have the other copy its value via the user exit.