1234567891011121314151617181920212223242526272829 |
- COGNOS QUERY
- STRUCTURE,1,1
- DATABASE,ARIntelligence
- DATASOURCENAME,C:\GlobalCube\SYSTEM\ARIntelligence\IQD\service\Serviceberater_Struktur_MA-Stamm_LBS.imr
- TITLE,Serviceberater_Struktur_MA-Stamm_LBS.imr
- BEGIN SQL
- select T1."No_" as c1,
- T1."Name" as c2,
- T1."Resource Group No_" as c3,
- T1."Last Name" as c4,
- T1."First Name" as c5,
- '1' as c6,
- '10' as c7,
- T1."Name" || '10' as c8,
- T1."Name" as c9
- from "Automag7x"."dbo"."Automag GmbH$Resource" T1
- where (T1."Resource Group No_" = 'SB')
- END SQL
- COLUMN,0,No
- COLUMN,1,Name
- COLUMN,2,Resource Group No
- COLUMN,3,Last Name
- COLUMN,4,First Name
- COLUMN,5,Hauptbetrieb
- COLUMN,6,Standort
- COLUMN,7,Name_Standort
- COLUMN,8,Serviceberater
|