missing some records from import excell

[Former Member]

Hi

I faced strange behaviour with my RichClient. I wanted to buid report which take data from Excell (xlsx) as a source and that Excell has 51777 records, diffrence records and to be sure I created ID in Excell. But when I use this Excell as a source some data are missing - about 20 records. I founf this missing records and paste it into seperate excell file and then built report one more time and all missing recorder from previous report appeared. So In my opinion it wasn't problem of incorrect data.

What is strage also that in Data tab in RichClient I see total number as 51777 so in my opinion RichClient read all records but didn't show all.

My BO version: 4.1 SP5 FP2

[Former Member]

Hi Rad,

Once you create the report, right click on block --> Format Table --> General tab.

Check the option "Avoid duplicate row aggregation".

Hope it will work.

Regards,

Yuvraj

[Former Member]

We checked it and it didn't work

[Former Member]

Hi,

This is a product defect.

Check this KBA for more details: 2173730 - Column data are missing in webi when excel is datasource
in 4.1 SP5

Regards,

Amine.

[Former Member]

So the only way to solve this issue is to upgrade my current BO version to newer?

I upgraded to 4.1 SP5 FP2 because in SP5 was bug with excell also and this time we faced excall issue again - strange and I'm wondering is it possible to publish right BO version without any bug?

In every new SP I faced new problem and I don't know what I will experience in SP5 FP5 version

Thanks

[Former Member]

Hi,

Unfortunately this is the only provided solution !!!

Regards,

Amine.