Post reply

Could not process cubes

  • October 15, 2010 at 12:04 am

    #147285

    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.

  • October 15, 2010 at 1:54 am

    #1237334

    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.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

  • October 15, 2010 at 4:05 am

    #1237387

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

  • October 15, 2010 at 4:08 am

    #1237390

    We need a bit more information,

    are those valid columns in the dimension source table ?

  • October 15, 2010 at 4:22 am

    #1237399

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

  • October 15, 2010 at 4:29 am

    #1237407

    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?

  • October 15, 2010 at 4:48 am

    #1237418

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

  • October 15, 2010 at 4:55 am

    #1237425

    right click on table --> explore data

  • October 15, 2010 at 4:58 am

    #1237426

    ya am able to open table. Am not getting error

  • October 15, 2010 at 7:53 am

    #1237559

    are those columns in the data preview?

  • October 15, 2010 at 7:23 pm

    #1237944

    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.

  • October 15, 2010 at 7:58 pm

    #1237945

    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..

  • October 18, 2010 at 12:37 am

    #1238239

    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