BPC10 NW: other way to see rejected data ?

[Former Member]

Hi experts,

I am loading BW cube into BPC; i have a lot of rejeted data.

when i want to see the detail of status , excel send to me an OLE message.

Is there another way, out of bpc where i can check rejected records list ? (i have many line, probably the reason of the OLE message)

Thks for your help,

Olivia.

[Former Member · Accepted solution]

Hi Olivia,

Please validate the transformation file, you will be able to see the rejected records by selecting the rejected records radio button.

Regards,

Kalyan.

[Former Member · Accepted solution]

Hi kalyan,

Ths for your message,

Yes I did it...

But, as said to Nilanjan above, result is not enough if I have too many lines rejected...

believe it is blocked around 200 lines no ?

Maybe you think to another solution ?

A maybe a way (if possible) to up that limitation of 200 lines,

Tks for your help,

[Former Member · Accepted solution]

Hi Olivia,

I am not sure if there is any way to see more than 200 rejected records at a time. What I know is that 200 records is the maximum limit.

But my question is why u want to see more than 200, first resolve the 200 records and then validate the rest.

One alternative you may try is to get all the data from the cube in an flat file and them open the same in excel and then do vlookup to see that records that are getting rejected.

Regards,

Kalyan.

[damovand]

Hello Olivia,

Can you please provide the specific error you get when trying to see the details?  Thank you

Best Regards,

Leila Lappin

[Former Member]

Hi Olivia,

Have you found the solution?

[Former Member]

Hi Nilanjan,

I put my message answered, because I forgot that the Validation of transformation could make the job.

But, nevertheless result is not enough while I have too many lines rejected ...

If you have any idea to make it better ?

Tks for your help,