Skip to Content
0
Former Member
Apr 22, 2010 at 02:04 PM

Problems when loading the data

27 Views

Hi to all,

I've got a few problems when loading the data (facts) into BPC (7.0, SP 7.0). The first, very weird fact is that it says that ALL the data has been loaded...but actually it isn't!

In fact, I've got 9842 rows in my SQL table..The convert data says the accepts all the data (so everything is validated against the dimensions), but when I look in the fact tables, I find less rows...

Many of these rows have got an amount equal to 0...is there a way to import them? These aren't actually any kind of amounts, but an application check for each row we get in the fact table.

HOWEVER, much worse: there are some rows with amount > than 0 which are missing...which isn't possible!

But since i've got the same table on the same server, I can easily check the rows and the sums...and while the flat file used to import has got the same rows, the tblFAC2 has got less :(...

Any idea why I cannot load the rows...and don't get any message of error about it?!?!

Thanks

Daniele

EDIT: might found something, but not sure about it: my CSV exports the data as italian numbers (with ',' as decimal separator), and I've found that all the data having the decimal separator...well BPC, cuts off the value of the decimal separator! :'(

Edited by: Daniele Tiles on Apr 22, 2010 4:13 PM