How to get distinct records in SAP BO information space.

Hi,

We are back porting few of the 4.x explorer to 3.x version of information space.

Even thought the objects that we are pulling same, we are getting different data in both the versions.

When we actually debug into the issue, we found that by default SAP4.x is taking distinct records and projecting in the explorer where BOXI3.2SP4 is counting all the duplicate records.

How to overcome this

EX:

4.x

computer1 # 1 OS1 # 1 User1 # 1 Carrier # 1

3.x

computer1 # 3 OS1 # 3 User1 # 3 Carrier # 3

When i saw the background query it is returning duplicate records (3) by default,

So my question is can we set any properties to show only distinct records in explorer

Thanks in advace