Could not process cubes

  • I installed Sql server 2008 SSAS ,for Microsoft Dynamics AX 2009 . I am getting following errors while procesing some of my cubes,

    OLE DB error: OLE DB or ODBC error: Invalid column name 'INTERCOMPANYDIRECTDELIVERY'.; 42S22; Invalid column name 'FORECASTDMPINCLUDE'.; 42S22; Invalid column name 'PBACUSTGROUPID'.; 42S22; Invalid column name 'INTERCOMPANYALLOWINDIRECTCRE80'.; 42S22; Invalid column name 'WEBSALESORDERDISPLAY'.; 42S22; Invalid column name 'INTERCOMPANYAUTOCREATEORDERS'.; 42S22.

    Processing Dimension 'Customers' failed.

    Please help me in resolving the above issues.

  • I think data definition has changed in relational database or it is out of synch with DB ...please refresh database from Data source view DSV and then reprocess the cube.

  • thank you, i refreshed.. but still error is not solved..

  • We need a bit more information,

    are those valid columns in the dimension source table ?

  • actually those fields are there in axapta database but not in sqlserver.. but in Virtual PC cube got processed in the same scenario.

  • if they are not in the source tables then it wont process.

    when you go into the DSV and preview the data for that table do you get an error?

  • I could not find preview in data source view of SSAS..

  • right click on table --> explore data

  • ya am able to open table. Am not getting error

  • are those columns in the data preview?

  • am new to SSAS. I can able to view data in table.. but I dont know if there is any other way to view data preview.

  • am new to SSAS.. i can able to open and view data in table. but i don' t know if there is other way to preview data..

  • those columns are not there in source table.. but they are available in same table of axapta

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply