1. OVERVIEW › 1.5 Online Facility Tutorial › 1.5.10 Placing Analysis Inquiries in the SHARED Catalog

1.5.10 Placing Analysis Inquiries in the SHARED Catalog

The Capacity Planner Analysis Inquiries can be placed into
the SHARED MICF catalog if you so desire. Once in the SHARED
catalog all Capacity Planner users can then share these
inquiries or copy them to their own private catalog for
further modification.

Since these inquires can be executed by anyone with
authorization to use the Capacity Planner, they must
reference files that exist in the SHARED Capacity Planner
File Catalog and Database. During migration of these inquires
from the private to the SHARED catalogs, the SHARED catalog
will be checked to ensure that the required files have been
previous defined and migrated. If the required files are not
present in the SHARED catalog, the migration process will be
terminated and appropriate error messages issued.

By adhering to this standard you avoid possible conflicts
with your security system, particularly if you wish to place
these inquiries into Production Reporting. Any query that is
to be executed by the Production Reporting facility must
reside in the SHARED catalog.

The CA MICS Retrieval and Reporting Guide's Appendix C
describes how to maintain the SHARED and private inquiry
catalogs.

To promote user defined inquires to the Capacity Planning
SHARED catalog, you must first cause all required files to be
defined in the CAP SHARED catalog.  If the required file(s)
were created by a Capacity Planning Standard application, you
must promote that application, along with its files, or
alternatively promote the application and then execute the
application from the SHARED catalog to generate its files. If
the required file(s) were created by a Capacity Planner
Resource File definition, you must first promote the Resource
Definition, and then execute the Resource Definition from the
CAP SHARED catalog.

The basic rule regarding query promotion and execution is
this:  the file(s) must be defined in whatever catalog is
used to contain and execute the query itself.

The Forecasting Analyses (Univariate Modeling, Multivariate
Regression, and Business Element Forecasting) all have the
capability to generate a forecast file that is then saved in
the Capacity Planner database (for more information on the
naming/structure of these files please see Chapter 3 of this
guide).

The default target of these forecast analysis operations is
the same as the database used for maintaining the history
files.  If you want to share this data, you must use the
Capacity Planner Administration Facility to migrate these
file(s) to the SHARED catalog and database before attempting
to migrate any database analysis inquires that require these
files.

You can override this default through the use of a new
Execution-Time Option, Forecast Target, which enables you to
specify that the Forecast File should be written to the
SHARED Capacity Planner database directly. Note that you then
must have the necessary authorization from your security
administrator to update the SHARED Capacity Planner database.

When a Forecast Inquiry is placed into Production Reporting
the target of the forecast will always be the SHARED Capacity
Planner database. (For more information, see the CA MICS
Retrieval and Reporting Guide.)