Category Archives: Cognos TM1

Cognos BI in DQM mode caches all the TM1 cube metadata. But sometimes you need to be able to tell Cognos that I got new elements (common example you run import process which added new dimension elements). I tried to set “Use Local Cache” set to “No”, but it didn’t help. The problem was solvedContinue reading “COGNOS BI REFRESH TM1 DIMENSION CACHE”

IntegratedSecurityMode Here I would like to explain some moments of managing security with IntegratedSecurityMode=5. When you configure Cognos TM1 to use IntegratedSecurityMode = 5, in Security -> Clients/Groups you can import clients and groups from Cognos BI security. The only way to add TM1 native security group is to use TI process function: AddGroup(GroupName); YouContinue reading “IBM COGNOS INTEGRATEDSECURITYMODE 5”

TM1 supports a standard MDX function ASCENDANTS which returns all the parent elements (up to the dimension root). Let’s say you have a dimension like: — World —- Europe —— UK —— France ——– Paris —- North America —— USA —— Canada ——– Toronto —- South America —— Brazil You want to select {Toronto, Paris}Continue reading “TM1 MDX: GET ALL THE ASCENDANTS OF SUBSET ELEMENTS”

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”

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”

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”

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”