I don't think you can have different partition structures. In SQL Server I know you can't but SSAS I'm not as sure, but still pretty sure. However, since compression is...

If there is a way to do that, I think it would be in coding the measures. Unfortunately, that's beyond my skill level in MD at the moment.

Hi David, 

I'm not sure I follow all the relationships, but SSAS MD does inner joins on everything even if it's not in the query. That's why the rows...

Tabular does sound like the way to go from what you are describing. Are area & sub area a hierarchy? If so, you'll want to model them in one dimension...

From what you're describing, it sounds like Dim1 is the parent of both the Fact and Dim2, but the Fact and Dim2 have no relationship other than ps_id. If that's...

I'd review your M2M relationship. Unfortunately, I'm not that familiar with M2M relationships in MD so I can't give any other recommendation.

Is this a multi-dimensional or Tabular cube?

Is [MEASURES].[LS Anzahl] a calculated member? If so, please post the code.

When you create a Tabular model you deploy it to an instance of Tabular SSAS on a server. Then the users will open Excel, Data tab, "From Other Sources", "From...

It's a different mechanism, but the concept of users making their own reports is the same. Excel Pivot Tables is a common tool that most users will have that can...

If you have enough to do, it's worthwhile to learn the format of the XML. Make sure you back it up before making any changes though.

Hi Polkadot, I supplied an answer for this on the other thread.

The above identifies one issue. Also, it looks like 'POEC Delivery Types' is a table. This should be a single column.

That's great!

A little background on this cube - Most of the data is pre-aggregated to the monthly level. The POS Units are at the weekly level. There is no day level...