Cognos 8 Controllerhttps://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0The latest updates about Cognos 8 Controlleren-USCopyright 2007 IBM Corporation. All rights reservedcssadmin@us.ibm.com (CSN Administrator)Wed, 02 Dec 2009 10:02:57 GMTThu, 03 Dec 2009 02:39:12 GMThttp://www.ibm.com/i/ibm_logo_120x60.gifCognos 8 Controllerhttps://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0Error 'There are no CAM Users available in the popup list' when mapping Controller users with Cognos 8 users, when using a slow namespace (such as NTLM)http://www.ibm.com/support/docview.wss?uid=swg21412954&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser clicks 'Maintain - Rights - Users'. User highlights a user (for example 'John Smith'), and then clicks on the CAM User '...' button under the menu 'Settings - User'. There is a long delay (approximately 2 minutes), during which the message "Retrieving user ID:s from the IBM Cognos 8 server..." appears at the bottom-left corner. At the end of this delay, an error message appears.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21412954Wed, 02 Dec 2009 10:02:57 GMTLong time (5 minutes or even longer) taken to add a user from NTLM namespace to Cognos namespace role/group in Cognos connectionhttp://www.ibm.com/support/docview.wss?uid=swg21412828&myns=swgimgmt&mynp=OCSS9S6B&mynp=OCSS9RTN&mync=RAdministrator launches Cognos Connection (http://servername/cognos). User clicks 'Administer IBM Cognos conent'. User clicks 'Security' tab. User clicks 'Cognos' namespace. User clicks the 'properties' button next to a group (for example 'Controller Users'). User clicks 'Members' tab. This takes a long time to launch (perhaps 2 minutes, if have 150 or so users in the list). Eventually the list of users appears. User tries to add extra user(s) to this role/group. This operation may take 5 minutes or so to ocProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21412828Wed, 02 Dec 2009 09:59:34 GMTHow to use the Batch Queue functionality to import external data from flat fileshttp://www.ibm.com/support/docview.wss?uid=swg21413280&myns=swgimgmt&mynp=OCSS9S6B&mync=RHow to use the Batch Queue functionality to import external data from flat files.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21413280Tue, 01 Dec 2009 12:37:02 GMTUpdate the Java Runtime Environment for IBM Cognos 8 Controller Financial Analytics Publisherhttp://www.ibm.com/support/docview.wss?uid=swg21413094&myns=swgimgmt&mynp=OCSS9S6B&mync=RYou need to update the Java Runtime Environment for IBM Cognos 8 Controller Financial Analytics Publisher according to the following instructions.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21413094Tue, 01 Dec 2009 07:09:15 GMTUnexpected Opening balance differences in journal 35 after moving to new Consolidation Engine.http://www.ibm.com/support/docview.wss?uid=swg21413016&myns=swgimgmt&mynp=OCSS9S6B&mync=RSome cashflow accounts have "an extra opening balance" which causes differences in IC elimination automatic journals when compared with old engine.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21413016Mon, 30 Nov 2009 12:26:08 GMTCannot select/change 'Currency Type' inside menu 'Data Entry - Reported Values', when opened via the icon 'ControllerDeLayout' inside the Excel link, causing unexpected blank cells inside formshttp://www.ibm.com/support/docview.wss?uid=swg21409802&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser launches Controller. User clicks 'Company' - 'Data Entry - Reported Values'. User fills in the details (for example Actuality, Period, Company, Currency Type, Submission, Form) and clicks 'open'. Excel launches, and the form successfully appears with all values successfully displayed in the cells. Whilst still inside Excel, user clicks the Excel menu 'Add-Ins'. User then clicks on the icon 'ControllerDeLayout' (which looks like a pair of binoculars, inside the Excel link menu bar). [Alternatively, theProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409802Tue, 24 Nov 2009 09:16:02 GMTError "-2147217908:Command text was not set for the command object" when running reportshttp://www.ibm.com/support/docview.wss?uid=swg21412374&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser clicks 'Reports - Ad Hoc'. The menu 'Ad Hoc Reports' opens. User makes selections, and then clicks 'preview' button. The message 'Preparing Report' appears at the lower-left corner. An error message appears. User also gets a similar message when running a 'Verify company structure' report.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21412374Tue, 24 Nov 2009 05:06:39 GMTPrint Trial Balance with drilldown on a single page.http://www.ibm.com/support/docview.wss?uid=swg21411624&myns=swgimgmt&mynp=OCSS9S6B&mync=RWhen extracting TB with drilldown there are high numbers of pages to be printed.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411624Thu, 19 Nov 2009 12:24:00 GMTProlonged timeout when logon screen to controller.http://www.ibm.com/support/docview.wss?uid=swg21411615&myns=swgimgmt&mynp=OCSS9S6B&mync=RTimeout is too short when logon to security in controller.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411615Thu, 19 Nov 2009 11:03:00 GMTGenerating Company Journals in Excel locks up workstation when Showcase add-in is installed and enabled.http://www.ibm.com/support/docview.wss?uid=swg21411493&myns=swgimgmt&mynp=OCSS9S6B&mync=RCompany menu --> Reports --> Company Journals --> Generate --> "Select Format" to XLS and workstation locks up. CTR - ALT - DEL to end Program ControllerProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411493Thu, 19 Nov 2009 10:07:00 GMTDrilldown of accounts cannot handle double summations of cross owned accountshttp://www.ibm.com/support/docview.wss?uid=swg21411497&myns=swgimgmt&mynp=OCSS9S6B&mync=RIf accounts are summoned to more than one base account there is a situation where you get incorrect values.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411497Thu, 19 Nov 2009 10:02:00 GMTAbility to validate data of imported journals with using dimensionhttp://www.ibm.com/support/docview.wss?uid=swg21411440&myns=swgimgmt&mynp=OCSS9S6B&mync=RValidating imported journals with dimensions.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411440Wed, 18 Nov 2009 16:07:00 GMTRestriction in Security Groups Companies is also applied to rights to edit lookup table that refer to counter company.http://www.ibm.com/support/docview.wss?uid=swg21411436&myns=swgimgmt&mynp=OCSS9S6B&mync=RRestriction in Security Group applies on right to edit lookup table to counter company.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411436Wed, 18 Nov 2009 16:06:00 GMTPossibility to use incremental data uploadshttp://www.ibm.com/support/docview.wss?uid=swg21411293&myns=swgimgmt&mynp=OCSS9S6B&mync=RInstead of data being overwritten when uploaded the aim is to add the record to the data that is already stored in the databaseProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411293Wed, 18 Nov 2009 16:05:00 GMTNo monthly values displayed in MTD form – YTD value.http://www.ibm.com/support/docview.wss?uid=swg21411088&myns=swgimgmt&mynp=OCSS9S6B&mync=RWhen users make data entry and leave out a field, values are displayed negative.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411088Wed, 18 Nov 2009 16:04:00 GMTExcluding the use of an account when data entry changing percentage, vote and number of shares in shareholdings and investment.http://www.ibm.com/support/docview.wss?uid=swg21409957&myns=swgimgmt&mynp=OCSS9S6B&mync=RWhen you making a data entry in shareholdings and investment to change vote, percentage or number of shares excluding the account as there is not a booked amount involved. Only to display the difference this wont be part of the report in shareholdings and investment.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409957Wed, 18 Nov 2009 16:03:00 GMTError "The model or package /content/package[@name='Controller']/model[last()] does not exist ..." when running Standard Reports, caused by security settingshttp://www.ibm.com/support/docview.wss?uid=swg21411308&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser runs a standard report (also known as a 'system report'). User receives an error message.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411308Wed, 18 Nov 2009 05:10:09 GMTMultiple versions of Excel on one Controller client computer - not supportedhttp://www.ibm.com/support/docview.wss?uid=swg21411269&myns=swgimgmt&mynp=OCSS9S6B&mync=RCustomer wants to have 2 versions of Excel on one computer, e.g. Excel 2003 and Excel 2007. He gets a message such as "The Excel Link is not Installed" or the the link fails to work with other symptoms.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21411269Tue, 17 Nov 2009 07:11:46 GMTController 8.5 supported platforms.http://www.ibm.com/support/docview.wss?uid=swg21411070&myns=swgimgmt&mynp=OCSS9S6B&mync=RWill Controller 8.5 be supported for Windows Server 2008 and Microsoft SQL 2008?Problem solving informationTechnotes(FAQs)swgimgmt.swg21411070Mon, 16 Nov 2009 06:51:30 GMTDifferences greater than accepted amount not selectable in Reconcile btw accts/ob'shttp://www.ibm.com/support/docview.wss?uid=swg21410904&myns=swgimgmt&mynp=OCSS9S6B&mync=RHow do I make the option 'differences greater than accepted amount' available in when running a reconciliation between accounts/opening balances?Problem solving informationTechnotes(FAQs)swgimgmt.swg21410904Fri, 13 Nov 2009 08:40:28 GMTError 'The source could not be found, but some or all event logs could not be searched. Inaccessible Logs : Security' when click on Excel icon inside Controllerhttp://www.ibm.com/support/docview.wss?uid=swg21409986&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser launches Controller. User clicks the 'Excel' shortcut icon on the Controller menu bar. User receives error message.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409986Tue, 10 Nov 2009 03:51:58 GMTWhere is the information for the function 'Track Data' stored?http://www.ibm.com/support/docview.wss?uid=swg21410144&myns=swgimgmt&mynp=OCSS9S6B&mync=RCustomer would like to know where the 'External Data Tracking' data is stored, because the would like to see how much space it takes up.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21410144Mon, 09 Nov 2009 04:49:06 GMTExiting from Excel after data entry causes a hang, related to the Default Printerhttp://www.ibm.com/support/docview.wss?uid=swg21409970&myns=swgimgmt&mynp=OCSS9S6B&mync=RData Entry > Reported Values. On saving a data change then closing the Excel sheet in 2 steps, first Fille > Close in Excel to close the sheet but not Excel, then 2nd File Close to close completely, Excel is left hanging. If Excel process is killed the User is left logged in.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409970Fri, 06 Nov 2009 09:23:33 GMTUser cannot change value for 'Currency Type' when using 'Data Entry - Reported Values'http://www.ibm.com/support/docview.wss?uid=swg21409799&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser clicks 'Company' - 'Data Entry - Reported Values'. User tries to change the value for 'Currency Type' from its current value (LC). However, the 'pop up' menu does not appear, so they cannot change the value.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409799Thu, 05 Nov 2009 09:12:23 GMTOption 'Rebuild Indexes' greyed out when using 'Maintain - Database 'Optimize Database' unless logged on as some (non-ADM) usershttp://www.ibm.com/support/docview.wss?uid=swg21408301&myns=swgimgmt&mynp=OCSS9S6B&mync=RUser logs onto Controller, and clicks 'Maintain - User - Single Mode'. User clicks 'Maintain - Database 'Optimize'. The option 'Rebuild Indexes' is unselectable (greyed out).Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21408301Thu, 05 Nov 2009 06:17:33 GMTTerms of Usehttp://www.ibm.com/legal/us/Terms of UseTerms and conditionshttp://www.ibm.com/legal/us/