Data is not displaying properly in the Role Centers.

Dynamics 365 for Finance and Operations/AX Technical Forum
#1

Data is not displaying properly in the Role Centers.
These are setups followed during installation .

  1. Installed Windows Server 2008 R2

  2. Installed Sql Server 2008 standard Edition

  3. Installed Sql Server 2008 SP1

  4. Installed Analysis Services

  5. Installed Reporting Services

  6. Installed Ax 2009

  7. Installed Ax 2009 Sp1

  8. Installed AX 2009 GLS

  9. Installed Ax 2009 Process Manufacturing

  10. Installed EP

  11. After installing Analysis Services. I processed the cubes. while processing the cubes I got the below error,

OLE DB error: OLE DB or ODBC error: Invalid column name ‘PAYMIDTYPE’.; 42S22; Invalid column name ‘SECONDTIN’.; 42S22; Invalid column name ‘TAX1099NAMECHOICE’.; 42S22; Invalid column name ‘DBA’.; 42S22; Invalid column name ‘TAXIDTYPE’.; 42S22; Invalid column name ‘FOREIGNENTITYINDICATOR’.; 42S22; Invalid column name ‘RESIDENCEFOREIGNCOUNTRYREGIO86’.; 42S22; Invalid column name ‘BIRTHPLACE’.; 42S22; Invalid column name ‘BIRTHDATE’.; 42S22; Invalid column name ‘FACTORINGACCOUNT’.; 42S22; Invalid column name ‘FISCALCODE’.; 42S22; Invalid column name ‘ORGANIZATIONNUMBER’.; 42S22; Invalid column name ‘TAX1099BOX’.; 42S22; Invalid column name ‘TAX1099REGNUM’.; 42S22; Invalid column name ‘TAX1099REPORTS’.; 42S22; Invalid column name ‘FEMALEOWNED’.; 42S22; Invalid column name ‘MINORITYOWNED’.; 42S22; Invalid column name ‘COMPANYIDSIRET’.; 42S22; Invalid column name ‘ENTERPRISENUMBER’.; 42S22; Invalid column name ‘COMPANYIDNAF’.; 42S22; Invalid column name ‘ORGID’.; 42S22; Invalid column name ‘W9’.; 42S22.

  1. I have just deleted those fields from cubes. And processed them again, the process has been completed successfully.

After that i got problems in Role Centers and I am unable to see the data on the Role Centers for different KPI’s

I just want to know the cause of the above error and why data is not displaying in the Role Centers. Any help would be greatly appreciated.

Thanks in Advance.