6. REPORTS › 6.7 Extracting Data for the Workstation

6.7 Extracting Data for the Workstation

EISFR workstation report data is created by executing MICF
inquiries on the host.  The EISFR workstation application
downloads the data to the workstation for viewing.  It is
necessary to allocate a shared control file if you have not
done so previously.  The creation of a shared control file
is described below.

CREATE SHARED CONTROL FILE

Using the JCL shown below, allocate a shared control file
data set for your installation:

//ALLOCATE EXEC PGM=IEBGENER
//*
//* Shared Control File Allocation
//* (SPECIFY VOLSER AND UNIT TYPE)
//*
//SYSUT2   DD DSN=sharedprefix.MICS.DTF.INDEX,
//         DISP=(NEW,CATLG,DELETE),
//         DCB=(DSORG=PS,RECFM=VB,LRECL=255,BLKSIZE=9040),
//         SPACE=(TRK,(5,5)),UNIT=_____,VOL=SER=_____
//SYSUT1   DD DUMMY, DCB=*.SYSUT2
//SYSIN    DD DUMMY
//SYSPRINT DD DUMMY
//

Notes:  The five tracks specified is an estimate of initial
        requirements.  Examine the space utilization of your
        CSV Extract Control file to and adjust if necessary
        to meet your installations requirements.

        In addition, the data set name used in the JCL,
        'sharedprefix.MICS.DTF.INDEX', should not be changed
        without first referencing the PIOM, Section
        2.3.3.3.2.3.

REVIEW/MODIFY CSV EXTRACT FILE ALLOCATION PARAMETERS

After the shared control file is allocated you should review
the allocation parameters used for the CSV extract files.
Insure the parameter values are adequate for your data
retention requirements.  These allocation parameters may be
reviewed and modified with the CA MICS Workstation Facility
(MWF) using the Data Set Allocation Parameters option
(MWF;2;0;6).

The CSV extract related data sets are BITFOUT, DTFINDEX,
DTFOUT, PDTFINDX, and PIXFOUT entries on the Data Set
Allocation Parameters panel.

The PIOM provides additional information about parameter
modification for these CSV output data sets.  An example of
the Data Set Allocation Parameter panel and instructions on
its use are found in section 4.4.2.4.

The MICF Reference Guide sections 2.6 and 5.1.1.4 contain
detailed information about each of the CSV extract data sets.

EXTRACT DATA FOR THE WORKSTATION

Creation of a data extract for the workstation can be
scheduled to execute automatically or directly.

Automatic data extraction uses MICF Production Reporting to
schedule data extraction for:

o Daily IS Revenue Analysis by putting it in the production
  reporting jobstream associated with the DAILY job.

o User IS Expense Analysis, IS Revenue Analysis, Application
  IS Expense Analysis, and IS Revenue Projection and Rate
  Analysis using the INVOICE or FINRECAP job.

  See Section 5.1.6 in the MICF Reference Guide for
  information on using MICF Production Reporting.

Direct, or on demand creation of CSV extract files is
accomplished using MWF.  Select and generate the appropriate
CSV extract data set by following the steps below:

1.  Enter MWF and select the desired workstation option:

    1a) Go directly to the extract analysis:

    o User IS Expense Analysis              (MWF;4;2;4;2;1)
    o IS Revenue Analysis                   (MWF;4;2;4;3;1)
    o Application IS Expense Analysis       (MWF;4;2;4;4;1)
    o Daily IS Revenue Analysis             (MWF;4;2;4;5;1;2)
    o IS Revenue Projection & Rate Analysis (MWF;4;2;4;3;6)

    1b) Or select the extract inquiry through the CA MICS
        Information Center Facility (MWF;2;2):

    o ACTWS1  User IS Expense Analysis Extracts
    o ACTWS2  IS Revenue Analysis Extracts
    o ACTWS3  Application IS Expense Analysis Extracts
    o ACTWS4  Daily Revenue Analysis Extract
    o ACTWS5  Revenue Projection & Rate Analysis Extract

2.  To run the inquiry in batch, specify BATCH for "Inquiry
    Execution Mode" and YES for "Hold Inq. Output for Replay"
    under the "Batch Job Submissions Parameters" part of the
    MICF Execution panel.

    To run the inquiry in foreground, specify FOREGROUND for
    "Inquiry Execution Mode."

3.  Press Enter to display the panel to enter the Runtime
    Parameters for this inquiry.

4.  Specify the Runtime Parameters and enter "END" to submit
    the inquiry.  For information on specifying the Runtime
    Parameters, review the online tutorial.

5.  If you ran the inquiry in batch, use the MICF Reports and
    Graphics option to move the output from the BSTAGE
    catalog to your PRIVATE catalog.

    If you ran the inquiry in FOREGROUND, select Option 6,
    Catalog Inquiry Output, from the Inquiry Output Replay
    menu.  This will cause the output to be saved.

6.  Use the Enterprise IS Financial Reporting workstation
    application to download the DTF.INDEX catalog and inquiry
    output to the workstation.