TEST_SRO

Rapport Test
Input

Properties source
Sources: prospetto

Code
TEST_SRO
Description
Rapport Test
Web opening
C
Type flags
Input

Structure source
Sources: prospetto_xml

Form parameters
3
▾
Dimension Hierarchy Parameter
› — › DIMENSION
Dimension
› — › HIERARCHIE
Hierarchie
VALUTA
Currency 		› — › $VAL_P
Form filters
1 dim
▾
VALUTACurrency 1
▾
Hierarchy / FST Item Type TGKML
— › $VAL_P param
1
Template00 · 0 matrices
▾

Queries 1 source
Sources: prospetto_xml

Query 00
SQL Query00
▾ 
SELECT COD_PROSPETTO, CASE WHEN HIERARCHIE_UTILISEE <> 0 THEN 'Oui' END as "HIERARCHIE UTILISEE"
FROM 
(SELECT
COD_PROSPETTO
,POSITION('<s key="dim">' || ${@DIMENSION.code} || '_' || ${@HIERARCHIE.code} || '</s>' IN CONVERT_FROM(XML, 'UTF8')) AS HIERARCHIE_UTILISEE
 
FROM PROSPETTO_XML) Q
WHERE HIERARCHIE_UTILISEE <> 0