Cognos 8 » Data Manager
Lister vos composants Data Manager
Â
SELECT component_type COMPOSANT_TYPE_CODE,
        CASE
           WHEN component_type = 'J' THEN 'Jobstream'
           WHEN component_type = 'B' THEN 'Fact Build'
           WHEN component_type = 'S' THEN 'Dim Build'
           WHEN component_type = 'D' THEN 'Dimension'
           WHEN component_type = 'H' THEN 'Dim Hierarchy'
           WHEN component_type = 'L' THEN 'Dim Lookup'
           WHEN component_type = 'T' THEN 'Template'
           WHEN component_type = 'A' THEN 'Data Source'
           WHEN component_type = 'F' THEN 'Function'
           WHEN component_type = 'K' THEN 'Metadata Dim'
           WHEN component_type = 'J' THEN 'Metatdata Collection'
           WHEN component_type = 'N' THEN 'Name of Environment'
           WHEN component_type = 'P' THEN 'Preferences'
           WHEN component_type = 'R' THEN 'Folder'
           ELSE '?'
        END
           AS COMPOSANT_TYPE_DESCRIPTION,
        component_name COMPOSANT_NOM
   FROM dsb_component
ORDER BY component_type, component_name
Tags: dates dimension SQL SELECT
Related entries:
Auteur: Michel Preti
Révision: 1.1
Vous ne pouvez pas commenter cet enregistrement