E201

Comments Analysis
Input

Properties source
Sources: prospetto

Code
E201
Description
Comments Analysis
Web opening
C
Type flags
Input
Groups
E22 Expense Analytics

Structure source
Sources: prospetto_xml

Form parameters
2
Dimension Hierarchy Parameter
SCENARIO
Scenario
$
Scenarios
SCE_BDG
Scenario for Budget
PERIODO
Period
$PER_P
Comments Analysis
Template00 · 1 matrix
Top 15 Accounts CPM
Filters
LUNPER 1
LUN_1
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
Rows
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 020 fixed
DEST1Cost Centers;fr=Centre cout 1
Hierarchy / FST Item Type TGKML
010 Departmental View ALL fixed
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts 300 fixed
Cols
SCENARIOScenario 1
Hierarchy / FST Item Type TGKML
$ Scenarios SCE_BDG param
PERIODOPeriod 1
$PER_P

Queries 1 source
Sources: prospetto_xml

Comments
SQL AA
SELECT COMMENTI AS "Comment", DESC_AZIENDA0 as "Entity", DESC_DEST10 as "Cost Center", DATI_COMMENTI.USERUPD AS "Edited by", DATI_COMMENTI.dateupd as "Time" FROM DATI_COMMENTI 
INNER JOIN DEST1 
ON DATI_COMMENTI.DEST1=DEST1.COD_DEST1
INNER JOIN AZIENDA
ON DATI_COMMENTI.AZIENDA=AZIENDA.COD_AZIENDA
WHERE COD_SCENARIO = ${$Scenario.code}
and COD_PERIODO = ${$Period.code}
AND CONTO = ${$Account.code}
AND AZIENDA = ${$Entity.code}
AND FLAG_ATTIVO = 1