tag:blogger.com,1999:blog-175098602024-03-14T18:54:36.277+10:30IBM Cognos TM1, Cognos BI, Cognos Express, CDMBlog of IBM Cognos TM1, Cognos BI, Cognos Express, CDM and other related stuff.James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comBlogger220125tag:blogger.com,1999:blog-17509860.post-82773074832016296282015-09-16T09:22:00.002+09:302015-09-16T09:22:31.704+09:30TM1 10.2.2 Fix Pack 4 - SubsetCreate, SubsetCreateByMDX, and ViewCreate TurboIntegrator functions extended to allow creation of temporary objectsThis is hopefully a massive major step forward in architecting large models in TM1: <a href="http://www-01.ibm.com/support/docview.wss?uid=swg27046436">http://www-01.ibm.com/support/docview.wss?uid=swg27046436</a><br />
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-90576386777501597332015-08-27T09:26:00.000+09:302015-08-27T09:26:07.536+09:30TM1 with JavaMassive respect for Alan Kirk on his detailed "Introduction To The Client Side Java API" on www.tm1forum.com<br />
<br />
Its a great guide for those of you wanting to explore this area of TM1<br />
<br />
<a href="http://www.tm1forum.com/viewtopic.php?f=21&t=11929">http://www.tm1forum.com/viewtopic.php?f=21&t=11929</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-16941974459534288162014-10-30T09:10:00.002+10:302014-10-30T09:10:16.406+10:30CX 10.2.1 FP2<div class="MsoNormal">
<span style="color: #1f497d;">CX 10.2.1 FP2 now available
which includes Office 2013 support<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d;"><a href="http://www.ibm.com/support/docview.wss?uid=swg24038542">http://www.ibm.com/support/docview.wss?uid=swg24038542</a><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d;">The download is on Fix Central
now at <a href="http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Express&release=10.2.1&platform=All&function=fixId&fixids=10.2.1-BA-CX-Win64-FP002">http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Express&release=10.2.1&platform=All&function=fixId&fixids=10.2.1-BA-CX-Win64-FP002</a><o:p></o:p></span></div>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-65453103388549897352014-10-29T20:21:00.002+10:302014-10-29T20:21:15.609+10:30IBM Cognos Command Centre OverviewLink to my video showing Cognos Command Centre and its integration with TM1 <a href="http://youtu.be/Age5lEMRJ3M">http://youtu.be/Age5lEMRJ3M</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-45649224113549485792014-10-05T11:10:00.002+10:302014-10-05T11:10:30.635+10:30Cognos TM1, Insight and Analysis for Microsoft Excel 10.2.2 Fix Pack 1 now availableGrab the fix pack now and get all the details from here: <a href="http://www-01.ibm.com/support/docview.wss?uid=swg21686239">http://www-01.ibm.com/support/docview.wss?uid=swg21686239</a>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-15850838971082355322014-04-14T22:28:00.001+09:302014-04-14T22:28:12.916+09:30How to read IBM Cognos TM1 Version NumbersBreaking this one down:<br />
10.1.00100.24600<br />
<br />
"10.1.0" = TM1 10.1.0<br />
<br />
"00100" = FP1<br />
<br />
"24600" = Build number, useful for IBM Support.<br />
<br />
The important numbers are the middle ones (00100).<br />
<br />
The first is part of the major release (aka 10.1.10000 = TM1 10.1.1)<br />
<br />
The next 2 numbers are for the FP.<br />
<br />
The last 2 numbers are for the IF (aka Hotfix).<br />
<br />
<br />
Examples:<br />
<br />
10.1.00100.24600 = TM1 10.1.0 FP1<br />
<br />
10.1.10000.26473 = TM1 10.1.1 Base Release<br />
<br />
10.1.10100.31864 = TM1 10.1.1 FP1 (For 10.1.1 FP2 this would be 10.1.10200.xxxxx)<br />
<br />
10.1.10104.34644 = TM1 10.1.1 FP1 IF4<br />
<div>
<br /></div>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-65998217143301368762014-04-11T11:04:00.003+09:302014-04-11T11:04:57.578+09:30IBM CDM User groupCheck out the IBM CDM User Group and the useful videos they have:<br />
<br />
<a href="https://ibm.biz/CDMUserGroup">https://ibm.biz/CDMUserGroup</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-35022518076187590602014-04-10T13:24:00.000+09:302014-04-10T13:24:03.654+09:30TM1/CDM Best Practices from IBM SupportlinkCheck out some new TM1 and CDM best practices on IBM Supportlink:<br />
<br />
<a href="https://www-304.ibm.com/connections/blogs/basupportlink/entry/new_documents_of_interest_for_ibm_cognos_tm1_and_fpm_users?lang=en_us">https://www-304.ibm.com/connections/blogs/basupportlink/entry/new_documents_of_interest_for_ibm_cognos_tm1_and_fpm_users?lang=en_us</a><br />
<br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-20783200105115706052014-04-06T15:35:00.001+09:302014-04-06T15:35:25.235+09:30Upgrading Cognos Express 10.1 to 10.2<div>
<div style="font-family: Tahoma; orphans: 2; text-align: -webkit-auto; widows: 2;">
I recently completed a Cognos Express upgrade to version 10.2 and thought I would document some tips:</div>
<div style="font-family: Tahoma; orphans: 2; text-align: -webkit-auto; widows: 2;">
<ul>
<li>The download for Cognos Express is now 7.6gb! Leave plenty of time for download from the site and then transfer to your server.</li>
<li>You will find the install now switches from \Program Files (X86)\ <br />to \Program Files\ as it moves fully 64 bit. Make sure you update any scripts or TI's to the new path</li>
<li>The restores of CX you will have taken before the un-install of previous version will be sitting in the Backup directory of X86</li>
<li>IE is not great to work with Express Manager so make sure you have Chrome/Firefox handy.</li>
<li>The Performance Modeler Rich Client would not un-install at the start. I switched off UAC to get the un-install to work</li>
<li>Performance Modeler had lots of upgrades and changes in 10.2. Some of these changes may affect any contributor application you have. I had one application where there was a conflict and PM just deleted the Application. You will need to check your application in Performance Modeler and adjust to 10.2 </li>
<li>Make sure you remember to upgrade your tm1web .xls to .xlsx</li>
<li>Windows 8 is supported for Xcelerator client but Excel 2013 is not. You might consider using Excel 2010 (instead of or alongside) or using loose files</li>
<li>Also remember Excel 64 bit is not supported</li>
<li>If you want any changes to show in your workflow after updating the subset then you will need to go into Performance modeler and re-save the security rights</li>
<li>Check your Office Fix Packs and apply if needed</li>
<li>Your old web.config now changes to be tm1web_config.xml found in<br />
C:\Program Files\IBM\Cognos Express\webapps\tm1web\WEB-INF\configuration\tm1web_config.xml<br />
I changed the following values to be true to ensure websheets worked as per 10.1<br />
<add key="RecalcOnDataValidationChange" value="true"/> <br />
<add key="RecalcOnPicklistChange" value="true"/><br /><a href="http://www-01.ibm.com/support/docview.wss?uid=swg21653590">http://www-01.ibm.com/support/docview.wss?uid=swg21653590</a></li>
</ul>
</div>
</div>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-65584794615237992782014-03-31T20:31:00.001+10:302014-03-31T20:31:57.172+10:30Power Saving and TM1 PerformanceI was given this tip recently by a friend from Applix days.<br />
<br />
If you are on Windows 2008 R2 then go into your Power Options via Control Panel and make sure the setting is "High Performance".<br />
<br />
Do NOT select "Balanced".<br />
<br />
It appears as if the processor scales down 50% when in balanced mode.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/--wPTkDwXRp0/Uzk86OPiezI/AAAAAAAAWgQ/Vf2sV4Znyck/s1600/Snap+2014-03-31+at+20.20.20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/--wPTkDwXRp0/Uzk86OPiezI/AAAAAAAAWgQ/Vf2sV4Znyck/s1600/Snap+2014-03-31+at+20.20.20.png" height="129" width="320" /></a></div>
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-344413931442713202014-03-25T22:06:00.004+10:302014-03-25T22:06:52.667+10:30TM1 and JMeterIf you dont have LoadRunner available to you, yet you want to stress test your TM1 Application then its worth having a look at Apache JMeter.<br />
JMeter you can download for free and then follow the instructions on IBM DeveloperWorks here:<br />
<br />
<a href="http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page675/ba-pp-infrastructure-cognos_specific-page675-pdf.pdf">http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page675/ba-pp-infrastructure-cognos_specific-page675-pdf.pdf</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-90766384315027050382014-03-02T13:22:00.000+10:302014-03-02T13:22:02.267+10:30Cognos TM1 10.2 Multi-threaded Query calculation fixThere looks to be an issue with MTQ in 10.2.<br />
Looks like its best to ensure FP1 is applied then add MTQ.SingleCellConsolidation=false to your cfg<br />
<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg21664467&myns=swgimgmt&mynp=OCSS9RXT&mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg21664467&myns=swgimgmt&mynp=OCSS9RXT&mync=E</a>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-34223952510791194492014-02-27T14:48:00.000+10:302014-02-27T14:48:00.247+10:30Webinar with QuebitI will be hosting a webinar with <a href="http://quebit.com/" target="_blank">Quebit </a>around their <a href="http://www.quebit.com/business-analytics/frameworq/reportworq/" target="_blank">ReportWorq </a>solution for bursting TM1 excel based reports via email and sharepoint.<br />
<br />
If interested you can register here: <a href="http://www.tridant.com.au/broadentm1capabilities/">http://www.tridant.com.au/broadentm1capabilities/</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-68605242288722609962014-01-28T13:05:00.001+10:302014-01-28T13:05:14.433+10:30CDM - Advanced Scripting with Query VariablesWhen setting up data queries within CDM you have the full power of MDX available to you.<br />
You can then create the right syntax to return any element within TM1.<br />
As an example lets assume we have a Scenario dimension in TM1 and we take a static snapshot of the Budget every year e.g. Budget2014. We now in CDM want our queries to be dynamic and we have setup a query variable YYYY which is currently set to 2014.<br />
When creating my queries i can use the Advanced Scripting option and then use the following syntax<br />
<br />
<span style="color: red;">[Scenario].[Budget{YYYY}]</span><br />
<br />
This should resolve to:<br />
<br />
<span style="color: red;">Budget2014</span><br />
<div>
<br /></div>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-21596447511853963102014-01-27T20:38:00.003+10:302014-01-27T20:38:53.651+10:30No Servers displaying in TM1Web in TM1 10.2 FP1<br />
If you are applying 10.2 FP1 then make sure you read the following article:<br />
<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg24036618">http://www-01.ibm.com/support/docview.wss?uid=swg24036618</a><br />
<br />
Especially these bits:<br />
<br />
<span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;">a. Delete the config.ini file which can be found <TM1 install>\tomcat\work\Catalina\localhost\pmhub\eclipse\configuration.</span><br style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;" /><span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;">This is required when using TM1 Operations Console, Cognos Analysis for Microsoft Excel® or Cognos TM1 Mobile Contributor.</span><br style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;" /><span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;">b. Open Cognos Configuration.</span><br style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;" /><span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;">c. When you first open Cognos Configuration after applying FP1 a message displays that the configuration files have been upgraded. Click OK to continue.</span><br />
<span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;"><br /></span>
<span style="color: #333333; font-family: Arial, sans-serif; font-size: x-small;"><span style="line-height: 15.360000610351563px;">Otherwise</span></span><span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 15.360000610351563px;"> you will end up with tm1web displaying no servers</span>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-9246122333876007202014-01-09T10:45:00.002+10:302014-01-09T10:45:48.885+10:30Deprecated and discontinued functionality in IBM Cognos TM1Its worth being aware of this <a href="http://www-01.ibm.com/support/docview.wss?uid=swg21661245" target="_blank">link</a><br />
The two bigs ones that people should be aware of as they plan there upgrade are:<br />
<br />
<ul>
<li>The Advanced Rule Editor no longer being supported in 10.2. This is a trend you will continue to see of a movement towards performance modeller for creation and maintenance. </li>
<li>10.2 being the last release to support CQM. If your BI reports on TM1 are not using DQM then you need to start converting them</li>
</ul>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-4011420551669276272014-01-09T10:42:00.000+10:302014-01-09T10:42:10.425+10:30TM1 10.2 FP1As an early christmas present there was a release of TM1 10.2 FP1 on Dec 24th.<br />
For more information see this <a href="https://tridant.zendesk.com/entries/36773857-IBM-Cognos-TM1-10-2-0-Fix-Pack-1-now-available" target="_blank">link</a>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-69365932420948430952014-01-08T14:23:00.000+10:302014-01-08T14:23:13.531+10:30TM1Web 10.2 url apiWorth noting that if you are looking to upgrade to TM1 10.2 and you use the tm1web url api then the syntax has chnaged. See here:<br />
<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg27039576">http://www-01.ibm.com/support/docview.wss?uid=swg27039576</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-10077972700413206462013-11-13T21:21:00.000+10:302013-11-13T21:21:01.198+10:30TM1 and CAM FailoverIf you are using TM1 with CAM security and you have Cognos setup with multiple gateway dispatchers then I would recommend checking out this post on the IBM website:<br />
<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg21645974&myns=swgimgmt&mynp=OCSS9RXT&mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg21645974&myns=swgimgmt&mynp=OCSS9RXT&mync=E</a><br />
<br />
<br />
You may set multiple ServerCAMURI as follow in tm1s.cfg<br />
<br />
ServerCAMURI=http://server1:9300/p2pd/servlet/dispatch<br />
ServerCAMURI=http://server2:9300/p2pd/servlet/dispatch<br />
ServerCAMURI=http://server3:9300/p2pd/servlet/dispatch<br />
ServerCAMURIRetryAttempts=5<br />
<br />
Remarks:<br />
<br />
ServerCAMURIRetryAttempts specify the retry count for access each dispatcher<br />
<div>
<br /></div>
James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-7387666941312982972013-11-12T10:40:00.003+10:302013-11-12T10:40:22.108+10:30Powershell with TM1Server.logThe tm1server.log is not the easiest thing to extract information from but contains golden nuggets of information.<br />
<br />
Ideally you want to timestamp the tm1server.log after any restarts and then you can analyze a clean single session of information.<br />
<br />
One of the easiest things you can do is use Windows powershell to then extract just the messages you want.<br />
<br />
e.g. if i just want to explore the cube dependencies the server is producing then I just the following line within powershell<br />
<br />
Get-Content .\tm1server.log | Where-Object {$_ -match 'TM1.Cube.Dependency'} | Set-Content tm1server.log-out.txt<br />
<br />
You can alter the above statement to do any filtering you need<br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-43439252813669283822013-11-08T20:10:00.002+10:302013-11-08T20:10:31.621+10:30TM1 CafeGreat overview of TM1 Cafe in 10.2 from Quebit:<br />
<br />
<a href="https://www.youtube.com/watch?v=4abO-5snYWI">https://www.youtube.com/watch?v=4abO-5snYWI</a>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-41136818917759405142013-11-08T09:10:00.002+10:302013-11-08T09:10:39.704+10:30IBM TM1 Watchdog Some explanations around how to setup and use watchdog in TM1 10.2<br />
<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg21654154&myns=swgimgmt&mynp=OCSS9RXT&mync=R">http://www-01.ibm.com/support/docview.wss?uid=swg21654154&myns=swgimgmt&mynp=OCSS9RXT&mync=R</a>James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-22425269610857781562013-11-06T23:05:00.000+10:302013-11-06T23:05:04.551+10:30 New Releases and Product Notifications for November 2013It was interesting to see this month the notice of withdrawal from IBM on Executive Viewer and FSR:<br />
<br />
<a href="https://www-304.ibm.com/connections/blogs/basupportlink/entry/new_releases_and_product_notifications_for_november_2013?lang=en_us">https://www-304.ibm.com/connections/blogs/basupportlink/entry/new_releases_and_product_notifications_for_november_2013?lang=en_us</a><br />
<br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-15261213911913833052013-11-06T22:50:00.001+10:302013-11-06T22:50:39.266+10:30Top 20 Developments in IBM TM1 in recent yearsJust realised a presentation that Andrew Stephens and myself did for an IBM Cognos User Group is available for download from the IBM website.<br />
<br />
In what will always be a controversial list we called out at the time the Rule function Continue as being a real game changer for TM1 developers.<br />
<br />
Those who have been doing TM1 for 10+ years since the days of TM1 714SR2 will remember when there was no Continue function and constant nested Ifs made for ugly looking rule files.<br />
<br />
Check it out here:<br />
<br />
<a href="http://public.dhe.ibm.com/software/au/downloads/Top_20_Developments_in_IBM_TM1_in_recent_years.pdf">http://public.dhe.ibm.com/software/au/downloads/Top_20_Developments_in_IBM_TM1_in_recent_years.pdf</a><br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.comtag:blogger.com,1999:blog-17509860.post-48746190147106305892013-11-04T10:25:00.002+10:302013-11-04T10:25:30.507+10:30TM1 CFG File - ViewConsolidationOptimizationMethodI see a lot of client's cfg file and its amazing how many of them are out of date or contain the wrong settings for the version of TM1 they are on.<br />
One of the parameters that I always suggest adding in is ViewConsolidationOptimizationMethod=TREE<br />
The reason why is because of the documentation you can find here: <a href="http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc%2Fc_viewconsolidation_optimizationmethod_1.html&path%3D0_1_21_2_93">http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc%2Fc_viewconsolidation_optimizationmethod_1.html&path%3D0_1_21_2_93</a><br />
<br />
Specifically its says "This setting provides the best performance in normal operations"<br />
<br />James Wakefieldhttp://www.blogger.com/profile/15099781681955344565noreply@blogger.com