Processing all the dimensions first and then the cubes should work. If it doesn't, it might be because you're not doing a "full" process on the dimensions or you may...

In my experience it is usually locking/waiting of some kind (if you're referencing an external file, server or system), or a delay with the BIML add-in in VS/SSDT. You could...

It's important to understand your use-case better, before making decisions on a best way forward. Could you provide more details about that?

I don't necessarily pre-stage (with two separate staging areas), but I do prefer to do no (or minimal) transformations when I bring data into the staging area. All my transformations...

Scheduled I'm not sure about, but you can use the SSAS flight recorder to collect query execution info either to a table or log file. Look at the instance properties...

Aggregations will help with performance and is definitely something worth looking at. You're right, proactive caching isn't really what you want to do here...you just want to warm the cache...

yes, true 🙂

I totally agree that the SCD object is far from ideal.  However:  1) the data set is very small (just a few hundred megabytes of data), 2) we are...

• This reply was modified 5 years, 9 months ago by Martin Schoombee.

Hi Brad,

When it comes to Oracle I've had better luck installing the version-specific Oracle ODBC drivers, creating a System DSN and then using that in SSIS. The Microsoft SSIS driver...

It is recommended, yes...chances are that you most likely would want to add the durable key (or a surrogate key if that's what you meant) to a fact table as...

That's an excellent question.

My opinion only, but I'd recommend Power Query. From what I've seen coming from Microsoft lately, I wouldn't be surprised if PQ became the defacto language for...

I don't know of any method unless you've been tracking it by capturing the metrics periodically, or have some 3-rd party tool that stores it. If you have historical SSAS...

You can't pass the result set directly into the file system task. Instead, pass it into a For-loop container and then set another variable with the value of the current...

Sadly there is no option to do that in SSDT. What I usually do is script out the roles of the PROD database, and execute to recreate them after deployment....

Also try to set the DelayValidation property on the DataFlow task itself.

A safe approach I usually follow in these scenarios is to create an empty template file with the same...