First design what you want to do from a theoretical approach, then figure out what tools you need to do it.

The most obvious components are going to be data flow...

I had read your post and couldn't come up with any ideas to help you out, but it seems like you've come up with a good one! So does...

Maybe there's just not enough information here for this to not be an obvious idea, but SELECT DISTINCT from your source table?

Watch the webinar that's happening this week. There are a couple that would probably make sense. Here's the link: http://www.sqlservercentral.com/articles/webinar/65678/

I've also had much better luck with the downloadable OLE DB Provider for iSeries. You can find it here: http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/DB2OLEDB.exe, but you need Enterprise or Developer Edition, apparently.

Assuming you want to send 1 email to everyone at the same time, write a query that will return these with semicolons between them. Put this query into an...

You can send the data "directly" from the Oracle data source into the SQL Server tables using an OLE DB Command, but I have to warn you it's MUCH slower...

It looks like to build this into the cube, I have to build them as Sets. This is nice from a presentation perspective, in that they show up in the...

Anything simple like that for This Week? Not having the "ww" type functionality in the FORMAT(NOW()) makes it a lot more complicated, and googling doesn't seem to bring up...

Thanks for the great series (if 2 = series) on Date Dimensions. It certainly relates to me, as to just about any Data Warehouse developer. I definitely learned some great...

William, I'd like to take a second to thank you for that amazing series of articles. I have used them as tutorial, reference, and example many times.

It's been a...

Ahh, I see. It's basically the only role, so you can give users that aren't admins privileges to use the cube. Did you give them permissions to any...

Since I don't know that much about this problem in specific, let me give you a couple of thoughts:

1. It might be worth checking to see if it works within...

Can other roles see the measure, or no one can see the measure?

Is this for interviewing someone that will only do SSRS work, or as part of their larger responsibilities? Are they supposed to be experienced SSRS people?

You could go into...