Cognos 8 » Data Manager

ID #1091

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:

Dernière mise à jour: 2011-10-06 12:14
Auteur: Michel Preti
Révision: 1.1

Digg it! Imprimer cet article Envoyer à un ami version PDF
Propose a translation for Propose a translation for
Merci de noter cette entrée:

Moyenne des notes: 0 sur 5 (0 Votes)

complètement inutile 1 2 3 4 5 indispensable

Vous ne pouvez pas commenter cet enregistrement