C105

Allocations Analysis Detailed
Input 2 workflows

Properties source
Sources: prospetto

Code
C105
Description
Allocations Analysis Detailed
Web opening
NV
Type flags
Input
Groups
C1 Standard Allocations

Structure source
Sources: prospetto_xml

Form parameters
4
Dimension Hierarchy Parameter
AZIENDA
Entity;fr=Entité
010
All Entities
03
Choose an Entity
PERIODO
Period
$PER_P
LUNPER Per_Length
Duration
SCENARIO
Scenario
$
Scenarios
SCE_REP
Scenarios for CY
Form filters
5 dims
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
PERIODOPeriod 1
$PER_P
TIP 1
Hierarchy / FST Item Type TGKML
TIP_O fixed
LUNPER 1
Per_Length
SCENARIOScenario 1
Hierarchy / FST Item Type TGKML
$ Scenarios SCE_REP param
Allocation Customers & Products
Template02 · 3 matrices
Sender CPM
Filters
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
Rows
CONTOAccount;fr=Compte 4
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 75040 Legal Services fixed
010 All Accounts - BS, PL & Statistical Accounts 65035 Utilities fixed
010 All Accounts - BS, PL & Statistical Accounts 65075 Rent fixed
010 All Accounts - BS, PL & Statistical Accounts 50010 Product Sales fixed
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
DEST1Cost Centers;fr=Centre cout 2
Hierarchy / FST Item Type TGKML
010 Departmental View 010 fixed
010 Departmental View CC_500 Generic Cost Center fixed
Cols
TIP 1
Hierarchy / FST Item Type TGKML
TIP_O fixed
Product Allocation CPM
Filters
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
CONTOAccount;fr=Compte 3
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 75040 Legal Services fixed
010 All Accounts - BS, PL & Statistical Accounts 65075 Rent fixed
010 All Accounts - BS, PL & Statistical Accounts 65035 Utilities fixed
Rows
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
010 Products by Category ALL fixed
Cols
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
010 Original Data fixed
022 Allocation to Customers and Products fixed
Customer Allocation CPM
Filters
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
CONTOAccount;fr=Compte 3
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 75040 Legal Services fixed
010 All Accounts - BS, PL & Statistical Accounts 65075 Rent fixed
010 All Accounts - BS, PL & Statistical Accounts 65035 Utilities fixed
Rows
DEST3Customers;fr=Clients 1
Hierarchy / FST Item Type TGKML
020 Customers by Type 020 fixed
Cols
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
010 Original Data fixed
022 Allocation to Customers and Products fixed
CC Allocation Details
Template03 · 0 matrices
OH Allocation to CCs
Template00 · 2 matrices
Drivers CPM
Rows
CONTOAccount;fr=Compte 3
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 65075 Rent fixed
010 All Accounts - BS, PL & Statistical Accounts 75040 Legal Services fixed
010 All Accounts - BS, PL & Statistical Accounts 65035 Utilities fixed
Cols
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
DEST1Cost Centers;fr=Centre cout 1
Hierarchy / FST Item Type TGKML
010 Departmental View CC_070 Shared Services fixed
Step 1 - Allocation Results CPM
Filters
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
Rows
DEST1Cost Centers;fr=Centre cout 1
Hierarchy / FST Item Type TGKML
010 Departmental View 010 fixed
Cols
CONTOAccount;fr=Compte 6
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 65075 Rent fixed
010 All Accounts - BS, PL & Statistical Accounts ST_970 Square Footage fixed
010 All Accounts - BS, PL & Statistical Accounts 75040 Legal Services fixed
010 All Accounts - BS, PL & Statistical Accounts ST_980 # of Contracts fixed
010 All Accounts - BS, PL & Statistical Accounts 65035 Utilities fixed
010 All Accounts - BS, PL & Statistical Accounts ST_540 FTE fixed
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
010 Original Data fixed
020 Allocation to Cost Centers fixed

Queries 1 source
Sources: prospetto_xml

Allocation Drill Through
SQL 010
select cod_conto as "Account", cod_dest1 as "Cost Center", importo as "Amount", Conto_prov as "Sender Account", dest1_prov as "Sender Cost Center", NUMERATORE as "Numerator", DENOMINATORE as "Denominator", userupd as "User", dateupd as "Date"from CL_DATI_MOVIMENTO
where cod_regola_versione ='010'
and cod_regola = '10'

and cod_scenario = ${$Scenario.code}
and cod_periodo = ${$Period.code}
and cod_conto = ${$Account.code}
and cod_dest1 = ${$Cust_Dim1.code}

Used in Workflows 2 source
Sources: RACCOLTA_AZIENDA_WFM, WFM task list

Workflow Phase Task list Task description
ACT Close & Consolidation Workflow 004 Supp. Info & JE 04 Supp. Info & JE Analyze Profitability
BDG Annual Budget Workflow 40_OP Expense Plan OPX Opex Detail Allocation Analysis