var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Please help with the Update statement
Anyone know the syntax for the following statement in SQL 2008?
The statement below is for 2005. Please let know. Thank you.
set [REVENUE_TYPE] .REVENUECATEGORYCODE= ExistingKeyValue
where [REVENUE_TYPE] .REVENUECATEGORYCODE=BadKeyValue or <[REVENUE_TYPE].REVENUECATEGORYCODE> IS NULL
Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"
what values did you use in ExistingKeyValue and BadKeyValue
also, those angle brackets are wrong... removes dem
Thanks for replying. I didn't know what to put for existingkeyvalue, but the badkeyvalue is referring to null values?
I am not sure how to apply this.
you need to supply actual values, as i believe what you have there is just a template that illustrates the structure of the UPDATE statement
badkeyvalue should be replaced with the bad revenue category code value that you want changed, and existingkeyvalue should be replaced with the good revenue category code value that you want it changed to
Thank you r937. I fixed my cube problem without having to use this query. But it's good to know in case I need to use it in the future.