Additional info
- using enterprise edn, SP3
- all advanced options enabled on parent-child dim
- member column name set to case "dbo"."kpi_dw_dim_acct"."ACCOUNT_CODE" when ' ' then rtrim("dbo"."kpi_dw_dim_acct"."ACCOUNT_DESCRIPTION ") else rtrim("dbo"."kpi_dw_dim_acct"."ACCOUNT_DESCRIPTION ") + ' (' + rtrim("dbo"."kpi_dw_dim_acct"."ACCOUNT_CODE") + ')'end
"Julie" wrote:
Quote:
SQL Server 2000 Analysis Services SP3 on Windows 2000 Adv server
Trying to add to new dimension member (sibling), entering all member properties but receiving errors
"Unable to save changes to dimension data. Data source provider error. Unclosed quotation mark before character string values (....
or
" One or more errors ocurred during processing of command"
Appreciate your help |