BusinessObjects Board

Measure issue

Hello Friends,

Here I have department table, Product table and Bridge table.

Relationship are like this From department to Product table one to many relationship
And
Product table to Bridge table one to many relation ship.

I am trying to get the data from Departmrnt to Product table to Bridge table.

In product table i have measure objects, there we are getting the issue.

We are getting correct results, when we are not selecting the
bridge table.

Whenever we can select bridge table product key is repeating, we are getting wrong results. Do you have any idea to resolve this issue?

Thanks
Kumar


kumar1219 (BOB member since 2009-07-16)

Hi,

What you are experiencing is called a fan trap.

Please read more about it and how to solve this problem here:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

build context between 1st table and 2nd table and alias to 3 tables;


harrypintous (BOB member since 2010-02-05)

select “Multiple SQL for each measure” option in your universe. That will resolve your issue.


Rakesh_K :india: (BOB member since 2007-12-11)