Solution: Can edit, but can’t process, an Analysis Server Cube using ORACLE data

Recently I was developing a SQL Server Analysis Server cube using Oracle as a data source. Weirdly the the development environment (BI Dev Studio) could see the Oracle schema & let me explore the data. But when I tried to process the cube or one of its dimensions, it died indicating that I couldn’t connect to the Oracle Server. Which clearly I could do as I’d been building & running SQL Reports from the same project & could see the data in the development tool.

If you are experiencing any of the following errors this post may help. -Bad Username / Bad Password -ORA-01017: Invalid username/password; logon denied. -ORA-12154: TNS could not resolve the connect identifier specified. Read more...