Bex Query with Hierarchy on Workbook problem please help

[Former Member]

Hi all,

I have a problem, Im trying to copy information from specific cells on a query that I opened using Analyser, heres the situation:

Account Amount New Col

22110200 15 dlls

-22110201 4 dlls

-22110202 5 dlls

-22110204 6 dlls

121101010000 1dlls 4 dlls

121101020000 1dlls 5 dlls

121101040000 1dlls 6 dlls

4,5 and 6 dlls are amounts from the first 3 accounts, I tried simpy copying the information but for some reaseon when the report reloads the informacion is lost.

Also I using Hierarchy to display the values so if I copy the value from cell Q700 the value will change is the levels on the Hierarchy are expanded.

Is there anyway to do this? please help.

Thanks in advance

[Former Member]

We have used Macros in dynamic situations like these...

[Former Member]

Hi,

Thanks for the answer, Is it possible to call the Macro when the user Expands a node? or it needs to be called from a button or combination of keys?

Thanks again

[Former Member]

The macro is executed every time the workbook is refreshed....

I believe even when the user expands the hierarchy the workbook is refreshed ..which in turn causes the macro to run again...

Ashish

[Former Member]

every time a query is refereshed, the data will be overwritten.