Correct. It all depends on the situation and the environment in which you work.

That is certainly another path you can take.

The only other thing I can think of is the driver on the machine running Excel; however, if I am reading this correctly, you are able to see the cube...

Right now the only thing I can think of is that

1. The user browsing by Excel does not yet have cube access (as already stated).

2. The Measure Group is...

When you say "at the end of your ETL", do you mean:

1. Load DBMS dimensions and facts, THEN Fully Process Dimensions and Facts?

2. Process 1 SSAS object at...

It would have helped if I read "choose 3!". There goes my hot streak!

Charles Kincaid (1/17/2014)

I added the emphasis. Yes, understanding this execution order is why I have been able to write good performance filtered...

That was a nice one--though I have never encountered a case where I would intentionally use a filtered index on a table that also has an indexed view on it...

I try to visualize any join as a Venn diagram. To me it is a great teaching tool--especially if your pupil knows statistics.

I really hope the release after SQL Server 2014 starts to address the metadata management issue. Sqlmetadata.codelpex.com has done an admirable job synchronizing metadata from the BI continuum, but...

Definitely a PITA....something we don't want to do for the end user.

When there is more than one "budget scenario" for which you are modeling, it may get a little hairy. This Kimball Design tip suggests the single table approach for when...

Some consider actuals and budget two different business processes that deserve their own fact tables. Then, a second level consolidated fact table can be created from those two business processes...

A DSV will auto-detect foreign key constraints between a fact and a dimension, but foreign keys add unncessary overhead to an ETL process.

The approach to create the relationships in...

While there are many limitations to the Tabular Model, the tabular model is great tool for accelerating a prototype from power (excel) user to IT and even reusing that work--increasing...