Error #Refresh when refresh the WEBI report

[former_member220155]

HI Guys,

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.

Regards

SG

[wmarcy · Accepted solution]

Depends on your version, you can refer to a specific document available in Help Portal as "Building queries based on BEx queries"

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp7_bex_queries_en.pdf

If you worked with formulas directly on Web Intelligence report, check specific format of your key figures mainly for decimal numbers.

Be aware that your report can contains 50 objects max elsif you will encounter some issues on your report.

Do you use some filter bar or Input controls ? It may cause some refresh issues too.

[former_member220155 · Accepted solution]

Thx for ur reply William. I noticed one thing i have created mulitple Measure variables to get the final results. But in the chart(report) i want to show only final calculations so i am deleting all other calultions from the report. This is issue causes refresh error. do you know how to solve this. If i tried to hide them in the chart but it is giving error. Please share ur ideas on this how to fix this.

[former_member184594 · Accepted solution]

You might try disabling query stripping in WebI. This should help.

[Former Member · Accepted solution]

Hi SG,

As Zahid mentioned in previous message, try disabling the Query Stripping from both the query level and report level and see for results.

Report level query stripping:

Query level query stripping:

Regards

Sunil

[former_member220155 · Accepted solution]

Thx Zahid and Sunil. Thx for ur help with screen shots. Issue is resolved.

[wmarcy]

Hi,

Which version of BO are you using ? Some FP or SP can resolve some issues on Bex/Webi Documents...