SAVETM1

SAVETM1 saves data from the active dataset to an IBM® Cognos® TM1® cube.

SAVETM1

  /CONNECTION PMSYSURL='string'
   SERVER='string'
  [NAMESPACE='string']
   USERNAME='string'
   PASSWORD='string' ENCRYPTED={YES**}
                               {NO   }

  /CUBE NAME='string'

  /MAPPINGS  MEASURE_FIELDS = fieldname (MAPTO='element name' NEW={YES | NO}) ...
            [DIMENSION_FIELDS = fieldname (MAPTO='dimension name') ... ]
            [SLICES = 'dimension name' (LEAF='element name') ... ]

**Default if keyword omitted.

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

Release History

Release 22.0.0.1

  • Command introduced.

Example

SAVETM1
  /CONNECTION PMSYSURL='http://mypmsystem:9510/pmhub/pm'
   SERVER='myserver'
   USERNAME='tm1user'
   PASSWORD='#o/B!a.],-./.-#('  ENCRYPTED=YES

  /CUBE NAME='mycube'

  /MAPPINGS MEASURE_FIELDS=PredictedSales (MAPTO='Predicted Sales' NEW=YES)

            DIMENSION_FIELDS=Region (MAPTO='Region')
                             Product (MAPTO='Product')
                             Month (MAPTO='Month')  

            SLICES='Store Type' (LEAF='Department Store').