"Show All Tables" in a multi-dimensional SSAS project will show all the tables that were included in the Data Source View. It doesn't mean that those tables are used in...

From the error message it looks like you do not have the underlying .NET library installed. Google "Renci.SshNet" and you will find more details about that library.

Also wondering why you...

It really depends. Are we talking about a multi-dimensional or tabular cube, and what are the contents of the other tables?

Thanks, I've dealt with Temporal tables a bit 🙂

It is unfortunate that the MDX language doesn't support ranged queries (outside of the members in the Date dimension) very well. If...

Interesting use of a Temporal fact table 🙂

MDX doesn't do well with aggregates over ranges or where there is no data point (tuple), which is the case you have here....

What does your fact table look like?

Completely agreed. This line of thinking is really archaic and stems from many years ago...

The notion that opensource software (or any ETL software for that matter) does not require developers to support and maintain is marketing BS. I'd argue that while opensource software is...

The end result is a tabular cube and both essentially use the same underlying engine, but there are a few slight nuances and I know the product team is working...

From what I can see, it looks like there's no "where" clause in your update, so naturally all records will be updated.

That is correct. You can also use DAX to create calculated columns and tables.

It's difficult to give accurate advice without knowing the data or your requirements, but it seems odd to have a many-to-many relationship between your two facts.

Do you need to use ...

• This reply was modified 6 years, 3 months ago by Martin Schoombee.

Yes and yes. In the case of direct query, I'm not sure if DAX Studio will show the actual SQL executed against the source database, but a Profiler Trace definitely...

You may be missing the purpose of a role-playing dimension. In the case of a Date dimension, you only need to consider creating multiple versions of the dimension if you...

Will it work? Yes, although I'd recommend the use of a surrogate key in the relationship between your dimension and fact.

Not knowing your exact requirements, I do want to question...