Category Archives: Cognos TM1

Here I would like to mention some possible causes of (TR0168) Transformer could not open the data source error in TM1 If you use CAM authentication (Cognos BI) and see an additional error message: QE-DEF-0368 Unable to decrypt user name and password credentials from the content store. Review and save the Cognos Configuration settings toContinue reading “(TR0168) Transformer could not open the data source [Data source name]”

What are the basic features of Cognos TM1? • Real-time, interactive multidimensional database also with write-back functionality • 64-bit, in memory OLAP server capable of concentrate huge volumes of data • Enterprise level planning and analysis capabilities • Guided modeling environment to facilitate planning, analysis and forecasting • Rapid development of flexible models, including profitabilityContinue reading “TM1 Interview questions”

This article will be collecting useful information on TM1 Perspectives DBRA(server:dimension, element, attribute) – returns the value of a specified element attribute DBRA function requires that a numeric element name be enclosed in double quotes or if you use a cell reference then make sure that cell is not formatted as numeric DBRA will failContinue reading “TM1 Perspectives”

This article will be collecting useful information about how TM1 FEEDERS work. 1. TM1 has a sparse consolidation algorithm which allows to skip calculations of empty/zero cells and significantly improve the performance. If you have a cube rule, by default TM1 turns off this algorithm because one or more empty cells may in fact beContinue reading “TM1 FEEDERS”

Transaction log file displays the transactions recorded in Tm1s.log when a TM1 client changes a cube value. To view it right-click the server and select Transaction log. If you get “ActiveX control (msmask32.ocx) could not be instantiated. Reinstall or register control and try again” you need to make sure you have “msmask32.ocx” on your machineContinue reading “TM1 Transaction log – ActiveX control (msmask32.ocx) could not be instantiated”

Overview We can drill from a cube view (or TM1Web websheet) to: 1). ODBC data source (the ODBC source must be accessible from the computer on which the TM1 server is running) 2). another cube view 3). any data source TurboIntegrator supports The first thing you need to do is to create a drill process.Continue reading “TM1 Drill-through (process and view)”

Here is a trick how you can make TM1Web to export your Exel websheet fitting it to one or multiple pages and setting page orientation: 1. Open your websheet in Excel 2. Go to “Page Layout” menu and set your page orientation: 2. On the same tab go to “Page Setup” and set scaling options:Continue reading “TM1Web Export to PDF scaling fit to one page, page orientation”

Cube Security Control cube: }CubeSecurity Dimension Security Control cube: }DimensionSecurity Element Security Control cube: }ElementSecurity_<%DimensionName%> Default (blank) is NONE. User group should have at least READ access to see the element. Cell Security Control cube: }CellSecurity_<%CubeName%> Cell security is used in general to override element security (only if a user group has other then NONEContinue reading “IBM COGNOS TM1 SECURITY”

dn = dim_target; ## week days sWeekdays = ‘SunMonTueWedThuFriSat’; ## week day: 0 = Sunday, 1 = Monday, …, 6 = Saturday nWeekday = MOD( DayNo( TODAY ) + 21915, 7); ## day name lookup sDayName = Subst(sWeekdays,nWeekday*3+1,3);