hi all,
i have a problem with ssas 2008. the system informations are below;
System;64 bit, sql server; 2008, oracle client;11.2.0.1.0, database;11 g enterprise release 11.1.0.7.0 64 bit production.
im using oraoledb as data source. when i deploy data source and data source view its working. and also when i explore data from data source view i can see the data. but when i create a dimension and when i process it, it gives me the below errors;
ole db error; ole db or odbc error:%1 is not a valid Win32 application
Errors in the high level relational engine. A connection could not be made to the data source with the DataSourceID of 'X', Name of 'X'.
Errors in the OLAP storage engine: An error occured qhile the dimension, with the ID of 'Y' , name of 'Y' was being processed. Errors in the OLAP storage engine: An error occured while the 'Y ID' attribute of the 'Y' dimension from the 'Test' database was being processed.
Internal error: The operation terminated unsuccesfully
i changed the path of SSAS 2008 as programFilesX86 from Program Files (x86) folder name. but it didnt work for me:(
its really urgent and i couldnt find anything to fix it.
thanks in advance