Skip to Content
0
Former Member
Jan 11, 2011 at 04:43 PM

MDX Formula Issue

44 Views

Hi Experts,

i'm working with SAP BPC 7.5 SP4 on Windows Server 2008 and MS SQL Server 2008 (64-bit environment).

I wrote a MDX formula (on account dimension), but when i process the dimension the following error appears (on tbllogs) :

==============[System Exception Tracing]============== [System Name] : ManageDimension [Message Type] : ErrorMessage [Job Name] : clsMakeDimension : varStratMakeDimension [DateTime] : 1/11/2011 5:14:49 PM [UserId] : SVI\SRVSAPBPC [Exception] DetailMsg : {, Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 12 ('FORMULA') is too large for the specified buffer size., Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 12 ('FORMULA') is too large for the specified buffer size. Source: InsertExcelToDb Msg: , Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 12 ('FORMULA') is too large for the specified buffer size., Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 12 ('FORMULA') is too large for the specified buffer size. } ==============[System Exception Tracing End ]==============

On my mdx formula, there isn't syntax error ant it contains about 300 characters.

If i reduce the number of characters (for example if i don't use IIF statement), the process is OK.

On mbr and dim dimension table on SQL Server the field formula is nvarchar(500).

Do you have any idea?

Thank you

Massimo