Skip to Content
0
Former Member
Jun 27, 2014 at 09:09 AM

Total Overdue Count based on dates in Bex Query Designer

209 Views

Hi Guys,

I have a requirement where I need to find the total overdue count based on the end date and current date.

I have implemented the requirement by creating Overdue CKF where in I have used 2 CKFs, 1st CKF for Current Date where in I have used formula variable fetching current date via customer exit & 2nd CKF for End date where in I have used formula variable fetching end date via replacement path.

Also I have created a Active Count RKF where in I am using active status filter with the Count KF coming from the Data Model.

Remember, the count KF may be 0/1/2/3/4 ….value for a record.

In the Overdue CKF I have used the below formula.

“(Current Date CKF > End Date CKF) * Active Count RKF “

Now the challenge is that the above Measure is populating/displaying values only if we keep at least one characteristic in the Query. If we don’t keep any characteristic then its showing blank.

I have tested the sub CKF’s and they are populating fine.

The challenge is only with the main Parent CKF wherein it needs reference with at least one dimension to show/populate the values.

Basically I need to aggregate each record value (measure value can be 0/1/2/3/4/ .... for each record) for all the records which ever passes the rules & display without any reference.

Please let me know your thoughts as to how can we implement this requirement at BEx level.

raps.