Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fan traps problem

hi all,

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.VALUE,

FACT_SALES_ID2.VALUE,

Derived_Table.PRODUCT

FROM

FACT_SALES_ID,

FACT_SALES_ID FACT_SALES_ID2,

(

Select FACT_SALES_ID.PRODUCT from FACT_SALES_ID GROUP BY FACT_SALES_ID.PRODUCT

) Derived_Table

WHERE

( 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.

thanks alot

Former Member
Not what you were looking for? View more on this topic or Ask a question