Is it a SSIS or SSRS problem?  If the former, then you could try adding an event handler for the taskfailed event, or even for the variablevaluechanged event, and then...

Not sure if I'm over simplifying the requirement, or maybe assuming AS2K5 is smarter than it is when dealing with empties but, is the Non empty even required?  if you're using...

Not sure if when yuo talk of the Referenced Dimension you are talking about Role Playing dimensions, but if not, take a look at these to see if they can...

On the formating side, have you tested with different casing on the parms (e.g. YYYY instead of yyyy, same with weeks)?

Dave's spot on re:using Reporting Services. I would add the following points too: i) once produced in RS, the user can export to Excel (if still required) or pdf easily;...

If you're using Excel 2003/XP (and I *think* 2000) then you can download and install the Excel OLAP Addin. This provides both 'strict' pivottable reporting (like the current Excel...

I think i'm struggling this Friday also   Agreed you can definitely count the -1's, either from the fact or the dim.  The dim...

I think part of the problem you'll run in to is that the count of all customers in your fact where the cust_id was NULL and is now -1 is...

Just to confirm, you're opening the xmla file and when prompted, connectig to your (probably local) AS2K5 server?  i.e. you're connected to an AS server before you attempt to execute...

While not exactly an answer to the question asked, you could work around this by not having a null FK.  ie have a value of say -1 in the FK,...

Sorry, obviously skim read the earlier post :S

On this domain account (that's to run the App Pool) have you added it to the IIS_WPG (windows) group on the IIS Server?

Supposedly for RS2K5 only log on as a service is required (see here -> http://technet.microsoft.com/en-us/library/ms143504.aspx#Review_NT_rights)

RS2K apparently did/does require the Log On Locally (see here -> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx#ETHAE )

To David's point (don't use AS to generate a mailing list), i generally agree although witht he UDM in AS2K5, this is the type of relational info that is expected...

Can you also post what version (2000 or 2005) you're using?

Ave,

What are you actually wanting to see in the final result? If that Cust_address table truly is a multiple line address per customer it seems a little strange to...