Could not process cubes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Could not process cubes

13 posts, Page 1 of 2

1 2 »»

Could not process cubes

Rate Topic

Display Mode

Topic Options

Author

Message

ramabala.chivukula

Posted Friday, October 15, 2010 12:04 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, November 08, 2010 9:23 PM
Points: 10, Visits: 40

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.

Post #1004914

amit_gupta01

Posted Friday, October 15, 2010 1:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, September 02, 2011 5:19 AM
Points: 41, Visits: 802

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

Post #1004946

ramabala.chivukula

Posted Friday, October 15, 2010 4:05 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, November 08, 2010 9:23 PM
Points: 10, Visits: 40

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

Post #1005009

steveb.

Posted Friday, October 15, 2010 4:08 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

We need a bit more information,

are those valid columns in the dimension source table ?

Post #1005012

ramabala.chivukula

Posted Friday, October 15, 2010 4:22 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, November 08, 2010 9:23 PM
Points: 10, Visits: 40

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

Post #1005021

steveb.

Posted Friday, October 15, 2010 4:29 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

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?

Post #1005030

ramabala.chivukula

Posted Friday, October 15, 2010 4:48 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, November 08, 2010 9:23 PM
Points: 10, Visits: 40

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

Post #1005041

steveb.

Posted Friday, October 15, 2010 4:55 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

right click on table --> explore data

Post #1005050

ramabala.chivukula

Posted Friday, October 15, 2010 4:58 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, November 08, 2010 9:23 PM
Points: 10, Visits: 40

ya am able to open table. Am not getting error

Post #1005051

steveb.

Posted Friday, October 15, 2010 7:53 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

are those columns in the data preview?

Post #1005202

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions