Problem while Deploying BI Project in AX 2009


This is sasikanth. I am new to dynamics Ax and I am trying to Deploy Cubes in a Business Intelligence Project.

I am getting errors like
OLE DB or ODBC error: Invalid column name ‘DATAAREAID’.;
Errors in the OLAP storage engine: An error occurred while the 'Currency code’
attribute of the ‘Company’ dimension from the ‘PerspectiveName’ database was being processed.

I followed the process defined Developer Help.

Could anyone please help me to solve this issue.

Thanks & Regards

A bit late perhaps, I think that becuse Cubes are company specific there is no need for you to add the DataAreaId in your cube, the cube will be automatically deployed to a databae in you Analysis services and named = DataAreaID. So try removing the DataAreaId from you cube definition.