Skip to Main Content
Merative Ideas Portal

Shape the future of Merative!

We invite you to shape the future of Merative, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the Merative team to refine your idea

Help Merative prioritize your ideas and requests

The Merative team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at Merative works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at Merative, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Merative External Privacy Statement: https://www.merative.com/privacy

Status Delivered
Created by Vinod Musunuri
Created on Oct 16, 2019

Improve reassessment performance when using CER rules

We analyzed SQL stats from Curam Reassessment and observed various calls impacting the performance of the process.

Following are the main categories of SQL calls impacting the performance.
1. Data that is read which is not required for CER rules processing.
2. Redundant data read through different calls.
3. Opportunity to use batch insert instead of regular insert operation.
4. Alternate mechanism to read evidence information to improve the performance. POC attached.

Detailed information of the SQL stats available in the attachment.

Customer Name Ontario - Ministry of Community and Social Services, IBM Corp
  • Attach files
  • Guest
    Reply
    |
    Aug 18, 2021

    Hi Vinod,
    We are pleased to inform you that your enhancement request has been delivered in the new release of IBM Social Program Management, version 8.0.0.

    You requested an enhancement to improve the performance of CER reassessment processing and included suggestions related to the optimization of SQL calls. Based on an analysis of CER reassessment processing along with close collaboration with individuals from the project, evidence descriptor caching for static evidence and suppression of reads from tables not required for reassessment, were identified as the highest value to improve reassessment performance and are delivered in Version 8.

    For more information about this new capability, see the following section in the What's New Guide: Optimizations for Cúram Express Rules (CER) reassessment

    Thank you for taking the time to share your ideas with us. We are now closing this request as delivered.

    Regards,
    Shane McFadden, SPM Offering Management team
    You can find more information on the request process here.
    Note: we are currently in the process of improving your RFE experience and will soon transition to an Ideas Portal provided by our trusted business partner Aha!
    Further communications with additional details will be shared shortly.

  • Guest
    Reply
    |
    May 5, 2021

    Hi Vinod,
    We are pleased to inform you that your enhancement request is included in our upcoming release of IBM Social Program Management, version 8.0.0.0.

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.

    Regards,
    Shane McFadden, SPM Offering Management team
    You can find more information on the request process here.

  • Guest
    Reply
    |
    May 18, 2020

    Hi Vinod,

    Thanks for your comment regarding the status of this RFE and its importance.

    I have followed up and learned that this RFE is being discussed in other regular communication channels so I cannot give specifics here as to when it may be delivered.

    Thank you.
    Shane McFadden, Cúram SPM Product Management team

  • Vinod Musunuri
    Reply
    |
    May 14, 2020

    What is the status of the RFE? Due to COVID - 19 situation we are getting more and more applications for benefits and our system is under a lot of stress lately. We are doing everything we can locally to relieve the stress on our database but this enhancement is expected to give us a lot of improvement in terms of performance. So we would really appreciate work related to this RFE is given priority

  • Vinod Musunuri
    Reply
    |
    May 14, 2020

    What is the status of the RFE? Due to COVID - 19 situation we are getting more and more applications for benefits and our system is under a lot of stress lately. We are doing everything we can locally to relieve the stress on our database but this enhancement is expected to give us a lot of improvement in terms of performance. So we would really appreciate work related to this RFE is given priority

  • Guest
    Reply
    |
    Dec 20, 2019

    Hi Vinod,

    We acknowledge that this enhancement request has been accepted for consideration. It may not be delivered within the release currently under development however the theme is aligned with our current multi-year strategy and will be considered for a future release.

    IBM may consider and evaluate any RFE Community feedback for this request through activities such as voting.

    IBM will update this request in the future.

    Thank you for your interest in the Cúram product.
    Shane McFadden, Cúram SPM Product Management team

  • Vinod Musunuri
    Reply
    |
    Dec 16, 2019

    Attached is the reassessment times on a sample set of cases. Our cover period frequency has a monthly pattern. This mean each month is seen as pay period.

    From the attachment it appears that there are two major factors that are resulting in slow reassessments.
    1. Number of evidences
    2. Number of past pay periods i.e. number of months between the case start date and the latest cover period to on ILI

    Please let me know if any additional information is required.

  • Vinod Musunuri
    Reply
    |
    Dec 16, 2019

    Attached is the reassessment times on a sample set of cases. Our cover period frequency has a monthly pattern. This mean each month is seen as pay period.

    From the attachment it appears that there are two major factors that are resulting in slow reassessments.
    1. Number of evidences
    2. Number of past pay periods i.e. number of months between the case start date and the latest cover period to on ILI

    Please let me know if any additional information is required.

  • Guest
    Reply
    |
    Dec 12, 2019

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Watson Health
    Product family - Cúram Social Program Management
    Product - Social Program Management Platform
    Component - Other
    Source - Other

    For recording keeping, the previous attributes were:
    Brand - Watson Health
    Product family - Cúram Social Program Management
    Product - Income Support
    Component - Other
    Source -

  • Guest
    Reply
    |
    Dec 10, 2019

    Hi Vinod,

    Thank you for the extra information provided.

    It would help us if the extra figures and stats could be provided such as:
    1. Some stats around the reassessments and the time it is taking.
    2. The difference in the cases and case types between those which are performing and which are not.
    3. The makeup of those cases which are not performing with regards to the volume and type of evidence contained in those cases.

    This will enable us to produce a test case to try and mimic the customer experience and then proceed to perform technical analysis to see if there is a product enhancement/issue in this area.

    Thank you,
    Shane McFadden, Cúram SPM Product Management team

  • Vinod Musunuri
    Reply
    |
    Dec 9, 2019

    In the Use Case where it says "Reassessment performance is impacted for cases that have a long duration..."
    Does the customer have some figures around this? How long are these reassessments taking?
    Some reassessments take longer than 4 minutes. We will try to get you some figures and stats around it soon
    What is the difference between some cases which are performing OK and those who are not?
    When reassessment of single case takes longer than 4 mintues then certain actions on such a case cannot even be performed on the screen like manual reassessments since the transaction times out. Our transaction time out is 4 mintues
    Are there specific types of cases that are problematic? Do these cases contain specific types of evidence types or evidence change patterns (much end dating, many changes, many successions, etc.)?
    Most of these cases have a number of evidence of the same type, multiple household members, lots of changes etc...

    We will provide more information soon by digging deeper into a few sample cases

  • Guest
    Reply
    |
    Dec 2, 2019

    Hi Vinod,

    We met to discuss this enhancement request and in order to further evaluate, we require that you provide more details to help us proceed with making a decision.
    In the Use Case where it says "Reassessment performance is impacted for cases that have a long duration..."
    Does the customer have some figures around this? How long are these reassessments taking? What is the difference between some cases which are performing OK and those who are not? Are there specific types of cases that are problematic? Do these cases contain specific types of evidence types or evidence change patterns (much end dating, many changes, many successions, etc.)?

    Thank you,
    Shane McFadden, Cúram SPM Product Management team

  • Guest
    Reply
    |
    Oct 17, 2019

    Hi Vinod,

    Thank you for your enhancement request.
    We require some further analysis to determine whether or not this enhancement can be considered in a future release.
    I will provide another response when our investigation is complete.

    Thank you,
    Shane McFadden, Cúram SPM Product Management team

  • Vinod Musunuri
    Reply
    |
    Oct 16, 2019

    Attachment (Description)