Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Could not process cubes Expand / Collapse
Author
Message
Posted Friday, October 15, 2010 12:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 8, 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
Posted Friday, October 15, 2010 1:54 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 2, 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
Posted Friday, October 15, 2010 4:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 8, 2010 9:23 PM
Points: 10, Visits: 40
thank you, i refreshed.. but still error is not solved..
Post #1005009
Posted Friday, October 15, 2010 4:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
We need a bit more information,

are those valid columns in the dimension source table ?
Post #1005012
Posted Friday, October 15, 2010 4:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 8, 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
Posted Friday, October 15, 2010 4:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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
Posted Friday, October 15, 2010 4:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 8, 2010 9:23 PM
Points: 10, Visits: 40
I could not find preview in data source view of SSAS..

Post #1005041
Posted Friday, October 15, 2010 4:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
right click on table --> explore data
Post #1005050
Posted Friday, October 15, 2010 4:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 8, 2010 9:23 PM
Points: 10, Visits: 40
ya am able to open table. Am not getting error
Post #1005051
Posted Friday, October 15, 2010 7:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
are those columns in the data preview?
Post #1005202
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse