Hi There,
Have 3 tables with Headers, Lines and Charges. Header at highest level, Lines at detail and Charges at much detail level (please find the attached doc for better understanding of data).
Created an alias for middle table which is Lines table and joined with header and created a contexts as below:
C1 - Headers - Lines (Alias)
C2 - Headers - Lines - Charges
Report: In my result objects, pulled measures (from lines alias) and a dimension from lines. In Query filter, have two dimensions coming from Header (Bill to Cost Center) and Charges (Charge Account) and somehow the charge account condition is not working…For Ex: If Total charges for a bill to cost center ABC has 100 dollars having 2 charge accounts 001 & 002 of amounts 60 and 40. If i have query filters as Bill to cost center ABC and Charge account as 001, it supposed to give only 60 but in my case its giving 100 as output.
Any ideas?
Fan Trap.doc (130.0 KB)
Praveen8367 (BOB member since 2010-11-27)
(BOB member since 2005-01-06)