If you currently are doing any summary tables off the data, you could use them as a guideline for Dimensions and Measures you'd want in the cube.

You'll always have a...

Is creating an application to allow data entry / maintenance - getting the data into SQL server, out of Excel, an option?

Then you wouldn't have to worry about importing. And...

Try setting just your variables and then print them. Sometimes when working with a Date Timestamp, you aren't getting the value you expect.

Greg E

I agree more with Steve. It's way too easy to post information / create a site posing as someone else. And even more difficult for the real person to get...

Run your VS, then run the same test going through your website.

Take a look in the security log on the SQL server and see what User ID is being used...

It sounds like you have both SQL Server and Analysis services on the same machine.

Be sure to limit the memory for SQL server and adjust SSAS memory too. Consider what...

I recall the first time you access a Citrix server, you can allow access to your local files.

You might have them delete your profile on the server and see...

here's a snippet of taking a date and making a column for grouping by week.

select

*,

cast(datepart(yy,salesdate)as char(4))+ ' - ' + cast(datepart(wk,salesdate) as char(2))

from

#daily

you may want to experiment with mm too

Greg...

check out DatePart in books online.

Just remember that a week can span 2 Calendar months....

Greg E

Don't know if you need a Fiscal Calendar, - in ours, every week starts on Sunday and ends on Saturday, with 4wk, 4wk, 5 wk months. It has Calendar Date,...

Just in case you find yourself needing to reboot a service....not because you'd need to on SQL Server 2005. I've found this platform manages memory much better than in the...

Sounds like parttioning and incremental updates are something to look at.

http://msdn.microsoft.com/en-us/library/ms133905.aspx

You also might want to look at slowly changing dimensions too. How you handle these would also have...

In the Help file, the feature matrix lists x64 support for Standard and Professional editions, but not Developer edition. Std and Pro both also have Enterprise console, so installs from...

SQL 2005 seems much more granular in security, and the default in many cases in more restrictive.

If you can test Basic Authentication on a web site, you can see if...

What context is the Application Pool running under?

Sounds like Network Service.

If NTLM fails, this is the account that likely will be tried.

Greg E