IBM Cognos Disclosure Management (CDM) Cognos Disclosure Management is used for Internal and External Reporting. It connects to multiple datasources and allows to generate reports in MS Word, Excel, PowerPoint, PDF, HTML, Edgarization and XBRL. For example you can get a Word document report which includes different text data with updated numbers, tables, charts etc.Continue reading “IBM COGNOS SOFTWARE”
Author Archives: Vlad Didenko
NOTEPAD++ REGEX (REGULAR EXPRESSION)
new line: rn tab: t space: s digit: d non-digit: D Examples: Starting from tab, then any characters and the end of line t(.)*rn Two spaces: ss Doesn’t contain string1 .*(?!.*string2.*) Contains string1 but not string2 after: ^.*string1.*(?!.*string2.*)$ Contains string1 then any characters up to the line break: ( string1)+(.)* rn
TM1CAMCLIENT ERROR WITH CAM PASSPORT
http://didenko.ca/blog/wp-content/plugins/syntax-highlighter-compress/scripts/shBrushXml.js If you get this error check the next things: ServerCAMURI and ClientCAMURI are correct: open both URLs in a browser, Cognos Connection or Authentication page should be loaded If you have and redirection configured in your web server for your Cognos BI host, use that destination host For example for IIS rewrite rules (web.config):Continue reading “TM1CAMCLIENT ERROR WITH CAM PASSPORT”
CMD / BATCH FILE USEFUL CODE
:: check last server reboot date and time systeminfo|find “Time:” :: create empty file COPY /y NUL %filePath% >NUL :: check folder file count SET /a fileCnt=0 FOR /f “tokens=* delims= ” %%a IN (‘DIR/s/b/a-d “%folderPath%”‘) DO ( SET /a fileCnt+=1 ) IF “%fileCnt%” NEQ “0” (ECHO Some files found)
COGNOS BI – SAVE REPORT OUTPUT TO A FILE SYSTEM
Edit Cognos configuration, go to “Actions” menu > Edit Global Configuration and set “Archive Location File System Root” (the root folder for all your output folders) You can click “Test” button to check everything is ok. Click OK to close the “Global Configuration” windows then go to Data Access > Content Manager and set “SaveContinue reading “COGNOS BI – SAVE REPORT OUTPUT TO A FILE SYSTEM”
TM1 PICKLIST
Picklist is an element attribute which allows to define a list of possible values for that element. Of course it must be a measure dimension element in order a picklist to work. To define a picklist you need to add “Picklist” string attribute to your dimension and for the required element set it to oneContinue reading “TM1 PICKLIST”
IBM COGNOS TM1 LOADING DATA FROM SAP BW
In this article I will show you how to load SAP BW data to TM1 using IBM Cognos Package Connector. Installation of the required software So you need to install and configure the next things: Install the SAP libraries that are specific for the platform and operating system on which you are running SAP EnsureContinue reading “IBM COGNOS TM1 LOADING DATA FROM SAP BW”
VBA SUBSTRING / MID
Use MID function to return a substring: Function specification: Mid( string, start, length) Dim TestString As String = “Mid Function Demo” ‘ Returns “Mid”. Dim FirstWord As String = Mid(TestString, 1, 3) ‘ Returns “Demo”.
TM1 MDX FILTER BY SUBSTRING
The next technique allows to filter elements by attribute / name substring: { FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [MyDim] )}, 0)}, INSTR([MyDim].[MyAlias], “SubString” ) > 0 ) } * There is also TM1FILTERBYPATTERN function but it’s limited to filtering by name only and doesn’t have “negation”
VBA SEARCH IN STRING INSTR CASE INSENSITIVE
http://didenko.ca/blog/wp-content/plugins/syntax-highlighter-compress/scripts/shBrushVb.js InStr specification: Instr( [start], string, substring, [compare] ) MsgBox InStr(“Hi there”, “THERE”) ‘ will return 0, as “THERE” doesn’t match the case: ‘ use vbTextCompare to make the search case insensitive: MsgBox InStr(1, “Hi there”, “THERE”, vbTextCompare) ‘ will return 4
Cognos/TM1 