How to keep the default values of the query in the selection screen of workbook?

[tecsap_tec]

Hello,

I have queries with default values but when I open the workbook (refresh on workbook on open is checked) there are the last data after save. For exemple the query take the date of today but when I save the workbook I save with yesterday. So when I open the workbook today, the data are filtered on yesterday.

How to keep the default values of the query in the selection screen of workbook?

Thanks

[umashankar_poojar]

Hi

     Check the workbook settings as shown in below screenshot, "Uncheck the option Process Variables On Refresh". It should solve your problem.

Let us know if not solved.

Thanks,

Umashankar

[tecsap_tec]

Hello,

With "Uncheck the option Process Variables On Refresh" it's OK for variable with default value selected manually in the query. But for variables with default value selected by customer exit this function doesn't work.

How can I do for customer exit?

With variant the values are not dynamic, no? If we save with data 22.08.2013, tomorrow when we open workbook with this variant it will be always 22.08.2013 whereas we want 23.08.2013.

Thanks

[umashankar_poojar]

Hi,

         It should work for customer exits also but not sure exits with default value. With variant values you can make both static or dynamic.

          Let's say you have 4 variables V1, V2, V3, V4. out of V4 you want to make it dynamically pick. Then check the settings of variants (if you check the option, then values for V4 will become dynamic.

Is this you are looking for?

Hope it helps!

Thanks,

Umashankar

[tecsap_tec]

Thanks for your answer.

But how I get this transaction? I know the transaction SE38 but I need a program. For variant of workbook I haven't program, no?

Thanks a lot.

[umashankar_poojar]

Hi,

        Nice catch! you are right there is no program to achieve this. But try as below.

1. Run the query in RSRT, once it gives a pop up to enter values.

2. Save desired values, as shown below.

3. On next screen, choose 'No' to the Customer Exit variables.

This will serve the purpose.

Later, when you execute the same query in analyzer. you can choose the variant saved.

But I doubt earlier apporach would have given you the same result, i.e., unchecking the option "Process Variable On Refresh". Is your customer exit written for I_STEP = 2?

We have the same scenario which works with 'Process Variable..."

Anyway try above steps and update us. Also don't forget to choose correct answer/helpful answer. It will help others to get the hints and answers easily.

Hope you understand!

Thanks,

Umashankar

[tecsap_tec]

Hello,

When I create a variant like the last answer I don't have the possibility to choice this new variant when I execute the workbook.

I find the solution to have a variant: I need to save directly on the execution of workbbok with the button "Save as new variant" and with the two options "Save as user variant" and "Use as default variant" not checked. But the date is not dynamic with the customer exit (it is in step 2).

On my workbbok V7.0 I have several queries with different variables but some common. I want that every queries have the same value (for exemple the same date).

Thanks

[Former Member]

simple delete variable, create variant without this field and add variable again..

[former_member213043]

Hi

I guess that what you call "default values" are for variables.

In your case, how did you force the default value of the day variable to be "today", as this default value depends on the day ?

The last time I had to do that, I had to do a custom exit variable to populate the default value. If I remember correctly, I also had to change the default value in the Variables tab in the workbook properties to check (or uncheck) the first option to manage variable values...

Play with those options, and the variable screen should appear before you get the result updated.

Otherwise, as mentionned by SVU, try yo use variants to get the default values correctly populated

Thanks

PY

[former_member202718]

Hi TECSAP,

When "Refresh on workbook on open is checked" is checked the Workbook when opened and REFRESHED should take you to the selection screen.I hope you have also checked "Allow Refresh on individual Queries".

Else you can also create a variant and then try.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d032116a-1ba6-2e10-8db6-d84e7dcc9...

Rgds

SVU