Wait I am sorry I am pulling from Navision odbc to SQL 2k. The transformation from 2k to 2k5 is working properly. Not really a big deal. ...

I do updates to the database but the tables involved have not been touched. Not to make a conspiracy theory but I am pushing data from SQL 2K to...

No literally it was a working process. I have not touched the process for months

Thats just spooky. Well maybe I will change the Name. Maybe it is crazy like that

I am not sure if this is the best way but I have a PROC that checks a directory.  If the file is there it initiates the job.  That way...

From what I looked up there is a couple of GPS cell phone providers

http://www.mapquestfindme.com/

http://www.nextel.com/en/services/gps/mobile_locator.shtml

http://www.accutracking.com/

Beyond that I have not gotten into the details. It is pretty cutting edge but from...

From what we do: Place the cube on the server and use roles for security management.  This is the standard practice I think.  It allows for easier managament and you do...

from what I recall that error 0x80004005 really means nothing.  It is a broad error catch.  I would check your firewall settings or the odbc setting on the server

I never did get that other solution to work. So you are saying that if I remove '.Bak' the delete will work? What would happen if I have...

I am not understanding the question.  The scripts are what?  Tables or is it a Diagram script?

First thanks for the post. We are using excel 2002 and I have the Addin for Analysis Services installed.

I added the ability to drillthrough in the roles which was...

I think it is still in CTP.  So be careful make sure to back all your stuff up.  I have not for that reason.  Also you posted this in the...

Is it possible that you have security on that dimension that does that is not allowing you to see it?

you really got me. I have never seen this before. I am also not a excel guru even though everyone that uses these cubes are in worse shape...

interesting it is at the 5th level. It is for an accounting breakdown

ie

1234 Management

5678 Salaries

8910 IT

...