SSAS 2008R2 Oracle OLEDB dimension is not porceesed


hi all

 sql20008 r2 on localhost w7 (x64).
 oracle 11g connect 
 use oracle oledb

 i have both 32 bit , 64 bit client (in path 32 bit first one)
 i made dsv on oracle in bids , works ok.
 i see oracle data explore data in bids 2008.
 
 but whn process employee_d dimension got error
 (sql tables dimension porocessed ok) :
 errors in olap storage engine: error occurred while 'employee ref id' attribute of 'a0_employee d' dimension 'emis external v3' database being processed.
 
 errors in olap storage engine: error occurred while 'person name' attribute of 'a0_employee d' dimension 'emis external v3' database being processed.

 
 reading forum re-tried tricks impersonation info - 4 of them
 it not worked out.
 
 
 
 any ideas ?

i found

http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/thread/1b10a45c-47cf-4d91-a8a4-d4cbeacec304/

as you mentioned when i design a cube in ssas; using the visual studio 32 bit modules using 32bit oracle oledb modules.
but when try deploy cube, visual studio is trying talk 64bit sql server which means that sql agent using 64bit microsoft & oracle oledb modules.  
but in few words; needed install 2 oracle clients @ same time.

i tried put in path env. variable paths 64 bit client first

but got error

ora-01013: user requested cancel of current operation



SQL Server  >  SQL Server Analysis Services



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more