ACDM.1 - Activity Analysis Setup
Use AC87.1 (Dimension Definition) to define Activity Management parameters
for information you want to transfer to the Activity data mart for reporting.
You can transfer activity, account category, organization, year, period,
amounts, and budgets. Each section consists of a dimension name and optional
member prefix. The dimension name is used to identify Activity Management
information in the data mart. The member prefix for dimensions are not unique.
For example, define a member prefix if you have an activity 1000 and an
account category 1000. The member prefix makes the two dimensions unique in
the data mart.
Before you can define activity dimension information, you must use IA10.1
(Data Mart Manager) to define the application name, database name, select AC
in the application type field, and use the server name field to identify the
IP address for the server you currently store Activity Management information
on.
You should define three profiles in IA11.1 (Information Transfer Profiles).
Use Outline Build to load the Dimension Name and Member Prefixes, Data Values
Load to load balances, and Calculation to update information that has changed
since the last time you loaded data.
Run IA120 (Data Mart Load) to load the data into the data mart for each
profile.
Updated Files
ACIADIM -
Referenced Files
ACIAACVDIM -
ACIAAMTDIM -
ACIACALDIM -
ACIACATDIM -
ACIARESDIM -
ACIASCNDIM -
ORGSTRUC -
ACDM.2 - Activity Dimension Definition
Use AC87.2 (Periods) to define the periods you want to include in the
dimension. Each period is identified by a member name. For example, assign
member name January to identify information from your calendar for period 1
defined in AC00.2 (Calendar). The member name is used to identify information
within a dimension.
Updated Files
ACIAACVDIM -
Referenced Files
ACACTGRP -
ACACTIVITY -
ACCOLGRP -
ACCOLGRPX -
ACIAMXDIM -
MXVIEWHDR -
ACDM.3 - Category Dimension Definition
Use AC87.3 (Budgets) to define the budgets you want to include in the
dimension. Each budget is identified by a member name. For example, assign
member name Annual Budget to include information from budget 1 defined in
AC20.2 (Activity Budget). The member name is used to identify information
within a dimension.
Updated Files
ACIACATDIM -
Referenced Files
ACCATGRP -
ACCATGRPX -
ACIACATMBR -
ACDM.4 - Amounts Dimension Definition
Use AC87.4 (Budget Variance) to compare values from one budget with values
from another budget. You can compare Budget to Actuals or Budget to Budget and
view the difference between budgets in amounts or percentage.
If you select to compare Budget to Actuals, you compare the budget values with
the actual values for one budget. The Budget to Budget options compares values
for two different budgets.
Updated Files
ACIAAMTDIM -
Referenced Files
ACIAMBR -
ACDM.5 - Resource Dimension Definition
Use AC87.5 (Year Variance) to compare values from one year with values from a
different year. The value could be amounts, units, or currency depending on
the dimensions being processed. You can view the difference between years in
amounts or a percentage.
Updated Files
ACIARESDIM -
Referenced Files
None.
ACDM.6 - Currency
Use AC87.6 (Currency) to define the currency codes you want to include in the
dimension. Each currency code is identified by a member name. For example,
assign member name Activity Group Base Currency to currency USD. The member
name is used to identify information within a dimension.
Updated Files
ACIAMBR -
Referenced Files
ACIAAMTDIM -
ACDM.7 - Category Dimension Range Definition
Use AC87.7 (Years) to define the years you want to include in the dimension.
Each year is identified by a member name. For example, assign member name 1998
Fiscal Year to include information from your calendar year 1998 defined in
AC00.2 (Calendar). The member name is used to identify information within a
dimension.
Updated Files
ACIACATMBR -
Referenced Files
None.
ACDM.8 - Dimension Attributes
Updated Files
None.
Referenced Files
ACIAMXDIM -
MXCATDEF -
MXOBJCAT -
ACDM.9 - Attribute Levels
Updated Files
ACIAMXDIM -
Referenced Files
MXCATDEF -
MXELEMENT -
INVOKED Programs
IAAP
IFOB
IADE
IFCU
IFSG
|
