Gareth Horton
July 12th, 2002, 02:23 PM
Heather, I assume first of all that your current model captures the age, CDSC Shares, CDSC Value and Fee amount in your Detail trap, and you then are capturing the other data using Append level traps.
It sounds like you already set up an Append-level trap using: REPORT NUMBER: R04855
That will not limit the data in your table the way you want. Don't try to use traps to filter the data.
Instead, begin by removing the reference to R04855 in your Report Number trap. Your trap should now capture ALL Report Numbers (which we actually want to do...)
Now, when in the Table view, specify a Data Filter: [Report Number]="R04855" and you should be all set.
The Data - Filter in the Table window is the right place to specify limitations on the data you want to see.
Compare the table results from your current model and your table after making these edits to your model and you will get a better idea how Monarch combines data from Append (or Page Header or Footer) traps with the data captured from the Detail traps.
BTW to all, I am adding a couple of HTML tags to see if Heather's report below now appears in monospace...if it doesn't it means our board software does not read HTML tags in a message...at least not yet...?
Mike
Heather Delaney wrote:
> Thanks in Advance to anyone who can help!
>
> I have a text file that has multiple reports in it. Each report has it own report number and the data is different but the structure is so similar my model picks up data from other parts of the report I do not want. I set my model to look for example REPORT NUMBER: R04855 but my model still grabs data from example R07056 and the rest of the report with the same structure. Does anyone have any suggest on how I can fix this or even why when I specifically say look for an exact report number it grabs data from the whole text file?
>
> I am trying to trap:
>
> Report Number
> Source Program
> Job
> Super Sheet Date
> Fund Code / Name before and after / so it would be to fields
> Age
> CDSC Shares
> CDSC Value
> Fee amount
>
> I have attached a very abbreviated version of the report I am trying to work with. If anyone has any suggestions I would appreciate it.
>
> Thanks
> Heather
<tt>
>
> REPORT NUMBER: R07056 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B07874 REDEMPTION ACTIVITY BETWEEN 12/01/2001 AND 12/31/2001 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:30
> MGMT CODE/NAME: CM/XXXXXXXXXXXXXXX
> FINANCIER: CCCCCCC
> FUND CODE/NAME: 237/FUND NAME
> FUND NAV: 11.2100
> SHARES NOT SUBJECT TO CDSC:
> SHARES VALUE
> ----------------------- ----------------------
> EXEMPT ACCOUNT SHARES 161.4260 1,809.59
> REINVESTED SHARES 559.3110 6,269.88
> FRONT-END SHARES .0000 .00
> EXCLUDED SHARES .0000 .00
> FULLY AGED SHARES 4,160.7440 46,641.94
> ----------------------- -----------------------
> TOTAL SHARES NOT SUBJECT TO CDSC 4,881.4810 54,721.40
> MONTH OF MINIMUM ROA CDSC CDSC CDSC
> AGE CDSC % BREAKPOINT AMT CHARGEABLE SHARES CHARGEABLE VALUE TOTAL FEE AMOUNT
> ------- ---------------- -------------------- ----------------------- ---------------------- ----------------------
> 1 5.0000000000 .00 .0000 .00 .00
> 1 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 .0000 .00 .00
> ----------------------- ---------------------- ----------------------
> YEAR SUB-TOTAL .0000 .00 .00
>
> 13 4.0000000000 .00 .0000 .00 .00
> 13 4.0000000000 .00 .0000 .00 .00
> 14 4.0000000000 .00 .0000 .00 .00
>
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 79/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 80/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 81/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/xxxxxxxxxxxxxxx
> FUND CODE/NAME: 82/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: CM/XXXXXXXXXXXXXXX
> FUND CODE/NAME: 84/ FUND NAME
> FUND NAV: 31.6800
> SHARES NOT SUBJECT TO CDSC:
> SHARES VALUE
> ----------------------- ----------------------
> EXEMPT SHARES 119.4120 3,782.97
> PRE-AGREEMENT SHARES .0000 .00
> REINVEST SHARES 776.9580 24,614.03
> FRONT END SHARES .0000 .00
> EXCLUDED SHARES .0000 .00
> FULLY AGED SHARES 106.6450* 3,378.51
> ------------------------ -----------------------
> TOTAL SHARES NOT SUBJECT TO CDSC 1,003.0150 31,775.52
> MONTH OF MINIMUM ROA CDSC CDSC CDSC
> AGE CDSC % BREAKPOINT AMT CHARGEABLE SHARES CHARGEABLE VALUE TOTAL FEE AMOUNT
> ------- ---------------- -------------------- ----------------------- ---------------------- ----------------------
> 1 5.0000000000 .00 .0000 .00 .00
> 1 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 6.2930 199.99 10.00
> 2 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 6.5920 200.00 10.00
> 3 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 7.2230 200.00 10.00
> 4 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 6.0300 192.00 9.60
> 5 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 5.8460 186.14 9.31
> 6 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 5.5740 177.48 8.87
> 7 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 38.2610 1,223.50 61.18
> 8 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 5.5900 177.99 8.90
> 9 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 487.0650 15,200.05 760.00
> 10 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 5.0480 160.73 8.04
> 11 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 4.3650 138.98 6.95
> 12 5.0000000000 .00 .0000 .00 .00
> ----------------------- ---------------------- ----------------------
> YEAR 1 SUB-TOTAL 577.8870 18,056.86 902.85
>
>
>
</tt>
It sounds like you already set up an Append-level trap using: REPORT NUMBER: R04855
That will not limit the data in your table the way you want. Don't try to use traps to filter the data.
Instead, begin by removing the reference to R04855 in your Report Number trap. Your trap should now capture ALL Report Numbers (which we actually want to do...)
Now, when in the Table view, specify a Data Filter: [Report Number]="R04855" and you should be all set.
The Data - Filter in the Table window is the right place to specify limitations on the data you want to see.
Compare the table results from your current model and your table after making these edits to your model and you will get a better idea how Monarch combines data from Append (or Page Header or Footer) traps with the data captured from the Detail traps.
BTW to all, I am adding a couple of HTML tags to see if Heather's report below now appears in monospace...if it doesn't it means our board software does not read HTML tags in a message...at least not yet...?
Mike
Heather Delaney wrote:
> Thanks in Advance to anyone who can help!
>
> I have a text file that has multiple reports in it. Each report has it own report number and the data is different but the structure is so similar my model picks up data from other parts of the report I do not want. I set my model to look for example REPORT NUMBER: R04855 but my model still grabs data from example R07056 and the rest of the report with the same structure. Does anyone have any suggest on how I can fix this or even why when I specifically say look for an exact report number it grabs data from the whole text file?
>
> I am trying to trap:
>
> Report Number
> Source Program
> Job
> Super Sheet Date
> Fund Code / Name before and after / so it would be to fields
> Age
> CDSC Shares
> CDSC Value
> Fee amount
>
> I have attached a very abbreviated version of the report I am trying to work with. If anyone has any suggestions I would appreciate it.
>
> Thanks
> Heather
<tt>
>
> REPORT NUMBER: R07056 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B07874 REDEMPTION ACTIVITY BETWEEN 12/01/2001 AND 12/31/2001 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:30
> MGMT CODE/NAME: CM/XXXXXXXXXXXXXXX
> FINANCIER: CCCCCCC
> FUND CODE/NAME: 237/FUND NAME
> FUND NAV: 11.2100
> SHARES NOT SUBJECT TO CDSC:
> SHARES VALUE
> ----------------------- ----------------------
> EXEMPT ACCOUNT SHARES 161.4260 1,809.59
> REINVESTED SHARES 559.3110 6,269.88
> FRONT-END SHARES .0000 .00
> EXCLUDED SHARES .0000 .00
> FULLY AGED SHARES 4,160.7440 46,641.94
> ----------------------- -----------------------
> TOTAL SHARES NOT SUBJECT TO CDSC 4,881.4810 54,721.40
> MONTH OF MINIMUM ROA CDSC CDSC CDSC
> AGE CDSC % BREAKPOINT AMT CHARGEABLE SHARES CHARGEABLE VALUE TOTAL FEE AMOUNT
> ------- ---------------- -------------------- ----------------------- ---------------------- ----------------------
> 1 5.0000000000 .00 .0000 .00 .00
> 1 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 .0000 .00 .00
> ----------------------- ---------------------- ----------------------
> YEAR SUB-TOTAL .0000 .00 .00
>
> 13 4.0000000000 .00 .0000 .00 .00
> 13 4.0000000000 .00 .0000 .00 .00
> 14 4.0000000000 .00 .0000 .00 .00
>
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 79/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 80/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/ xxxxxxxxxxxxxxx
> FUND CODE/NAME: 81/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: DF/xxxxxxxxxxxxxxx
> FUND CODE/NAME: 82/ FUND NAME
> * * * * * N O R E P O R T A B L E A C T I V I T Y * * * * *
> REPORT NUMBER: R04855 REDEMPTION ANALYSIS REPORT PAGE: 1
> SOURCE PROGRAM: B04313 REDEMPTION ACTIVITY BETWEEN 12/ 1/01 AND 12/31/01 SUPER SHEET DATE: 12/31/2001
> JOB: DPZMU752 CURRENT DATE: 01/01/2002
> TIME: 10:55:27
> MGMT CODE/NAME: CM/XXXXXXXXXXXXXXX
> FUND CODE/NAME: 84/ FUND NAME
> FUND NAV: 31.6800
> SHARES NOT SUBJECT TO CDSC:
> SHARES VALUE
> ----------------------- ----------------------
> EXEMPT SHARES 119.4120 3,782.97
> PRE-AGREEMENT SHARES .0000 .00
> REINVEST SHARES 776.9580 24,614.03
> FRONT END SHARES .0000 .00
> EXCLUDED SHARES .0000 .00
> FULLY AGED SHARES 106.6450* 3,378.51
> ------------------------ -----------------------
> TOTAL SHARES NOT SUBJECT TO CDSC 1,003.0150 31,775.52
> MONTH OF MINIMUM ROA CDSC CDSC CDSC
> AGE CDSC % BREAKPOINT AMT CHARGEABLE SHARES CHARGEABLE VALUE TOTAL FEE AMOUNT
> ------- ---------------- -------------------- ----------------------- ---------------------- ----------------------
> 1 5.0000000000 .00 .0000 .00 .00
> 1 5.0000000000 .00 .0000 .00 .00
> 2 5.0000000000 .00 6.2930 199.99 10.00
> 2 5.0000000000 .00 .0000 .00 .00
> 3 5.0000000000 .00 6.5920 200.00 10.00
> 3 5.0000000000 .00 .0000 .00 .00
> 4 5.0000000000 .00 7.2230 200.00 10.00
> 4 5.0000000000 .00 .0000 .00 .00
> 5 5.0000000000 .00 6.0300 192.00 9.60
> 5 5.0000000000 .00 .0000 .00 .00
> 6 5.0000000000 .00 5.8460 186.14 9.31
> 6 5.0000000000 .00 .0000 .00 .00
> 7 5.0000000000 .00 5.5740 177.48 8.87
> 7 5.0000000000 .00 .0000 .00 .00
> 8 5.0000000000 .00 38.2610 1,223.50 61.18
> 8 5.0000000000 .00 .0000 .00 .00
> 9 5.0000000000 .00 5.5900 177.99 8.90
> 9 5.0000000000 .00 .0000 .00 .00
> 10 5.0000000000 .00 487.0650 15,200.05 760.00
> 10 5.0000000000 .00 .0000 .00 .00
> 11 5.0000000000 .00 5.0480 160.73 8.04
> 11 5.0000000000 .00 .0000 .00 .00
> 12 5.0000000000 .00 4.3650 138.98 6.95
> 12 5.0000000000 .00 .0000 .00 .00
> ----------------------- ---------------------- ----------------------
> YEAR 1 SUB-TOTAL 577.8870 18,056.86 902.85
>
>
>
</tt>