Skip to Content
avatar image
Former Member

Type conversion problem..

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 16, 2007 at 02:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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