Create User Object - find age at first referral

[rudraigh]

I'm trying to create a User Object to simplify a report I'm building. I'm trying to find the age of a client at the earliest referral.
I have these three dimensions to work with:
Referral Received Date
Age at Referral
Client Identifier

Can anyone help me out with this?

Thanks for any help.

 

[tommyboyau]

So an example record might look like this?
Client ID AgeAtRef RefReceivedDate
1 12 01/01/2000
1 12 05/05/2000
1 13 01/01/2001

Is that correct?
And you are saying you would want to extract the date of the first of the records shown above?

 

[rudraigh]

Exactly. I would want to extract the most recent record.

Thanks for responding so quickly.

 

[skrandel]

This requires a pre-built filter with subquery in it.

Steve Krandel
Symantec

 

[rudraigh]

Um ... ok. LOL. Although it says Symantec below your name I'd swear you worked for MS tech support. Your response, while technically correct, doesn't help very much.
I'm new to BO and haven't had any training on it. The only book in the office about BO is practically worthless. Could you post an example using tommyboyau's field names?

Much appreciated.

 

[tommyboyau]

Sorry,
I don't have access to business objects at the moment.
However I recommend you have a look into the Min function.

Maybe you could create a variable at your report level with an IF statement.
If(RefReceivedDate = Min(RefReceivedDate) ; 1 ; 0)

Now you have this as a variable you could create a filter on this variable within the report, restricting output to where your variable = 1 (True).

Have a go at that.

Thanks,

Tom

 

[rudraigh]

Thanks for the responses. Since my original question, our tasks around this project have been shifted so this report is no longer my concern. I've been given different fish to fry.

Thanks again for your help.