on 03-21-2014 5:32 AM
Hi Frzz,
I have created a Calculated column of type NVARCHAR by performing some calculation on a filed whose data type is NVARCHAR.
But while validating the view am getting an error " Attribute type is not valid"
Could some one please help me why am getting this error.
Error Details:
Short Text
Attribute type is not valid
Cause
Mismatch between data type defined and values computed.
Recommendations
Check calculated measure/attribute definition and ensure data types match.
Best Regards,
Krishna.
Make sure all the " is correctly used. During copy/paste it can become some other character like shown below.
“SEATSOCC_ALL”/”SEATSMAX_ALL”
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
Give the same size for example NVARCHAR 20.
Still you face issues then post your screenshot for calculated column and the column in which it based for example table definition for that column.
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
I have provided the same size in Calculated column.But still am getting the same error.
1) First i created a calculated column CC_Test1 to perform the TRIM()
2) I created another calculted column CC_test2 on 1st calculated column (CC_Test1)
Table field:
Calculated Column1:
Calculated Column2:
Errror:
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.