Are the really two different measure groups or two different measure in the same measure group?  Have you tried...

As it seems as if you're waiting for an answer, I'm not going to be able to look at this until the weekend.  I want to review one of my...

If that were true, it wouldn't be something he should be aggregating on.  I have...

Make sure you cluster on whatever field is aggregated.  Otherwise the engine will have to do table scans.

Some of those issues reflect inertia and misplaced trust.  Both Truman and the UN wanted to reunite Korea per pre-war UN declarations.  But only if the Chinese wouldn't intervene.  Given MacArthur's...

It's a small but not unimportant choice--a dilemma is a choice between undesirable alternatives.  You simply have a choice, as I have...

It's just a headline grabber.  He uses the more appropriate term "competitors" at the end...

That's not particularly "kludgy", but since you are using 2014 you should be able...

Why can't one of the fact measure groups have a single contract as the granularity and the measures are the aggregations (whether count or sum)?

Distinct counts are tricky and generally if not universally require their own fact measure group in a cube.  Based on what you are saying, what immediately springs to my mind...

If there is a useable business key on the fact table, use it for the primary key, usually though without clustering it.  That's not always possible, but often the fact...

Nothing has changed my original view that each row is a trip with columns for pickup and drop off information. The drop off information is null until the...

I wouldn't use a view either.  I find no use for them in an OLTP environment.  There are a couple of situations where they are useful.  I just haven't had...

Although there is some good merit in a guaranteed "only 2 values" (pickup/dropoff) type of table, a proper CROSSTAB would likely blow the doors off of any view you...

You also may want to consider reworking the table if possible.  If a completed trip consists of both a pickup and a drop off, they could be the same record. ...