Chris Umbaugh (6/9/2011)

---

Is there a reason that you must have a new cube if you already report transactional data in another cube? "Subscriptions" sounds to me like a slowly changing...

Thank you very much for your advice. I do agree, I'm not thinking about this correctly and battling to solve it. That is why I've turned to forums after many...

I've created the data tables for this scenario. However, as soon as I get to the upgrades, I begin to stumble.

A simplified version of the Data Model is as follows:

DimensionTime

TimeKey

Time...

Hello Cozy Roc,

Thanks for the advice, yes I have seen that destination. This doesn't serve the XML multi-level completely. I do believe that it should be native to SQL SSIS.

However,...

There has got to be a simpler way to get the column name from the lineageID?