COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\belege\Kontenrahmen_kombiniert.imr
TITLE,Kontenrahmen_kombiniert.imr
BEGIN SQL
select distinct (rtrim(T1."ACCT_NR")) as c1,
	   CASE WHEN ((T2."MAKE" IS NULL) or ((rtrim(T2."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T2."MAKE"))) END as c2,
	   CASE WHEN ((((rtrim(T1."ACCT_NR"))) LIKE '2%') and (T2."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T2."SITE",2)),2))) END as c3,
	   CASE WHEN ((T2."DEPARTMENT" IS NULL) or ((rtrim(T2."DEPARTMENT")) = '')) THEN ('00') ELSE (T2."DEPARTMENT") END as c4,
	   CASE WHEN ((T2."DESTINATION" IS NULL) or ((rtrim(T2."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T2."DESTINATION")),2))) END as c5,
	   (truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and (T2."PRODUCT_GROUP" <> '')) THEN (T2."PRODUCT_GROUP") WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and (T2."REPAIR_GROUP" <> '')) THEN (T2."REPAIR_GROUP") ELSE ('00') END)) as c6,
	   CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN ('NW') WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and (T2."PRODUCT_GROUP" <> '')) THEN ('TZ') WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and (T2."REPAIR_GROUP" <> '')) THEN ('SC') ELSE ('') END as c7
from "OPTIMA"."import"."ACCOUNT_INFO" T1,
	("OPTIMA"."import"."ACCT_DOC_KEY" T2 left outer join "OPTIMA"."import"."vPP5Q" T3 on (T2."MODEL_LINE" = T3."MODEL_LINE") and (T2."MAKE" = T3."MAKE_CD"))
where (T1."ACCT_NR" = T2."ACCT_NO")
and (T2."BOOKKEEP_DATE" >= TIMESTAMP '2020-01-01 00:00:00.000')
order by c1 asc,c3 asc,c4 asc,c2 asc

END SQL
COLUMN,0,Konto_Nr
COLUMN,1,Marke
COLUMN,2,Standort
COLUMN,3,Kostenstelle
COLUMN,4,Absatzkanal
COLUMN,5,Kostenträger
COLUMN,6,Kostenträger_Quelle