Skip to Content
Oct 20, 2011 at 09:12 AM

BEx workbook not refreshing properly - Strange output


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,