ACTD.1 - Activity Period Dimension Definition
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
ACIACALDIM -
Referenced Files
ACIAMBR -
ACTD.2 - Periods
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
ACIAMBR -
Referenced Files
ACIACALDIM -
ACTD.3 - Activity Year 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
ACIACALDIM -
Referenced Files
ACIAMBR -
ACTD.4 - Years
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
ACIAMBR -
Referenced Files
ACIACALDIM -
ACTD.5 - Year Variances
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
ACIAMBR -
Referenced Files
ACIACALDIM -
INVOKED Programs
IAAP
IFOB
IADE
|
