cancel
Showing results for 
Search instead for 
Did you mean: 

Flat File data load

Former Member
0 Kudos

Hi ,

While loading data from flat file a particular field whose type is NUMC and length is 25 has values like 0.98,0.825,121,762,0.987 .

But when it is loaded to a infocube it is giving 98,825,121,762,987 .

Can you help me out ?

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Rajib,

The problem is because of the fact that NUMC only allows digits. It will not allow '.'(dot). Use FLTP instead.

Pratik.

Former Member
0 Kudos

Hi Rajibg,

Create a key figure NUM With Data Type FLTP(Floating Point) and Add this Key Figure to your Cube.

Hope it Helps.

Thanks,

-Vijay

vikram_kate
Participant
0 Kudos

I think you should not use NUMC type for your respective Info objec, becaues NUMC will not accept '.'

Instead it should be DEC (Create info obj as key figure ).

Former Member
0 Kudos

Actually I am using BI 7.0 where will I find that optionof making decimails active

Former Member
0 Kudos

You have to choose in your infopackage the right decimal and thousand separator.

Hope this helps.

Regards