We have an OU in AD that we manage for our security. It's our OU, and we manage the Groups. This avoids the situation you are running into, especially when...

See if this is what you were looking for.

Greg E

http://msdn.microsoft.com/en-us/magazine/cc163633.aspx

sonashish (10/7/2008)

---

Hello

Thanks for the response. Actually this database is very old 5-6 year old, client doesnt want to change the data structure, so I have no option, I have...

Download a trial version of Dundas. You should be able to find some samples.

This sounds like you'd want to do something like Jan - Mar as series 1 line, then...

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...