Skip to Content
0
Feb 15, 2010 at 03:13 PM

Xcelsius SP3 and BW Connection -> "Refresh on Trigger Cell" -> Filter

24 Views

Hi all,

I'm working with Xcelsius SP3 (BW Connection -> BW Query) and have a problem to use 2 filters (or more?) with the "Refresh on trigger cell".

I defined 2 Filters, Year and Location, of a query.

Year -> Read from Cell F2

Loc. -> Read from Cell G2.

Now I have do define the cell for the refresh on trigger cell. But it is not possible, to define 2 cells for the refresh. I have tried to chain the two fields in new Cell H2 and use this cell for the trigger cell, but this doesn't work.

Has anyone an idea how I can refresh the query-data, when I change one of the filters?

Best Regards

Thorsten

Edited by: Thorsten Watzke on Feb 15, 2010 4:34 PM