Define a fan trap. How can be it solved?

devquora
devquora

Posted On: Feb 22, 2018

 

In case, if we have three tables in a universe joined in such a way that the first table has a one to many joins with the second one and that second table has a one to many joins with the third table, this situation is known as fan trap. The value of the measure is inflated if the measure in the 2nd table is dragged along with any dimension of the 3rd table.

The solution of fan trap: To solve the condition of fan trap, create an alias of the middle table or 2ns table in such a way that if a normal table is joined with the first table then an alias which is created is joined with both 1st and 3rd table. We will use the other dimensions of the 2nd table from the alias table and the 2nd table’s measure from the normal table.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Business

    What do you mean by Business Object?

    Business Objects are designed for the business professionals to help them for retrieving the data..

    Business

    What are the characteristics of Business Objects?

    It has some characteristics which are described below:..

    Business

    List some advantages of using Business Object?

    Business Objects have many pros which are shown below:..