on 08-16-2007 3:22 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.