Topic
  • 3 replies
  • Latest Post - ‏2012-07-30T14:58:49Z by asmcleod
Srini_A
Srini_A
49 Posts

Pinned topic How to prevent loading of Billing data to CIMSDetail for Invalid Ratecode?

‏2012-06-18T19:39:32Z |
We notice that if we get an invalid rate code in the CSR file, we get a warning in the XML Log that its invalid and it does not make it into CIMSSummary but it shows up in CIMSDetail.

Is there a way to prevent it from loading into CIMSDetail? Also is there a way to write this to the exception log other than using the look up table.

Thanks
Srini
Updated on 2012-07-30T14:58:49Z at 2012-07-30T14:58:49Z by asmcleod
  • asmcleod
    asmcleod
    97 Posts

    Re: How to prevent loading of Billing data to CIMSDetail for Invalid Ratecode?

    ‏2012-06-28T14:49:51Z  
    Srini,

    The behavior you describe is working as designed - many clients want to track usage for certain resources (CIMSDetail) yet not show those resources in the costed data (CIMSSummary).

    If you want to exclude completely an identifier or resource from the TUAM database, you could simply use Integrator's DropFields (or DropIdentifiers or DropResources) stage prior to the Bill step.

    Scott
  • Srini_A
    Srini_A
    49 Posts

    Re: How to prevent loading of Billing data to CIMSDetail for Invalid Ratecode?

    ‏2012-07-10T18:35:13Z  
    • asmcleod
    • ‏2012-06-28T14:49:51Z
    Srini,

    The behavior you describe is working as designed - many clients want to track usage for certain resources (CIMSDetail) yet not show those resources in the costed data (CIMSSummary).

    If you want to exclude completely an identifier or resource from the TUAM database, you could simply use Integrator's DropFields (or DropIdentifiers or DropResources) stage prior to the Bill step.

    Scott
    Hi Scott
    The scenario we have is quite different. We have new rate codes that the Billing group creates but forgets to update the Rate Table. So when we read the CSR we would like them to drop out since we don't want to load this.

    In the prior billing system, it would reject these records and then the billing group would realize they were missing the table entry for the new rate code.

    In this case all we see are warnings in the log but it still goes ahead and loads them into the Detail and Ident tables which is something we dont want.

    I wonder if the developers can consider an option to not load rate codes that are not defined in the CIMSrate table.
  • asmcleod
    asmcleod
    97 Posts

    Re: How to prevent loading of Billing data to CIMSDetail for Invalid Ratecode?

    ‏2012-07-30T14:58:49Z  
    • Srini_A
    • ‏2012-07-10T18:35:13Z
    Hi Scott
    The scenario we have is quite different. We have new rate codes that the Billing group creates but forgets to update the Rate Table. So when we read the CSR we would like them to drop out since we don't want to load this.

    In the prior billing system, it would reject these records and then the billing group would realize they were missing the table entry for the new rate code.

    In this case all we see are warnings in the log but it still goes ahead and loads them into the Detail and Ident tables which is something we dont want.

    I wonder if the developers can consider an option to not load rate codes that are not defined in the CIMSrate table.
    Srini,

    TUAM's Bill program has worked this way from the beginning, though I see you're presenting a reasonable alternative process.

    The best way to suggest a TUAM product change is through the Tivoli Request for Enhancement (RFE) Process, described in this flash: http://www-01.ibm.com/support/docview.wss?uid=swg21449404

    RFE community direct link: http://www.ibm.com/developerworks/rfe/tivoli/

    I suggest you submit an RFE detailing the change you'd like to see in the Bill program.

    Scott