Thanks for the response.  Referrals are for tellers, booked is for CSRs.  We're going with creating and populating a table specifically for the reports that use this process and expect...

Thanks for the reply.  In the original query, COUNT(*) was used to sum the # of referrals and booked for each employee.  This wouldn't have worked with the rewrite because...

Thanks for your reply. I inadvertently left out the fact that the cube is going to be the source for reports surfaced in PowerPivot and PerformancePoint. My idea...

Thanks! That will do the trick...

It's been a while, but IIRC Eiffel allows the developer to choose which properties, methods, etc. to inherit from each parent, so there aren't the pitfalls of C++, in particular....

By your reasoning, all of us should be required to take a course in transmission repair before we're allowed to drive a car.

IMHO, the legacy the C/C++ is...

No, it's a requirements/qa application and there are many possible hierarchies. Capabilities->Features->Testing Requirements -> Test Cases -> Validation Categories is one that I'm working with at the moment. ...

There are 321K rows in the Document table and 41K rows in the linking table.

I'm not working with a hierarchy, but a "multi-archy". I've tried flattening-out the hierarchy into a temp table and in just 3 interations (2 child and i parent) I've...

Thanks for the reply. I've been working with the adjacency model. It requires a single root. I have thousands of "roots" and I haven't figured out how...

Hi,

I had 3/6 cubes that were on the server and were not showing up in Excel. On further investigation, those 3 cubes had no "facts" associated with them. ...

Thanks! My idea was to create a parameter-driven package for each database, where I could change the source and target databases and then the package would handle everything else.

The...

Thanks, people, for the responses.  I have a package that is going to be run several times a day.  It will check for the presence of a file.  If that...