Hi,

Sorry for replying late, but I've been traveling.

Thanks for the replies. We noticed that this was happening because of some connectivity issues with the Oracle data source. Took us a...

Hi,

Ok... a few basic things you could check:

1. Are projects X and Y on the same machine? Is the package able to access the Excel file from Project Y? Look...

Thanks for the response, guys! I eventually discarded this approach and went ahead with 'Debit - Credit' regardless of Account Type. This, I was told by a few Finance guys,...

Someone please help!

I seem to have found out the cause of the problem.

For dimensions A and D, I had set the IsAggregatable property to False because I didn't want to see the...

Nicholas, thanks for your reply. The user is not listed under any of the groups under Server Roles, but is still able to access the DB.

Jerry, the user is able...

Hi all,

Thanks for the help. It worked after I processed the dimension before processing the cube. What surprises me is that I was getting this error even when I was...

Dear Markus and Benjamin,

Thanks for your solutions. I have created the database role, granted execute permissions and have mapped the db_dataexecutor and db_datareader roles to the user. Everything seems to...

Hi,

Is there no way to do this? Someone help!

Regards,

Guru

I could do this, but there are about 300-400 procedures, and newer ones would be created on a regular basis.

Isn't there a way you can give db_owner privileges but revoke...