Yes same session and not using a run as.

--update,

Yes, I confirm bids is running as the same user as SSMS. I printed the UserID global variable in a test report.

SQLRNNR (3/26/2014)

---

When you attempt to run this in BIDS, are you using the same account that you use to run SSMS?

Many people use different accounts to launch SSMS versus to...

Thanks for the reply. That's a very good point. I also found this:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/34175435-7020-4aee-8c93-0535d5c21329/ssas-cube-processing-best-practice-sql-server-agent-job?forum=sqlanalysisservices

The guy in the post seems having a similar question. I agree there is no...

Thanks for the reply. That's very helpful. But I still think it would be fantastic if SSAS had the ability of online browsing/analysis by itself.

Here is the code. The code was done long time ago by someone left. It's not very well written and maybe can be improved. But now the issue seems to...

I got the trace this morning again. The total time from all statements in the stored procedure is about 8 seconds. But the sp:Completed shows the duration is about 1...

The code for the script task.

The script task has three variables as read only parameters:

sourceFile: name of the file. E.g: target.txt

sourcePath: e.g. c:\workfolder

targetPath: e.g. \\server\targetFolder

bankupFolder: e.g backup

The VB code

' Microsoft...

Sure, I will post it tomorrow when I go to work. But it is a lot of code:-D

Thanks for the reply. I was open to any solution actually. I heard about power shell but never tried before. Anyway I already solved it using a script task in...

Thanks for the reply. How can I dump all cube data to an excel?

Yes, it seems like a connection problem. I am new to this excel pivot thing. I saw under Data->connections, there is a connection connect to my local cube. Should I...

He can open the spread sheet and see the contents as I saved it (e.g. he can see data under months as I saved it.). But he couldn't expand the...

I was doing it in BIDS 2008. I found if I right click the column header and untick the subtotal, then it's fine. But still, this looks like a bug...

Thank you Lowell, saw you almost every time. I will have a look at the code.

Surprisingly, I can also do cross apply...

There might be some difference with running sql server 2005 (set to compatible to sql server 2000 ) and running sql server 2000...