I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error.
Data source provider error: Cannot get the column information from OLE DB provider "IBM.UniOLEDB" for linked server "M2K".;42000;The OLE DB provider "IBM.UniOLEDB" for linked server "M2K" reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
