We have BO reports which are based on BeX Query's .We are implementing Currency Conversion for some of the BO WEBI reports .
we have a Currency Conversion Filter in Selection Screen for this i wrote User response function to show the cloumn values Dynamically in the report But
By Deafualt values are showing in the Report column "Currency-Key" but when i run for any currency (Ex: USD) values are not changing . For this i Created a variable called Technical1=UserResponse("Currency Conversion").
Then i directly written a formula on Clolumn Currency - Key "=If(UserResponse("Currency Conversion")="";[Currency - Key];[Technical1])" then am getting # UNAVAILABLE error for the only highlighted columns
Currently our BO Version : SAP BI 4.0 SP6.1
I tried creating a variable and placing that variable beside the columns thoug ham getting the same error.
Kindly help me in this regard to get rid og #UNAVALIABLE error.
Thanks & Regards,