Wrong Measures inspite of No LOOPS!!

system · August 3, 2006, 12:07pm

Hi,
In my universe there are two fact tables linked by a id(one to many relationship).There are common dimensions also.Measures are from one fact table only.Thre are no loops detected.Defined the contexts and they are handled.

Problem:-The measures are incorrect(double figures) and also I am not able to drag some dimensions properly…it always creates a section.

aasawa (BOB member since 2006-06-23)

system · August 3, 2006, 3:29pm

did you check the option “Multiple SQL statements for each measure” in Universe parameters–>SQL tab.

Kodarumadhu (BOB member since 2005-03-30)

system · August 3, 2006, 4:48pm

Sounds like you have a fan trap. If you have multiple facts, you can have this problem.

Steve Krandel (BOB member since 2002-06-25)

system · August 3, 2006, 9:17pm

You can read up on fan traps in the Designer manual (I think), and in this entry from our Designer FAQ.

Anita Craig (BOB member since 2002-06-17)

system · August 4, 2006, 7:19am

Thanks for all your replies .I solved it …just corrected the contexts.it was a chasm trap.Thnks again!!

aasawa (BOB member since 2006-06-23)