BMT-MD-2049

Error BMT-MD-2049

Getting error BMT-MD-2049 on validating a project. I got this error on a dutch installation, so the error description is in dutch.

BMT-MD-2049 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de normale aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
BMT-MD-2050 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de semi-additieve aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
Continue reading

Multi dimensional functions

In Cognos you can use a lot of Dimensional functions. Information about these functions can be found on:

http://www.ibm.com/developerworks/data/library/cognos/page82.html

You can download a zip-file here witch contains a PDF and a zip-file with examples.

The dimensional functions can be used with crosstab reports with for example year, quarter and sales facts.

A usefull example can be found on Youtube:

http://www.youtube.com/watch?NR=1&v=o3aw4ViiLlE

Data Manager Catalog Backup

It is posible to automate the backup of a Datamanager Catalog.

On ittoolbox.com, Michael Sherman replied that his script can be used as an example:

SET DATESTAMP=%DATE%

SET TIMESTAMP=%TIME%

SET YEAR=%DATESTAMP:~10,4%

SET MONTH=%DATESTAMP:~4,2%

SET DAY=%DATESTAMP:~7,2%

SET HOUR=%TIMESTAMP:~0,2%

SET MINUTE=%TIMESTAMP:~3,2%

SET FILEDATE=%YEAR%-%MONTH%-%DAY%_%HOUR\%%MINUTE%

C:\Progra~1\cognos\c8\bin\CATBACKUP.exe ODBC “DSN=[ODBC Connection to Catalog Database];UID=[User ID to log onto Database];PWD=[Password to Log onto Database]” “[Full Path Name for the Catalog Backup]%FILEDATE%.ctg”

You can also take a look in the IBM Datamanager User Guide on page 430.