#UNAVAILABLE ERROR in Webi while accessing Exception Aggregation Key Figures from BEx Query
I am working on BO 4.1 SP2. I am facing Below issue while accessing BEx Query into Webi.
I have created a BEx Query on top of 0FIGL_C10 infocube which has Company code, Fiscal Period and Fiscal Year wise Cumulative Balance, Credit and Debit information. I am able to see query output in RSRT correctly.Since 0BALANCE(Cumulative Balance) infoobject is an exception aggregation key figure, I am getting #UNAVAILABLE error while accessing this query in webi report for a single year. If I execute this query with all years then I am able to see output in webi correctly but If i select a year from input control because Balance sheet should be always analyzed by Fiscal Year or Company code, I am getting #UNAVAILABLE eror.
I tried and have written FOR EACH function to resolve this issue with many dimension but couldn't solve this.
Do let me know if anyone has come across this issue before.
Please find attached screenshot for your reference.