Skip to Content
avatar image
Former Member

missing some records from import excell

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 03, 2015 at 03:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded