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

View previous topic View next topic Go down

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

Post  LUCY.ONLINE on 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

View user profile

Back to top Go down

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

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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