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