GETCOGNOS

GETCOGNOS reads IBM® Cognos® Business Intelligence version 11 and higher data packages and list reports.

Note: Square brackets used in the GETCOGNOS syntax chart are required parts of the syntax and are not used to indicate optional elements. Equals signs (=) used in the syntax chart are required elements.
GETCOGNOS 
  /MODE TYPE={DATA**}
             {REPORT}

  /CONNECTION SERVERURL='string'
   MODE={CREDENTIALS     }
        {ANONYMOUS       }
        {STOREDCREDENTIAL}  
   NAMESPACE='string'
   USERNAME='string'
   PASSWORD='string' ENCRYPTED={YES**}
                               {NO   }
   CREDENTIAL='name'

  /LOCATION PACKAGE='string'

  /IMPORT 
    {FIELDS =
     '[namespace].[query subject].[query item]' (newname),
     '[namespace].[query subject].[query item]' (newname),
     '[namespace].[query subject].[query item]' (newname)...}
    {REPORT = 'report name'}
    AGGREGATE={NO**}
              {YES }

  /FILTER VALUE='[namespace].[filter name]',
    '[namespace].[filter name]'...

  /PARAMETERS 'parameter'='value''parameter'='value'...

**Default if keyword omitted.

  • The CONNECTION, LOCATION, and IMPORT subcommands are required.
  • The MODE, FILTER and PARAMETERS subcommands are optional.

This command reads the active dataset and causes execution of any pending commands. See the topic Command Order for more information.

Release History

Release 21.0

  • Command introduced.

Release 23.0

  • CREDENTIAL keyword introduced on CONNECTION subcommand.
  • Value STOREDCREDENTIAL added to MODE keyword on CONNECTION subcommand.

Example

GETCOGNOS
  /MODE TYPE=DATA
  /CONNECTION SERVERURL='http://myserver:9300/p2pd/servlet/dispatch' 
   MODE=ANONYMOUS 
  /LOCATION PACKAGE='/My Folders/Sales'
  /IMPORT FIELDS='[great_outdoor_sales].[my package].[ID]',
   '[great_outdoor_sales].[my package].[Geographic region]'  (Region),
   '[great_outdoor_sales].[my package].[sales]'.