If anyone is interested, I found the cause and solution. It can be found at the following link:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/542b4ec5-58af-442e-b6da-1f36c270e1f6/ssdt-issues-in-vs2010-analysis-services-project?forum=sqlanalysisservices

Just an FYI (in case anyone comes across this thread later for help), here is an article I had to follow to get the 32-bit drivers installed:

https://community.oracle.com/thread/3725625?start=0&tstart=0

I had...

No worries. You have already been most helpful and helped me get past a few issues. Very much appreciated.

Thank you for all the help. I really appreciate.

But unfortunately, I cannot install the 32-bit drivers. I am trying to install from the follow: "winnt_12102_client32"...

Thank you for the help. One issue was solved (connecting to SQL Server) but I still get that Oracle error when changing the property. I also installed Oracle...

https:// does not work. Says "can't be redirected".

When trying to access the reports with normal http://, we get a prompt for "Windows Security" asking...

I couldn't find a solution to the report for filtering the data, so I removed "TableB" and created this as a view that only returns the most recent record. ...

Unfortunately, it is not. I am getting an aggregate error trying to add a filter or it simply doesn't work.

If this was a SQL Statement for TableB, it would...

AH. I gotcha now and see what you are saying / doing. Makes sense now. Thank you for the help. Appreciate it

Thank you for the help, but unfortunately this doesn't seem to work as I expected. Not sure I explained it correctly.

The table has the following columns:

[ProjectType]

[ProjectSubType]

[ProjectCategory]

[ProjectSubCategory]

I know...

I realize this database is not normalized, but unfortunately I inherited it when the previous developer left and I was hired to replace him and now I must work around...

Appreciate the help, but I do not have access to create database objects. We "own the data, but not the objects / database", so if possible, I need to...

Thank you for the help and explaining the underside of what was happening. Greatly appreciate the help...

Luis: thank you for the help, but unfortunately this didn't help. I searched the folder in question for the stored procedure, and Notepad++ wasn't able to find any...

You are correct. There are a "bunch" of DBAs who seem to rule the land. Everything we try to do, we do not have permission but then are...