hey U have to use "configure Default cubes" white paper by Microsoft to remove the Invalid fields
________________________________ From: avinish kaushik <kaushik_...@yahoo.co.in> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Mon, 24 May, 2010 1:01:40 PM Subject: Re: [Axapta-Knowledge-Village] While Processing Cubes OLEDB or ODBC error (Its Urgent) Hi Khader, I am getting the same error. Did you succeed to resolve this issue. Please reply back with some pointers. Thanks, Avinish ________________________________ From: ddin_soft <ddin_s...@yahoo. com> To: Axapta-Knowledge- vill...@yahoogro ups.com Sent: Sat, 30 January, 2010 6:22:52 PM Subject: [Axapta-Knowledge- Village] While Processing Cubes OLEDB or ODBC error (Its Urgent) Hai all, I am Using SQL Server 2008 Std. Edition for Dynamcis AX database. I have Implemented the Database on 2 Node Cluster on SAN as central storage. All things are going right but In the case of Analysis services I have created other instance of Analysis Services in Other Blade server.I Installed the Reporting Extensions and Analysis Extensions all things are going right. But while I am processing the cubes of Dynamics AX in Analysis server it giving the errors like... OLE DB error: OLE DB or ODBC error: Invalid column name 'PAYMIDTYPE' .; 42S22; Invalid column name 'PAYMIDTYPE' .; 42S22; Invalid column name 'ENTERPRISENUMBER' .; 42S22; Invalid column name 'INTERCOMPANYDIRECT DELIVERY' .; 42S22; Invalid column name 'FORECASTDMPINCLUDE '.; 42S22; Invalid column name 'FISCALCODE' .; 42S22; Invalid column name 'EINVOICEEANNUM' .; 42S22; Invalid column name 'TAXBORDERNUMBER_ FI'.; 42S22; Invalid column name 'FACTORINGACCOUNT' .; 42S22; Invalid column name 'PAYMIDTYPE' .; 42S22; Invalid column name 'PBACUSTGROUPID' .; 42S22; Invalid column name 'INTERCOMPANYALLOWI NDIRECTCRE80' .; 42S22; Invalid column name 'WEBSALESORDERDISPL AY'.; 42S22; Invalid column name 'ORGID'.; 42S22; Invalid column name 'INTERCOMPANYAUTOCR EATEORDERS' .; 42S22; Invalid column name 'COMPANYIDNAF' .; 42S22; Invalid column name 'COMPANYIDSIRET' .; 42S22. Server: The operation has been cancelled. Errors in the OLAP storage engine: An error occurred while the 'Gender' attribute of the 'Employee' dimension from the 'Dynamics AX' database was being processed. on every cube so pl. give me solution how to process the all Dynamics AX Cubes. with out any error. Pl. its urgent. Thanks in advance. Thanks and Regards Khader