Viewing 15 posts - 181 through 195 (of 276 total)
The easiest way is to connect via Excel (2000 or XP even better) and use the pivottable feature to connect to your cubes as external data sources.
Start Excel and click...
June 29, 2004 at 5:58 am
AS doesn't have the built in option to use or not use a particular processor like SQL has. But if you go into the AS server properties (in AS manager,...
June 29, 2004 at 5:47 am
Thanks for all the info. Got it sorted out now....
June 23, 2004 at 4:31 am
Yes, that works. I had a problem trying to register the AS server from the SQL Server, but this was because the AS server was at a lesser service pack...
June 17, 2004 at 5:45 am
can this be automated somehow? i don't want to have to manually do this every day to update the table.
February 20, 2004 at 1:39 am
There is a fixed database role called "db_backupoperator". Can this be used for the backups such that the system administrators (responsible for backups here) cannot access the database? Is that...
February 11, 2004 at 8:22 am
Thanks for the info, Allen. Regarding #2, can you expand a little? If you do this, how does the payroll app communicate with the database? Or are you saying that...
February 11, 2004 at 1:09 am
i know. it's not practical but that's what they are asking. i have to placate them with some info on the subject.
seems like there should be a way to...
February 10, 2004 at 10:01 am
Beleive it or not, I'm still coming up missing the dates using count(*). I know it's something stupid with the nulls. I may try using a temp table as an...
October 2, 2003 at 6:32 am
Vladan - thanks for the info. I'll try a search. In the meantime, I've tried your method with a temp table loaded with all dates but still can't get the...
October 2, 2003 at 6:02 am
No changes made to programs or code whatsoever. Only consultants change the code (they haven't been here in weeks) and only I update the server software.
May 6, 2003 at 12:47 am
Minimum requirements are Win NT 4.0 SP5 or later. Why dont you upgrade to Win2k?
February 25, 2003 at 10:15 am
What version and service pack are you running? We found out recently the SQL2k SP3 service pack for Analysis Services causes problems when accessing the cubes. I don't have a...
February 25, 2003 at 10:10 am
Thanks for the replies. Good rant too. That was my first thought. Would anyone actually recommend encryption in this case? This was upper management's idea, so if I downplay it...
January 22, 2003 at 2:31 am
Viewing 15 posts - 181 through 195 (of 276 total)