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.