I have created WEBI report on Bex query using BICS connection we are on BI 4.0. I have created all the calculationas and formulas directly in the webi reprot only, from BEx query just i am taling kyefigures. After i create the report it looks everything ok all calcualtions also working but when i refresh the report all values are disapperaing from the report and message "#Refresh" is diplaying all the Calculated coloumns in all the rows except key figures which i get from bex query. Does anyone had simillar issues please share ur ideas on this if i miss anything. I have created couple of reports all the report haveing simillar issue. Please share thoughts to fix this issue.
Thanks in advance.