We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Retrieving History Data in Assure

Comments

4 comments

  • Avatar
    Manish Kulkarni

    P.S. the condition is specified to retrieve the computed values against certain records which do exist in the source file

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Hi Manish,

    I apologize for the delayed response. Has the team been able to resolve this since the post was first made?

    When making one of those, the system will do some defaulting of the "Select Control Data" > "When" if ( and only if ) the Control Entity on the "Details" table of the history data items is the same as "this entity" ( the one whose Control Point you are editing ). Otherwise, it is up to the rules writer to fill out the cycle criteria and the "select control data when". For a computed history, you also have to add computations on the "Fields" tab, such as "sum of control field X" or "minimum of control field Y". It should be noted that some things change when selecting "entire instance" for history as well.

    A good reference for more information on items like this may be found within the "Global Help" section of the product UI. Navigating this feature is detailed within the following article :

    https://support.infogix.com/hc/en-us/articles/360044947734-Accessing-Global-Help

    Please let me know if there are any specific questions the team has around this.

    0
    Comment actions Permalink
  • Avatar
    Manish Kulkarni

    Thanks Matthew. I have 2 files which gets loaded on a daily basis and my requirement is to do data reconciliation between today and yesterday's data load. Below is my control setup -
    1 Detail Control Entity (ce1) having 1 Multicapture control point (cp1) 2 data sources in Capture tab one each for 2 files. 3 History Data items - 1. References Relative Cycle 0 or Most Recent Cycle data (control entity - ce1) 2. References Relative Cycle -1 (control entity - ce1). For both history data items I have Select Control Data = <my primary key>. My question is, when I refer to the -1 relative cycle will I be getting values from both data sources? If not, how do I retrieve history run for second data source or viceversa assuming I am able to retrieve historical run only 1 data source.

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Manish,

    Is it possible for us to separate this logic out? For example, when trying to reconcile, utilize a "recon" CP with one source as a "control data current cycle", and a second source is the "control data -1 cycle"?

    This would be the best solution it appears, at least without being able to look at the control itself. As mentioned, a good reference for more information on items like this may be found within the "Global Help" section of the product UI. Navigating this feature is detailed within the following article :

    https://support.infogix.com/hc/en-us/articles/360044947734-Accessing-Global-Help

    0
    Comment actions Permalink

Please sign in to leave a comment.