C105
Allocations Analysis Detailed
Properties Sources: prospetto
- Code
C105- Description
- Allocations Analysis Detailed
- Web opening
NV- Type flags
- Input
- Groups
- C1
Structure
Sources: prospetto_xml
Form parameters
4
▾
Form filters
5 dims
▾
Allocation Customers & Products
Template02 · 3 matrices
Sender
CPM
Rows
CONTO
4
Cols
TIP
1
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| › | TIP_O | fixed |
Product Allocation
CPM
Customer Allocation
CPM
CC Allocation Details
Template03 · 0 matrices
OH Allocation to CCs
Template00 · 2 matrices
Drivers
CPM
Step 1 - Allocation Results
CPM
Queries 1
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}