Hi
I have a Bex query running of FIGL_C10. My budgets are stored in 0CCA_C02.
When I build my query I need to have Company code as a selection parameter.
0CCA_C02 does not store company code - it only uses cost centre - which is in essence my company code. I am not able to filter though on cost centre - it has to be on Company code.
What I would like to do is to replace the value of company code with the value of my cost centre - without having to modify the 0CCA_C02 cube (mainly because I have not got the ability to do so).
I am so lost here, so any help would be hugely appreciated.
Thank you