Fan traps problem
i am a fresh man in this deisgner.
Currently i facing a problem where the data fetching multiple values.
the query i capture from webi is like below
Select FACT_SALES_ID.PRODUCT from FACT_SALES_ID GROUP BY FACT_SALES_ID.PRODUCT
( Derived_Table.PRODUCT=FACT_SALES_ID.PRODUCT )
AND ( Derived_Table.PRODUCT=FACT_SALES_ID2.PRODUCT )
AND ( FACT_SALES_ID.TRX_MTHDATE <='2011-04-30') and (FACT_SALES_ID.TRX_MTHDATE > '2010-04-30' )
AND ( FACT_SALES_ID2.TRX_MTHDATE <='2010-04-30') and (FACT_SALES_ID2.TRX_MTHDATE > '2009-04-30' )
i doubt it is a fan trap. i have tried to understand the solution but still didnt work out.
any idea on it how to solve it in universe?
i really appreciate to any one who helps.