Skip to Content
0
Former Member
Feb 17, 2009 at 08:04 AM

How? Replacement Path Formula Variable w/o drilldown by Ref Char

429 Views

Hi BEx experts,

I'm facing the following puzzle... Can you please share your thoughts?

Report Requirement: To display the last (aka most recent) posting date for an Account.

Example: Account 100001 has records for posting dates 01/01/2009, 01/15/2009, 02/15/2009, then report should show:

Account No. || Last Posting On

=======================

0100001 || 02/15/2009

Current Prototype:

1. I created a Replacement Path Formula Variable on Posting Date (0DATE Char), with exception

aggregation = MAX on Account.

2. I pulled this formula variable into my KF structure as a CKF.

Result:

If Posting Date is in the drilldown, then this solution works on the Results Row, where I do see the last posting date. However, if Posting Date is removed from drilldown (how the report should look) then the KF returns 'X'.

Is there a way to meet the reporting requirement at query level, without including Posting Date in drilldown? I would like to avoid creating a backend KF for Posting Date in my underlying infoProviders.

Thanks in advance,

Jenni Lai