|
|
ACDM.1 - Activity Management Data Mart Setup
**Form Purpose
Use Activity Analysis Setup (ACDM.1) to define Project and Activity
Accounting 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 Project and Activity
Accounting 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.
**More Information
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 Project and Activity Accounting
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
**Form Purpose
Use Activity Dimension Definition (ACDM.2) to define the activities you want
to include in the Activity dimension.
Updated Files
ACIAACVDIM -
MXLISTHDR -
MXLISTMBR -
Referenced Files
ACACTGRP -
ACACTIVITY -
ACACTMXVAL -
ACADDLCNTR -
ACAMCODE -
ACASNROLE -
ACASSIGN -
ACCNTRACT -
ACGRPMXVAL -
ACIAMXDIM -
ACROLE -
GMAWARD -
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
MXVIEWHDR -
ACDM.3 - Account Category Dimension Definition
**Form Purpose
Use Category Dimension Definition (ACDM.3) to define the account categories
you want to include in the Category dimension.
Updated Files
ACIACATDIM -
Referenced Files
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACIACATMBR -
STRUCTURE -
ACDM.4 - Amounts Dimension Definition
**Form Purpose
Use Amounts Dimension Definition (ACDM.4) to define measures you want to
include in the Amounts dimension.
Updated Files
ACIAAMTDIM -
Referenced Files
ACIAMBR -
ACDM.5 - Resource Dimension Definition
**Form Purpose
Use Resource Dimension Definition (ACDM.5) to define resources you want to
include in the Resource dimension.
Updated Files
ACIARESDIM -
Referenced Files
None.
ACDM.6 - Currency
**Form Purpose
Use Currency (ACDM.6) to define member names for currency codes. For example,
you might define USD as Base Currency or define MXP as Mexican Pesos - Report
Currency.
Updated Files
ACIAMBR -
Referenced Files
ACIAAMTDIM -
ACDM.7 - Account Category Range Definition
**Form Purpose
Use Category Dimension Range Definition (ACDM.7) to filter down your account
category selection by including or excluding ranges of account categories.
Updated Files
ACIACATMBR -
Referenced Files
None.
ACDM.8 - Dimension Attributes
**Form Purpose
Use Dimension Attributes (ACDM.8) to assign member names to the attributes
associated with the activities you have selected. Choose the Levels button
next to the attribute for which you want to define member names.
You can define a member name for the attribute associated with all posting
level activities or define a member name for the attribute associated with a
select posting level activity. For example, for the person responsible
attribute you might define a member name of Regional Manager at Level 1 and a
member name of Store Manager at Level 2.
Updated Files
None.
Referenced Files
ACIAMXDIM -
MXCATDEF -
MXOBJCAT -
ACDM.9 - Attribute Levels
**Form Purpose
Use Attribute Levels (ACDM.9) to define a member name for the attribute
associated with all posting level activities or define a member name for the
attribute associated with a select posting level activity. For example, for
the person responsible attribute you might define a member name of Regional
Manager at Level 1 and a member name of Store Manager at Level 2.
Updated Files
ACIAMXDIM -
Referenced Files
ACACTGRP -
ACACTIVITY -
ACIAACVDIM -
MXCATDEF -
MXELEMENT -
INVOKED Programs
IAAP
IFOB
IADE
IFCU
IFAC
ACAC
ACCL
ACTA
API4
IFLU
IFAU
IFSG
SLSE
SLSU
|
