How to get distinct records in SAP BO information space.

[Former Member]

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

[Former Member · Accepted solution]

Hi Divya,

Kindly check the same workflow for Webi report by creating one on the same objects.

Try with checking "Avoid duplicate row aggregation" and compare the records in 3.x and 4.x versions.

Explorer does not contain any such properties settings to filter the records fetched.

Best regards,

Manu