I think what you're need to do is update the database names after processing. https://docs.microsoft.com/en-us/bi-reference/tmsl/alter-command-tmsl

I would use the letter denoting the source system. I would convert the int to a uniqueidentifier though with a hashing algorithm. The natural key is then [Source System], [UniqueId]....

What I usually do for different grains on date is to make two tables internally: DimDate, DimMonth for example. Date has a direct relationship to month, many to one. Tie...

You need to be in the server admin group, not the model admin group. To check: use SSMS and connect to the SSAS instance you are trying to deploy to....

The one with the GUID is one that you're currently using for your working environment (or one that was left over). Close VS and see if it disappears. If not,...

For question #2, it's not an exact science, but if you figure the uncompressed size of the data and it follows a typical pattern then it's approximately 10% of the...

If you are doing a full process of the cube, you need twice the memory (more or less) that the data will take. You can shrink this by partitioning the...

This sounds like a problem that is pretty common. You need to establish a connection before you change the model. I generally process the table before trying to make changes....

That's right. That's the reason for keeping Amount and Denominator separate. Create a measure for each and hide them. Then the final measure is Amount/Denominator. 

DAX pseudo-code:
CALCULATE(DIVIDE([Amount], IF(ISBLANK([Denominator],...

This sounds similar to something I just did. I have a "measures" dimension and a fact table that has two measures: Amount and Denominator. If denominator is blank I use...

Depending on whether you're using MD or Tabular, there is a sort order or order by column property. Use this to control the sort order and make another attribute for...

What you have described is that it's processing default rather than full. The row counts you see are the rows that are already in the cube instead of what's in...

Is it that you just want to update the data and it's not updating? Sometimes the cube process default is not sufficient. I run into that where I've made a...

I do this with an XMLA script to be run at the end of the deployment. I haven't done this the way you're trying to so that may be a...