You should be able to extract the cube data to Excel, and use the Excel file as source for your table. An SSIS package can be developed to import the...

According to this Microsoft document, processing a cube will only process "unprocessed dimensions", and this is why you're getting the error. If you want to avoid it, you...

It really depends on what type of transformation you are planning to do. The most common properties that can help with performance are the "Rows per Batch" and "Max Insert...

See the following article that explains this property: https://docs.microsoft.com/en-us/sql/analysis-services/lesson-4-4-hiding-and-disabling-attribute-hierarchies

My guess is that the "DelayValidation" property is set to False on either the connection manager, package or data flow task. If you're setting the folder/file properties during runtime, you...

The expression that contains that initial connection string, does it have a value or is it blank? Also, have you set your package, connection managers and tasks' "Delay Validation" property...

Good questions, and lots of "it depends" answers...but I'll try to give my perspective. 

1.  As a BI & Analytics Consultant, I see many companies hire somewhat technical people...

Sorry, my bad...thought that you meant an SSAS instance in the cloud when you said "remote". Assumptions...

Definitely looks like a security/permissions error. When you execute it locally, it...

In your example, the distinct(count(...)) is really nothing other than a count. The count() function returns one distinct value (the count of records), and unless used in conjunction with other...

Creating a filtered view of a cube is possible through what is called a perspective...something that is similar to a database view. However, in your scenario I don't think a...

You are getting the error because there is no way for the SSAS instance to communicate with your local database in order to refresh the data.

You need...

Without any specific error messages we're only guessing, but my number one guess would be that there is something happening on either the SSAS or SSIS server. It could be...

WITH SET returns a set of data, i.e. a combination of dimension attributes and/or measures. 

WITH MEMBER returns one value (usually a calculated measure), meaning one aggregated or distinct...