AGING MDX Part 2

#1

Thanks for helping... Can anyone assist further with this enquiry?

I have two dimensions: Customer and Period

I have one Measure: Debt

I need to create the following:

Quote:

30 Days, >60 Days, >90 Days.

Here is a snippet from the table:

Name Debt Date
Client 1 500 05/03/04
Client 3 1000 07/06/04
Client 2 100 01/01/04

So I would have the following report:

Name Debt >30 Days >60 Days >90 Days
Client 1
500
Client 2
100
Client 3 1000

Can anyone assist?

Thanks!

#2

Solved. Please ignore.
"AshVsAOD" <.> wrote

Quote:

Thanks for helping... Can anyone assist further with this enquiry?

I have two dimensions: Customer and Period

I have one Measure: Debt

I need to create the following:

30 Days, >60 Days, >90 Days.

Here is a snippet from the table:

Name Debt Date
Client 1 500 05/03/04
Client 3 1000 07/06/04
Client 2 100 01/01/04

So I would have the following report:

Name Debt >30 Days >60 Days >90
Days
Client 1
500
Client 2
100
Client 3 1000

Can anyone assist?

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

AGING MDX Part 2

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

AGING MDX Part 2 - 06-06-2004 , 07:37 PM

Re: AGING MDX Part 2 - 06-07-2004 , 01:42 AM