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