Viewing 15 posts - 1,096 through 1,110 (of 1,839 total)
PTS = Pivot Table Services, the underlying way that all tools communcate with AS2K (there is no way but via PTS, it was so good, they rem'd it from...
February 16, 2006 at 5:00 am
Not sure if it changed from SQL2K to 2K5 but the 2K5 doco shows tempdb being based on model (like all other user DB's) (from BOL -> The tempdb database...
February 16, 2006 at 4:48 am
From the SQL2005 BOL --> re: RS Aggregate Functions, look to RunningValue function.
Returns a running aggregate of the specified expression.
Syntax
RunningValue(Expression, Function, Scope)
Parameters
Expression
(Data type is determined...
February 16, 2006 at 4:44 am
Do you have to use the URL or could you use the webservice? With the webservice you can easily set the uid/pwd for the call.
If not, I can only...
February 16, 2006 at 4:39 am
If you have an MSDN subscription you should be able to download it directly from MSDN. If not, I think you need to speak with your local Msft sales...
February 16, 2006 at 4:37 am
Sounds like you need a dual axis chart, which I don't think is available in AS. If you find it is, pls let me know!
February 13, 2006 at 6:06 am
I haven't used Crystal to access AS cubes but to generalize, a lot of OLAP front end tools do allow for access to AS cubes. You could use either...
February 13, 2006 at 6:05 am
RS is basically 'free' and licensed as per your SQL license *except* when you install it on a server other than your SQL server. So for a big site,...
February 13, 2006 at 6:01 am
OK, lots of options here, I typed heaps before but now will do it...
February 13, 2006 at 5:43 am
Well, there is always copy|paste of the entire project, but do it via Windows Explorer rather than in the UI. As every file in the entire proj is an...
February 13, 2006 at 5:02 am
I'm using Dev edition so it could be different, but if I have two AS projects open, I can right click on a cube (in the cubes folder) in Project1,...
February 12, 2006 at 8:28 pm
2005 has changed the way drill thru works. It could be argued that it isn't really drill thru anymore. One of the guys from the AS team published...
February 9, 2006 at 6:28 pm
Hi Paris,
Yeah, this is a not very nice piece of AS2K functionality. In general, no, you can't change the DS name. The options for doing this are:
1) try...
February 9, 2006 at 4:55 pm
In the cube designer you can select which columns are returned for the drill through queries (this is a bit annoying because it means that you either don't supply enough...
February 9, 2006 at 4:07 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,839 total)