cancel
Showing results for 
Search instead for 
Did you mean: 

BEx workbook not refreshing properly - Strange output

0 Kudos

Hi All,

I am building a workbook using a single query, with same navigational structure. The workbook contains 2 sheets, each with same query output, but differing in units. Worksheet 1 uses unit A for quantity whereas worksheet 2 uses unit B for quantity, which is the requirement from users.

I have built a WB and I have observed a strange behaviour, when I am refreshing the workbook it is giving for only one unit, say A in both sheets.

I have unchecked "Display duplicate variable only once" in the workbook properties, so that I can enter variable inputs separately.

Could anyone help me in understanding the behaviour of workbook. Please let me know, if am not clear in my information.

Thanks and regards,

Shashidhar.

Accepted Solutions (0)

Answers (5)

Answers (5)

0 Kudos

The issue resolved, when we assigned unit conversion type in query designer for the quantity key figures.

former_member188080
Active Contributor
0 Kudos

Hi,

If I reember correctly we need to go to extreme left corner and then right click where you can see option of global refresh check before saving.

Just check going to second tab /worksheet as well whether that option remain there or not.Else check it.

Also check workbook setting as mentioned below

http://help.sap.com/saphelp_nw70/helpdata/en/54/a493f7256b43698191a2623e5a0532/content.htm

again why don't you use same variable selection parameters in both the queries?No need to provide separate inputs.

Thanks and regards

Kiran

0 Kudos

Hi All,

I would like to update that the unit conversion is happening at key figure level, where the KF is linked to 0UNIT. 0UNIT has a variable, say ZUNIT created at query level. The workbook I create has a single query in 2 sheets, but input to this variable ZUNIT differs according to users' wish. This variable is an optional input variable.

The output in the workbook for the units entered, is not according to inputs entered.

Is this issue in anyway related to report Cache memory?

Following are the present settings, which I can see in RSRT:

Read Mode: H

Req. Status: 0

Cache mode: 5 BLOB/Cluster enhanced

Could you please let me know, in case of any other information required.

Thanks and regards,

Shashidhar.

Former Member
0 Kudos

Hi,

In workbook if you are using similar query multiple times with similar variable set it will ask for the variable input only once. Its better that you create a copy query of the original one and then put original query in one sheet and copy query in another sheet. Also remove the check for showing Duplicate Variables so that variable screen is hown for both the queries. This should resolve your issue.

Navesh

0 Kudos

Hi Navesh,

We are building WB directly on production data and share it across email and hence we cannot duplicate queries in production. Also, I have unchecked the "Display duplicate variable only once".

Thanks and regards,

Shashidhar.

Former Member
0 Kudos

Hi,

I don't think the issue is because of Cache Mode. However there can be two solutions in this case :-

1. You can create two keyfigures in the same sheet. Each key figure can show the output based on the unit.

2. You can use Emai Bursting option of the query broadcast on the basis of unit. You will just need to create two user gropus on the basis of unit (one user gropu will receive the report for on unit and other for another unit based on their requirement)

Navesh

0 Kudos

Hi Navesh,

Our actual requirement is two keyfigures in different units side by side. Infocube has data stored in PC (pieces) unit, whereas output required is in Tonnes and KGs in same sheet. The unit that displays in query output depends on the unit entered in the selection screen.

We have planned to build a workbook with two sheets (each having a single unit data) and build a macro to consolidate data into first sheet.

Could you please elaborate on your first point?

Thanks and regards,

Shashidhar.

Former Member
0 Kudos

Hi,

Did you manage the workbook setting like Refresh Workbook on Open,

Go trough the below link for complete workbook settings .

http://help.sap.com/saphelp_nw70/helpdata/en/54/a493f7256b43698191a2623e5a0532/content.htm

Regards,

Satya

0 Kudos

Hi,

Thanks for the reply. We do not need to refresh automatically.

When the query is individually executed for different units separately output is proper, but when I include two query outputs in a single WB, I see one of the outputs is showing desired output.

Eg. I need quantities in Tonnes in sheet A and Cases in sheet B, say I have built one WB like this and save it. When I refresh the same workbook for different dates, I see only Tonnes is getting populated in Sheet A and Sheet B. Sometimes, if I am changing the units and executing the WB is showing previous selection units only.

Please let me know, if I am not clear in explanation.

Thanks and regards,

Shashidhar.

Former Member
0 Kudos

Hello Shashidhar,

If a workbook contains multiple queries that use the same variable, you are prompted to enter the variable values again for each query. To avoid this, select the Display Duplicate Variables Only Once indicator.

As you have created workbook on single query, just set the indicator process variable on refresh if the values saved in the workbook are to be used automatically.

Hope it helps you.

Thanks,

Santosh