AC87.1 - Dimension Definition Use AC87.1 (Activity Data Mart Setup) 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 - This is the main file updated by this program. It stores all of the dimensions parameters. ACIAMBR - This is another main file updated by this program. It holds all of the valid values for year, year variance, period, budget and budget variance members. GLIADIM - This file is updated with the parameters for the Organization dimension. This dimension is owned by GL, so the parameters are stored in a GL file. GLIAMBR - This file is updated if the Organization dimension is also defined with accounting unit views. MEMBER - OLAPDBM - This program references this file to validate whether or not the application type has been assigned to the OLAP database. OLAPDIM - This program updates the OLAPDIM data file with the dimensions that are defined. Referenced Files ACACTGRP - This file validates the activity group. ACACTIVITY - ACRPTGRP - This file validates the activity group collection. ACRPTGRPX - This file also validates the activity group collection. APPLICTYPE - This file validates the application name. GLADDRESS - This file validates the GL company and accounting unit. GLCGCPY - This file validates the GL company. GLCHART - This file is referenced in a common routine. GLNAMES - This file provides the accounting unit name. GLSYSTEM - This file is referenced in a common routine. MXVIEWHDR - This file validates the activity and accounting unit views. AC87.2 - Nulls 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 ACIADIM - AC87.3 - Budgets 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 ACIAMBR - Referenced Files ACIADIM - AC87.4 - Budget Variances 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 ACIADIM - AC87.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 ACIADIM - AC87.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 ACIADIM - CUCODES - AC87.7 - Years 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 ACIAMBR - Referenced Files ACIADIM - INVOKED Programs IFOB IFSG |