BusinessObjects Board

Report retreiveing double the values than DB values

Hi all

Im having trouble in report. I have a report which displays all the columns of a table say TableA gropued by objects. When I try to include an object out side from the main TableB into the report, all the measure objects are giving the values that are double the original DB values…when I remove the objects of TableB from the report then I am getting correct values. Can somebody help me in this regards…I tried to do wat ever i can at universe level.

Actually in the universe Between TableA and TableB there are 2 other tables. TableA is connected to TableX(Many to one), TableX to TableY(Many to one) then TableY to TableB(Many to one and Outerjoin).

can somebody suggest me solution for the problem


Raj1306 (BOB member since 2009-10-13)

It seems that you have a chasm trap, you can take a look at THIS and see if it helps.

Regards,

-John Vincent


jvmauricio :philippines: (BOB member since 2009-08-03)