I have made a new dimension and setup the reference in dimension usage. Every time I process the cube i got the following message
Error 1 OLE DB error: OLE DB or ODBC error: Invalid column name 'PReference'.; 42S22. 0 0
The value in this column is 0,1 or 2. I have set the value in all rows to 1 and still get the same error.
I have tried to create a new column - updated value to 1 and refreshed the datasource and changed the dimension and dimension usage and I still got the same error processing the cube.
I have tried to use another integer field in dimension usage and this works fine.
Maybe it is something on the table - i have tried almost all but I can't solve this problem.
Leo Pedersen
The error message "Invalid column name 'PReference'" is saying that an invalid column name was specified in the SQL query that AS generated. Run Profiler on the AS server and capture the SQL query. It should point you to the problem.
No comments:
Post a Comment