Type conversion problem..

[Former Member]

HI All,

I am new to BI7.0.

I am populating data from CSV file to cube.

I have defined :

<b>Characterstics:</b>

io_custid, Io_matid and

<b>Key figures:</b>

IO_Price - INR

IO_QTY - 0UNIT

IO_REV - INR

<b>Next</b>

1. I have created DataSource and loaded to PSA

2. I have created a Cube. and tring to create transformations it returns some ERROR:

Type conversion error for IO_Price and IO_REV

3. And in Rule group - It says : Field is not assigned to Infoobject.

I have done for MD loads successfully. Where I have done mistake?.

THis is IDES version. Why it is unable to do for Key figures?

Please let me know:

Cheers,

Sri.

[Former Member]

1. IN your file, you need to have currency for all amount key figures and unit for quantity key figures.

2. You also must have atleast one time chars and fiscal year variant.

Ravi Thothadri

[Former Member]

Ravi,

Thanks alot ..

My file is like this

CUSTID-MATIDPRICE-QTY-UOMREV--CALDAY

CUSTID001,MAT001, 5,50,EA,250,20070101

COZ PRICE AND QTY ARE defined as FIXED CURRENCY...

why should I maintain currency values again in csv file even though I defined as fixed values (INR)?

I understood from ur point , file would be:

CUSTID-MATIDPRICE-CURQTY-UOMREV-CUR-CALDAY

CUSTID001,MAT001, 5,INR,50,EA,250,INR,20070101

Please correct me and give sample record in CSV file

Cheers,

Sri

[Former Member]

Hi Srilaxmi,

Your file format looks OK.

The problem seems to be how you are mapping the file field to your InfoObjects

Check your DTP ...on how it is expecting the sequence of fields and their formats....

Good luck, BB