cancel
Showing results for 
Search instead for 
Did you mean: 

Workbook Refresh

Former Member
0 Kudos
56

My users are running into problems when they refresh BEx workbooks. For some reason, the prompt that is triggered by a data refresh does not include the original selection criteria.

For example, when I first open the workbook it prompts me for fiscal period and company ID. But when I refresh the workbook, it only prompts me for fiscal period.

I'm sure this is something simple. I appreciate any help!!

Accepted Solutions (1)

Accepted Solutions (1)

edwin_harpino
Active Contributor
0 Kudos

hi Shelly,

try check if this helps, in xls workbook, check button 'goto' (red arrow right up ), choose properties, tab 'interaction', checkbox 'save and reuse variable values'.

and check this thread

see Deepu's comment

When refreshing a workbook in the BEx Analyzer that contains a changeable variable, this variable does not appear in the variable screen, since the values have already been set in the dynamic filter and also displayed.

http://help.sap.com/saphelp_nw04/helpdata/en/37/4e3ed4ce9b9a4298ec0ed199512b8c/content.htm

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Shelly,

Sounds like your problem is solved for now. But, one other thing that comes to mind is Personalization of variables.

Many users Personalize variables and then promptly forget that they did so. And, they forget how to turn it off.

The way to check this is hidden under the "Change query" button (Change query >> Change variable values).

- Pete

Former Member
0 Kudos

Thank you. I check the "return to global definition on refresh" and this worked!

former_member188975
Active Contributor
0 Kudos

Hi Shelly,

Is the variable for Company ID marked as Changeable with Query Navigation? Check this link for more info:

http://help.sap.com/saphelp_nw04/helpdata/en/37/4e3ed4ce9b9a4298ec0ed199512b8c/content.htm

Hope this helps...