Typically you'd do this using look-ups but these are a little slow in DTS (SQL 2K). If you can, load your data to a staging table and do your...

I think I have it sussed, I finally got it to return *exactly* the same result as Excel. I think the problem (re: the last param inclusion or noninclusion)...

Hi Jeff,

I think what you're looking for here can be found in the cube roles. AS access is driven solely by Windows authentication, so each role can have members...

Geez I hate maths....

I got it to work but not being overly into stats, I can't say that this is actually going to help....Anyways, here's the code, a simple example...

Hi Ray,

You can aslo use SQL to access the cubes (there shopuld be a post about how to do this *somewhere* back in the history of this forum), but it's...

Hi Ray,

Normally conversion is not overly easy (I used to open the cubes up in Excel and use it's local cube saving functionality). But, there is a really cool...

Hi Nico,

I mucked about using the same technique but not using DSO (same concept different requirement). I basically gave it up. Although you can do error handling (of...

Hi Colin,

Have you optimised the model? You may/may not be able to do this based on your current join strategy.

By optimising the model (where possible) it means that the...

Hi Scott,

have you got the latest MDAC installed on the client machine (ie where the crystal is installed)?

When you try to connect, do you see one or two MSOLAP drivers?...

As a slight twist on Michaels suggestion, we always try to use negative numbers (e.g -1 = n/a , -2 = unknown etc) for these types of placeholder/catch-all values, this...

Not sure about using the Excel functions in TSQL, but to use them in AS, you do need Excel installed.

If you're wanting to use PV in TSQL you could...

Hi Elizabeth,

Is there a reason why you are creating a calc measure for this? If not, can't you just use the measure "Standard2" as it is, remove the lowest...

Hey BABs,

As far as migrating from DEV to PROD, there's a few options. You could archive the database on the dev server, and then restore it to the Prod...

Workaround is Office XP related (repair), true fix is as per Ryans suggestion.

Jason, check out msdn article with your issue ->

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b297232

Steve.

Hi Krishan,

YOu might want to try posting import/export type questions in the DTS forum.

Having said that, it sounds like you will want to use DTS to load the excel data...