integrators

Xcelsius
apos systems
antivia
http://infoburst2009.com/

Product integration roadmap
http://www.slideshare.net/ballesjavi/sapnwbwandbobjbipjuneupdate?from=ss_embed

filtro de prompt

CASE WHEN QC1_DMT_DIM_ORGANISATION.QC1_LEV_02_CODE IN ('PRR','REA') THEN QC1_DMT_DIM_ORGANISATION.QC1_LEV_02_DESC ELSE '' END

Agrupamento

CASE WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1A' THEN 'PEAGE perception'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1B' THEN 'PEAGE enc.technique'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1C' THEN 'PEAGE commercial'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003 in ('2A','2B') THEN 'VIABILITE/SECURITE'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003 in ('3A','3B') THEN 'MAINTENANCE & ATELIER'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='4A' THEN
CASE WHEN QC1_DMT_DIM_ORGANISATION.QC1_LEV_03_CODE='1' THEN 'STRUCTURE EXPLOITATION'
ELSE 'STRUCTURE HORS EXPLOITATION'
END
ELSE ''
END

BO Prompts filter

Year and Year -1

TO_CHAR (QC1_DMT_DIM_DATE.QC1_DAT_DAY, 'YYYY') in (SUBSTR(@Prompt('Fin de période','A','Temps\Année',mono,constrained,persistent),1,4), (SUBSTR(@Prompt('Fin de période','A','Temps\Année',mono,constrained,persistent),1,4) - 1))

Year -1

TO_CHAR (QC1_DMT_DIM_DATE.QC1_DAT_DAY, 'YYYY') = (SUBSTR(@Prompt('Fin de période','A','Temps\Année-Mois',mono,constrained,persistent),1,4) - 1)

atual - 2

TO_CHAR(SYSDATE,'YYYY') - TO_CHAR (QC1_DMT_DIM_DATE.QC1_DAT_DAY, 'YYYY')

Probably SAP new Architecture