|
|
ACDM.1 - Activity Management Data Mart Setup
Use Activity Analysis Setup (ACDM.1) to define Project 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 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 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
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
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
ACACTMXVAL -
ACADDLCNTR -
ACAMCODE -
ACASNROLE -
ACASSIGN -
ACCATMXVAL -
ACCATSUM -
ACCATSUMX -
ACCNTRACT -
ACGRPMXVAL -
ACIAMXDIM -
ACROLE -
GMAWARD -
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
MXVIEWHDR -
STRUCTURE -
ACDM.3 - Account Category Dimension Definition
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
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
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
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
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
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
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 -
MXLISTHDR -
MXLISTMBR -
Referenced Files
ACACTGRP -
ACACTIVITY -
ACACTMXVAL -
ACADDLCNTR -
ACAMCODE -
ACASNROLE -
ACASSIGN -
ACCNTRACT -
ACIAACVDIM -
ACROLE -
GMAWARD -
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
INVOKED Programs
IAAP
IFOB
IADE
IFCU
IFAC
ACAC
ACTA
API4
IFLU
IFUP
IFSG
SLSE
SLSU
|
