BusinessObjects Board

INDEX NOW problem- Null value is eliminated by an aggregate

other Explorer
#1

Hi All,

I’m using Explorer with BO XI 3.2 and I’m having the problem when I try to do: “INDEX NOW”

The database error text is: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Warning: Null value is eliminated by an aggregate or other Set Operation … (WIS 10901))

I built a universe and doing integrity check that everything is ok.

If I do the query with Microsoft SQL Server Managment Studio the query goes well and does not give me any errors.

What can be the problem and the method to solve?

Dem

demcug (BOB member since 2010-04-30)

#2

Are you doing sum on the columns which may have null values?

divyap (BOB member since 2010-09-08)

#3

Yes, it sounds like you need to qualify a division error somewhere in your measures (i.e. don’t do the division if there’s a NULL) - we hit a similar error but it was related to dividing by 0. Once we handled the exception in the measure object definition within IDT the Infospace would index fine.

jackie_dunn :us: (BOB member since 2013-09-03)