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.