Re: Need to find the top 10 Borrowers per Office over a rolling 12 months

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "ScottC" <scarmody@xxxxxxxxxxxxxxxxxx>
Date: 9 Mar 2007 09:37:18 -0800

Forgot to add..The ranking would be based on a Measure called
Transactions which is a count

On Mar 9, 11:34 am, "ScottC" <scarm...@xxxxxxxxxxxxxxxxxx> wrote:

I am stuck on a query to get the top Borrowers per Office over a
rolling 12 months. My dimensions are Office (OfficeName level),
Borrower (Country, State, BorrowerName levels), and Time (Year, Qtr,
Month, Day levels). I need to produce something that looks like this:

Apr 2006 May 2006 .... Feb 2007
Mar 2007

Chicago XYZ Corp ABC Corp Dunder Mifflin James
Dunn
Maxim Grp James Brooks XYZ Corp
Anaka Corp
.
.
.

Houston Dundus Grp Stevens Corp MicroPro Trizec
Corp
.
.
.

etc

Any ideas

Follow-Ups:
- Re: Need to find the top 10 Borrowers per Office over a rolling 12 months
  - From: Ef

References:
- Need to find the top 10 Borrowers per Office over a rolling 12 months
  - From: ScottC

Prev by Date: Need to find the top 10 Borrowers per Office over a rolling 12 months
Next by Date: RE: Determining AS 2005 Version/Edition
Previous by thread: Need to find the top 10 Borrowers per Office over a rolling 12 months
Next by thread: Re: Need to find the top 10 Borrowers per Office over a rolling 12 months
Index(es):
- Date
- Thread

Relevant Pages

Re: In our fondest dreams ...
... the lender is some monstrous beast. ... you have two parties -- the borrower and the ... you don't stop the wolves from eating the rabbits, ... Half this country won't educate people. ...
(rec.woodworking)
Need to find the top 10 Borrowers per Office over a rolling 12 months
... I am stuck on a query to get the top Borrowers per Office over a ... rolling 12 months. ... My dimensions are Office, ... Borrower (Country, State, BorrowerName levels), and Time (Year, Qtr, ...
(microsoft.public.sqlserver.olap)