Key Figure structure getting dropped on refresh of a workbook

[Former Member]

Hi BI Gurus,

We have a workbook having 3 tabs: 1 table, 2 chart, 3 summary on the table with a pivot table for the chart. A macro is used to create the summary on the table and pivot table and chart. The data provider is a Bex Query.

In Dev, its working fine. On refresh, it is throwing a variable screen and after selecting a variable values, it is creating the right tables and chart.

In QA, workbook showing correctly. But when we try to refresh and select a variable, it creates the result table with no Key Figure Columns. Thus showing just grid and no chart. If we open the query in edit mode and execute it, the Key Figures columns reappear.

Looks like the Key Figure structure is missing.

The macro looks good in QA.

Can anybody explain the possible cause of the problem and suggest a solution? Is there a way to trace the missing Key Figures structure and transport them? Any help is appreciated.

We are on BI7.0 SP11, SAPGUI640 SP 21 addin patch 904.

Thanks.

Sheo

[Former Member]

Sheo,

The workbook may have the Return to Global Refresh value on the Interaction Tab of the Query Properties unticked. If key figures have changed in the query the workbook isn't seeing what it was setup for so you don't get key figures returned.

When you run the query from the Query Designer you are running the query as you see it so it will always work. If the Return to Global..... is unticked, when you run the query from the workbook you are running it for the version of the query it was setup for.

If this is the case, just untick the return to global definition, refresh your query and turn that tick box back off again once you have manipulated your query as you want it.

Regards

Gill