Andreas Michael (9/30/2016)

---

yes, that's right, I did this.

When you hit "save as", you can...

I'd rather use a view.

If you update the staging tables themselves, you lose their prior values, which might make debugging a bit harder.

Sometimes it boils down to personal preference though.

Usually I do this with the command line. Something like this:

Setup.exe /Action=Uninstall /FEATURES=RS /INSTANCENAME=MSSQLSERVER

For multidimensional, normally there aren't any issues to be expected since not much has changed.

However, one of my clients hit a bug where they could only deploy/process a cube once....

I'd check for locking/blocking.

Maybe a filtered index on the order status table that only keeps the current statuses?

Do you apply transformations on the staging tables themselves? (aka using update statements)

Or are you using views between staging and the data warehouse?

Aside from the full load, it seems you're...

You can open a mobile report in the Mobile Report Publisher.

There you can add multiple server connections.

When you hit "save as", you can choose to which server you want to...

Easy one, thanks.

Nice easy question, thanks.

Nice question, thanks.

Nice question. Glad that they don't support the FROM A,B WHERE A.ID = B.ID syntax monstrosity.

Easy one, thanks.

Great question, thanks.

pietlinden (9/26/2016)

---

Martin,

That's what I was afraid of... My brain might explode.

you know you're in for a rough ride when Ferrari & Russo freely admit that "DAX is hard"... uh...