IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Purging historical data - Optimize for Infra - wM9.9

  • 1.  Purging historical data - Optimize for Infra - wM9.9

    Posted Thu August 18, 2016 04:15 AM

    Ola Experts,

    Need assistance with purging the historical data for Optimize (Optimize for Infra).
    Tried live purge which cleared very few BAM tables . BAM_FACT_INTEGRA_V1 was very much visible, and the same reading disappeared from Analysis Overview.

    Not sure if live purge is the only UI option available. Alternate for clearing i have in mind, is to clear the fact tables manually by running SQL over the DB.

    I want all the data and KPI’s to disappear from the Analysis Overview and have only the one i selected after the purge.

    Thanks
    Abdul Bari Khan


    #BPM
    #webMethods-BPMS
    #webMethods


  • 2.  RE: Purging historical data - Optimize for Infra - wM9.9

    Posted Wed October 05, 2016 01:22 AM

    Hi Bari Khan,
    Did you check the section ‘Deleting Unwanted KPI Instances’ in Administering Optimize PDF. It might help you.

    Regards
    Senthil


    #BPM
    #webMethods-BPMS
    #webMethods


  • 3.  RE: Purging historical data - Optimize for Infra - wM9.9

    Posted Sun November 27, 2016 06:04 AM

    Thanks Senthil for the prompt response.
    I wanted to have OFI clean as new installation. Have raised a ticket regarding this as well.

    Resolution i received is to re-install Optimize to remove all the entries. Here entries i mean not just the FACT entries but DIMENSION entries as well.

    Say i want to remove IS3 entry form the list if IS1, IS2 and IS3. It is possible from UI and it will stop reading details from the eliminated node, but the entry in DB stays.

    Thanks
    Abdul Bari Khan


    #webMethods-BPMS
    #webMethods
    #BPM