dbTalk Databases Forums  

Dimension writeback Failed

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Dimension writeback Failed in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Julie
 
Posts: n/a

Default Dimension writeback Failed - 06-09-2004 , 07:35 PM






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

Reply With Quote
  #2  
Old   
Julie
 
Posts: n/a

Default RE: Dimension writeback Failed - 06-09-2004 , 10:08 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.