COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\SYSTEM\ARIntelligence\IQD\belege\Belege_Plan.imr
TITLE,Belege_Plan.imr
BEGIN SQL
select T1."Entry No_" as c1,
	   T1."Budget Name" as c2,
	   T1."G_L Account No_" as c3,
	   T1."Date" as c4,
	   T1."Global Dimension 1 Code" as c5,
	   T1."Global Dimension 2 Code" as c6,
	   (cast_float(T1."Amount")) as c7,
	   T1."Description" as c8,
	   T1."Business Unit Code" as c9,
	   T1."User ID" as c10,
	   T1."Budget Dimension 1 Code" as c11,
	   T1."Budget Dimension 2 Code" as c12,
	   T1."Budget Dimension 3 Code" as c13,
	   T1."Budget Dimension 4 Code" as c14,
	   T1."Last Date Modified" as c15,
	   T1."Dimension Set ID" as c16,
	   T1."Branch Code" as c17,
	   T1."Date" as c18,
	   '1' as c19,
	   CASE WHEN (T1."Branch Code" = 'LBS') THEN ('10') WHEN (T1."Branch Code" = 'WLS') THEN ('20') ELSE null END as c20,
	   ((cast_float(T1."Amount"))) as c21,
	   T1."G_L Account No_" as c22
from "Automag7x"."dbo"."Automag GmbH$G_L Budget Entry" T1
where ((T1."Date" >= TIMESTAMP '2020-01-01 00:00:00.000') and ((od_year(T1."Date")) <= (od_year((now())))))

END SQL
COLUMN,0,Entry No
COLUMN,1,Budget Name
COLUMN,2,G L Account No
COLUMN,3,Date
COLUMN,4,Global Dimension 1 Code
COLUMN,5,Global Dimension 2 Code
COLUMN,6,Amount
COLUMN,7,Description
COLUMN,8,Business Unit Code
COLUMN,9,User Id
COLUMN,10,Budget Dimension 1 Code
COLUMN,11,Budget Dimension 2 Code
COLUMN,12,Budget Dimension 3 Code
COLUMN,13,Budget Dimension 4 Code
COLUMN,14,Last Date Modified
COLUMN,15,Dimension Set Id
COLUMN,16,Branch Code
COLUMN,17,Bookkeep Date
COLUMN,18,Hauptbetrieb
COLUMN,19,Betrieb Nr
COLUMN,20,Plan
COLUMN,21,Acct Nr