Recent content by ianclarke

Hi I have followed Kimball methodology by including an unknown member in each dimension in the relational database. In the case of a time dimension I have an unknown member with key value -1. All time related fields, e.g. FullTime, Hour, Minute, etc are NULL in the database. I have a field...

Hi All I'm building a new cube. When processing some dimensions will process successfully, but others won't. All dimensions are in the same database, so security should be the same. If I take the queries and run them in management studio I get results without any problems. In the Process...

Hi Geoff Thanks very much for your help. After fiddling around a little with string you provided, it is now working. The final working url is: ="http://server/ReportServer?/reportsfolder/Test1&rs:Format=EXCEL&rs:Command=Render&Date=" & Parameters!StartDate.Value It actually accepted the date...

Hi I've been trying to put a link on a report (SQL Server 2005 Reporting Services) to a url which will render another report in Excel. I have successfully linked test reports to get the Excel export without any parameters, I have successfully passed a parameter through with a constant, but I...

Hi I currently have Windows XP Media Center Edition installed on my desktop. I have also got a lot of media, files, work, etc on the desktop. I don't have an external or second hard drive to back up my data. I want to learn more about ASP and PHP but unfortunately XP Media (based on Home)...

Hey All I have just solved the problem by removing Atomic Log from startup. I can't believe it caused all these problems. I have not uninstalled it - just removed it from startup. What a relief. Thanks for your time and replies. Ian

I have just shutdown and restarted. Still the same errors!

Your responses are much appreciated! Jason: I have checked the DEP settings and they were already on for Windows services only - it is only Windows services that are returning the errors, i.e. Explorer / Task Manager / ConnectionsTray / rundll32.exe. I have run AVG anti-virus again and all's...

Hi I'm getting a repeating error since rebooting my laptop immediately after scanning with AVG, Ad-Aware, SpyBot and Bazooka and then running a disk check which required the reboot. The scans returned no viruses and only 3 objects were removed by Ad-Aware. I missed the end of the disk checking...

Just configured a call centre phone. For some reason when logged in it does not display not ready status on the phone but does through Symposium. Replaced phone and still the same, and checked the configuration and its the same as other call centre phones. Any ideas to what could be wrong???

Hi Is there any difficulty in setting up a home network over Windows 2000 Pro and XP Home? If possible, would there be any disadvantage in using the Win2k system as the internet server? I am setting up a wireless network between an XP laptop and a 2000 desktop. As you can imagine, I'd like to...

Hi Denis By 'create the data source on the sql server' do you mean create the DTS and job while on the sql server? Or do you mean create the ODBCs on the server? I have checked the Data Sources on the server from Control Panel - Administrative Tool - Data Sources (ODBC), and they are fine. Ian

Hi I am having a lot of difficulty setting up scheduled jobs to backup tables from Symposium Call Centre Software. The DTS packages are running fine, when called manually, but the jobs always fail to run. The following is the error returned: Executed as user: NHSDW\sqladmin. DTSRun...

Hi I am having a lot of difficulty setting up scheduled jobs to backup tables from Symposium. The DTS packages are running fine, when called manually, but the jobs always fail to run. The following is the error returned: Executed as user: NHSDW\sqladmin. DTSRun: Loading... DTSRun...

Hi Can anyone tell me what period of time an interval covers. For example, is the 07:00 interval summarising the activity from 06:45 to 07:00, or is it covering the period from 07:00 to 07:15? Ian