Skip to Content
0
Former Member
Sep 16, 2005 at 05:30 PM

Hierarchy Variable

20 Views

Hi,

my requirement is that i have to different Hierarchies Balance sheet and income statement.

and a query for each if these and these 2 are embedded into a work book. when i refresh the workbook the variable window pops up and since the varaible is same for both it pops up only once for the entire workbook and i get to select only balance sheet or income statement and teh other comes up with no data.

if i select income statement balance sheet has no data and vice versa.

how do i resolve this

i am not sure if i was clear in explaining my problem.

let me know if its not clear