Serviceberater_Struktur_MA-Stamm_WLS.iqd 702 B

1234567891011121314151617181920212223242526272829
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,ARIntelligence
  4. DATASOURCENAME,C:\GlobalCube\SYSTEM\ARIntelligence\IQD\service\Serviceberater_Struktur_MA-Stamm_WLS.imr
  5. TITLE,Serviceberater_Struktur_MA-Stamm_WLS.imr
  6. BEGIN SQL
  7. select T1."No_" as c1,
  8. T1."Name" as c2,
  9. T1."Resource Group No_" as c3,
  10. T1."Last Name" as c4,
  11. T1."First Name" as c5,
  12. '1' as c6,
  13. '20' as c7,
  14. T1."Name" || '20' as c8,
  15. T1."Name" as c9
  16. from "Automag7x"."dbo"."Automag GmbH$Resource" T1
  17. where (T1."Resource Group No_" = 'SB')
  18. END SQL
  19. COLUMN,0,No
  20. COLUMN,1,Name
  21. COLUMN,2,Resource Group No
  22. COLUMN,3,Last Name
  23. COLUMN,4,First Name
  24. COLUMN,5,Hauptbetrieb
  25. COLUMN,6,Standort
  26. COLUMN,7,Name_Standort
  27. COLUMN,8,Serviceberater