So just to clarify, the stitching together isn't to include the actuals, it's more just FC1 +FC2 + ... + FCn? Versus the approach of Actuals_To_date + FC month values...

You're on west coast and server is on east coast?

I think you'll want to use SCOPE. Here's a very similar requirement with a reasonable example.

SQLChick has a reasonably good intro (there are several others out there too). You're looking for configurations and parameterization, which at a glance, this sems to cover off nicely.

I tried Google once Alvin but the data throughput wasn't fast enough 😉

Am assuming you're concerned about the available seats measure. To me, you've got a design issue, the available seats shouldn't be part of this particular fact table as...

There is a sample plus some videos etc (prob more on youtube) at the bottom of that page that shows how to use the lookup.

🙂 like to add any more restrictions?? How big is 'huge'?

As I've said a couple of times, go with a lookup.

Linked servers could do it.

But for pure SSIS use a lookup on TableA, effectively let's you join.

INSERT INTO tablec SELECT B.* FROM TABLEA A JOIN TABLEB B ON A.GroupID = B.GroupID AND A.Status = 'READY'

This is the TSQL, the SSIS approach can either use the TSQL...

Typically into the surrogate key. I would have thought this was for late arriving dimension values, not facts (this is usually used for early arriving facts with late, or never,...

No. I haven't yet seen anyone successfully do this.

Whatever system that's in place to refresh or reprocessing the cube has failed. You need to process/ reprocessing the cube. Just be aware or careful though, processing may...

You could try Craig's approach, detailed here

I'll go one better than Koen, use the Labs - they're free, they last 90 minutes, they come with tutorials... they're here.