Excuse my left-field question (I don't have an answer for you), but why would you want to copy something to the clipboard?

Are you able to connect to the cube with SSMS, and are you using the same server/port combination when attempting with Excel? I haven't seen this error before, but would...

Could be due to the type of your parameters, if they are not text/string types. Also could be that the variables used do not have any values when the package...

I second Lynn's comment...give us some examples of what you're seeing and what you're expecting to see. It almost sounds like you have additive numbers (measures) in your type 2...

Assuming that you are going to do a full processing every time, you can create a dimension based on a "select getdate()" query.

It's a lemon...might as well make lemonade 🙂

I would be more inclined to create a proper star-schema that looks something like this: 

DimReport (ReportKey; ReportName; ...)
DimFund (FundKey; FundName; ...)
DimDate (DateKey; ...)
DimUser (UserKey; UserName;...

Somewhat 🙂

The point I am trying to make is this: If I am more concerned about seeing report-level information (i.e. which report was run when and by whom),...

Kudos for the detailed information in this post!

Before deciding on the best design, I'd recommend that we first consider how this data will be used by the end...

Thanks for the clarification. I've personally never seen it happen that the measure groups are processed before dimensions...it's just not the way Analysis Services is wired. Not discrediting your experience...