How to USe Drill thrill Action when using Set Operators Or Join Condition

[phanicrn]

Hi  guys

I have two queries  in report studio.

query1 has Member column which is defined from regular dimensions.

1)Member Column Heirarchy would be

Branch_name
Lastname
MemberID
Member_Key is business key.

2) Transaction_amt as Measures

3) Transaction Code as query item

4) Member_Key(Primary_Key Column) as Query Item

Query 1 is filtered by some 'X' condition


Query 2 has Member Column which is also defined from regular dimensions..

1)member Column  heirarchy as
Branch_name
Lastname
MemberID
Member_Key is business key.

2)Account Balance as Measure

3) Transaction Code as Query Item

4)Member_Key(Primary_Key column)as Query Item

Query2 is filtered by some 'Y' condition.


Then i bring Query3 to do set operations as 'INTERSECT', EXCEPT, UNION or Join Conditions

Query 3 is joined  by Query2 & Query 1 on Member_key Column which is Primary_key column, relationship would be 1.1 to 1.1


since (Query 1 & Query 2)  have different condition and they filter and get the records.

i select columns from both queries to compensate .

I select Member Column(which is Regular Dimension) from Query 1
and Account balance (query1), Transaction_amt(query2),transaction_code(query2)..

I get the ouput and report is working fine, but Drill thru action is not working  when using join condition or set operators..

Do i have to use any Dimensional Functions to get the drill through action  working when using opearators(join, intersect, union, except.)

Thanks guys

Phani.P