ACDM.1 – Activity Management Data Mart Setup
- System
- Activity Management (AC)
- Type
- Online screen — form DM
- Updates
- 1 table
- References
- 7 tables
ACDM.1 (Activity Management Data Mart Setup) is a Lawson Activity Management online screen (form DM, subform 1). It updates ACIADIM and references ACIAACVDIM, ACIAAMTDIM, ACIACALDIM, ACIACATDIM, ACIARESDIM, ACIASCNDIM and ORGSTRUC.
About ACDM.1
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 Accountinginformation in the data mart. The member prefix for dimensions are not unique. Forexample, 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 Accountinginformation 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 (1)
| Table | Description | System |
|---|---|---|
| ACIADIM | The Activity Analyzer Dimensions data file stores the definition of each dimension that has been defined by AC87.1… | AC |
Referenced files (7)
| Table | Description | System |
|---|---|---|
| ACIAACVDIM | No description in the Lawson data dictionary | AC |
| ACIAAMTDIM | No description in the Lawson data dictionary | AC |
| ACIACALDIM | No description in the Lawson data dictionary | AC |
| ACIACATDIM | No description in the Lawson data dictionary | AC |
| ACIARESDIM | No description in the Lawson data dictionary | AC |
| ACIASCNDIM | No description in the Lawson data dictionary | AC |
| ORGSTRUC | Organization Structure | IF |
Program calls
Invoked programs (13)
ACAC, ACTA, API4, IAAP, IADE, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU