smunson (8/19/2009)

---

I hate to rain on the MAX of the DATE party, but just using MAX alone isn't going to get the results needed, as what happens when there's more...

It sounds like a calculated column transformation will do the trick.

If that doesn't work, you can certainly do a conditional split into as many outputs as necessary (and hopefully you...

Another option to consider in connection with the hierarchies is building a drill-through report. In your cube, the hierarchy would only go down to a given level (say city)...

I've given you more than enough information to finish this on your own. I suggest you look at what I've already written and try to come up with the...

I modified the code to show you how this would be accomplished. Since your test data only has one school and one district, the numbers by school and by...

This...

I think this will give you what you are looking for.

SELECT IsNull(t2.Event_Total, t1.Event_Total) AS Event_Total

FROM qtr_totalinfo AS t1

LEFT OUTER JOIN t2

ON t1.Event_Qtr = t2.Event_Qtr

Drew

First, we don't need a history of the universe to help you solve your problem. You could have easily started with the unpivoted table rather than from...

Without sample data it's really hard to know, but it sounds like you don't really need to compare months, you just want members who were added this month. There...

It might work with a global temp table. You define a global temp table using two octothorpes instead of just one

Create Table ##temp

The global temp table can be used...

I think the confusion is coming because of the term "Total Customers". There are actually two separate measures which could be called "Total Customers" and you're mixing the two....

As I said...

Revenue should be one of the facts in your fact table and this fact should become a measure when you create and process your cube. If revenue is not...

It's only slightly better. You still haven't provided it in the...

The purpose of BI is to give you the BIG PICTURE about your business. If you're looking at individual customers out of ~ 3 million customers, you're down in...