Skip to Content
0
Former Member
Feb 17, 2014 at 09:08 AM

#UNAVAILABLE Error in Webi report Based on Bex Query

239 Views

Hi,

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,

Kumar

Attachments

pastedImage_0.png (13.9 kB)
pastedImage_4.png (35.3 kB)