Do you (could you) have a Scenario dimension?  If so, then assume the 'base' data is scenario 1, change the dimension to scenario 2 and write back your figures.  If...

You might also want to review why you're doing this. If you coerce all empty/null cells to having a value, how can a user determine the difference between a heavily...

What values did you use in your connection?

After selecting the Oracle Ole DB driver, you should be presented with a second tab on the dialog asking for a servername, username...

Hey Paul,

You might want to try creating the view within Query Analyser, saves you from the graphical designer errors.  The first error was raised because the graphical designer doesn't require...

Yep, the quick reply (ie *not* using WYSIWYG) escapes out all the xml/html tags

Here's another try, have included the CC and BCC.

USE ReportServer

GO

 ...

Again, it depends a little. Seeing as you've gone towards the SQL, then it sounds like you should modify (or create) the view that you are using as the...

Depends a little on how/what you're trying to do what you're doing.

If the U and H within the ue_typ is a desriptive type of field, then this should remian a...

note in the cmdline call, I had put my machine as < my_machine > which was removed when posting. servername is obviously the first parm after the /A.

Hi Trevor,

I'm still not sure how you're getting the different file size. I just did a quick test on my foodmart and they come out identical.

When doing...

Hi Paul,

The following should work

SELECT

Schedule.ScheduleID AS SQLAgent_Job_Name,

Subscriptions.Description AS sub_desc,

Subscriptions.DeliveryExtension AS sub_delExt,

[Catalog].Name AS ReportName,

[Catalog].Path AS ReportPath,

SUBSTRING(ExtensionSettings, LEN('TO') + CHARINDEX('TO', ExtensionSettings),...

I think the problem is in your WHERE clause. In SQL (so this could be different for Access as we use named parameters not '?') your clasue would be...

The msmdarch.exe really just makes calls to the same COm objects that the MMC (Analysis Manager) does, so it shouildn't produce a file that's smaller. When archiving (as far...

If you look in the ExtensionSettings column of the Subscriptions table, there is an XML string that contains the relevant settings for the delivery extension. In this (email) case,...

I was getting the 500 error to, but I think this is due to having your browser set to displaying 'friendly' http errors (you can change this in tools|Internet Options|Advanced|Browsing...

I got this to work using AS2K5 (naed instance on my local machine) and Excel (2003). What (if any) error message/s were you getting when trying to connect?