Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

3 objects in the query that is causing the measure object to multiple. By 2

Go down

3 objects in the query that is causing the measure object to multiple. By 2 Empty 3 objects in the query that is causing the measure object to multiple. By 2

Post  LUCY.ONLINE Fri Jun 01, 2012 8:02 pm

I have a report where I am using 1 measure object and the rest are dimension object

I have 3 objects in the query that is causing the measure object to multiple. By 2

So object original = 10 (correct)
Object A causes measure to show 20
If I add object B shows 40
Object C 80

So if I am correct it is a fan trap I already have checked in the universe paramters multiple. Sql statement

I was wonder how I can correct please

LUCY.ONLINE

Posts : 4
Join date : 2012-06-01

Back to top Go down

3 objects in the query that is causing the measure object to multiple. By 2 Empty Re: 3 objects in the query that is causing the measure object to multiple. By 2

Post  ngalemmo Fri Jun 01, 2012 11:43 pm

Is this a Business Objects question?

Check to see how your contexts are defined. Each star (a fact and its related dimensions) should be in its own context. BOBJ should resolve it correctly if you are combining measures from different contexts across common dimensions.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum