BEx not refreshing data on all embedded queries:One variable, one variant:

[Former Member]

Good day

I have the following challenge. I have created a BEx workbook and inserted one query multiple times into this workbook. I have removed the result area of each query to a separate sheet to enable the use of different filter values and to use some excel formatting to change fonts, colours etc.

I have created a ocalday variable selection to this query. The data must be displayed for the last day of each month for a period of 12 months from a certain ocalday. I created and saved a variant for this, adding the last ocalday of each month from 2009/05/31 to 2010/04/30 in the selection option of the variable, thus it looks like this in the variable selection of single values:

2009/05/31

2009/06/30

2009/07/31

Etc

Etc

I have ticked the option u201Crefresh queries when opening workbooku201D in the properties of the query and applied it to all. When the user opens the workbook, the users must select the variant on the variable selection screen and refresh all the queries.

Now, my challenge comes in where only one query is refreshed with the required dates. All the other results cannot be found and it displays the last date in the variant (ie. 2009/04/30). You need to go and refresh each query separately, using the same variant. This is time consuming as some workbooks have > 50 queries.

Thus, one query embedded multiple times, one variable, one variantu2026u2026

Why does the variant not apply to all the embedded queries when data is refreshed?

Your expert assistance will be appreciated.

Have a nice day

Cj

[hai_murali_here]

Hi,

When you have multiple queries in the workbook which have variables with that,refreshing the workbook,will prompt you the variable screen where you can enter the variables which can take effect in all the queries.

Go to Workbook Settings->General tab->Check Refresh workbook on Open->Go to Variables tab->Check Process Varaibles on Refresh and Display Duplicate Variables Only Once.Save and reopen the workbook.

Now it will prompt for variable screen where you ca enter the variable values which is common for all the queries.

The data will be shown in all the ANalysis items based on the variables entered for the queries.

Rgds,

Murali

Edited by: MuraliKrishnan E on Sep 10, 2009 2:21 PM

[Former Member]

Thanks for your response. We are still using 3.5 BEx.

Cj

[Former Member]

Sorry guys/girls....I meant (ie 2010/04/30) in the following sentence...."All the other results cannot be found and it displays the last date in the variant (ie. 2009/04/30)"

apologies

Cj