Search found 31 matches
- Wed Aug 26, 2020 7:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to clean up TM1 | server_name | Security | Client/Groups
- Replies: 2
- Views: 1943
Re: How to clean up TM1 | server_name | Security | Client/Groups
Hi, we have IntegratedSecurityMode=4 which means users and groups are imported from Cognos BI server and TM1 does not have its own users/groups. I have solved the problem by: 1. Open TM1 Architect. 2. From TM1 tree, right click on <my_server> and select Security | Client/Groups. 3. For each of the u...
- Mon Aug 10, 2020 6:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to clean up TM1 | server_name | Security | Client/Groups
- Replies: 2
- Views: 1943
How to clean up TM1 | server_name | Security | Client/Groups
Hi, in our company we are using Cognos TM1 10.2.2. Security users and user groups are integrated into Cognos BI. TM1 server does not have its own users/groups, it gets users/groups from Cognos BI. Then Cognos BI users and user groups are integrated into using LDAP users and groups. When I add new us...
- Tue Apr 11, 2017 7:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to solve SystemOutOfMemory errors when running reports?
- Replies: 7
- Views: 6944
Re: How to solve SystemOutOfMemory errors when running reports?
Duncan, I am using Cognos 10.2.1 64-bit fixpack 12, so this should not be a problem. According to the APAR it should be fixed in fixpack 4.
I am also not getting the same error message. My error message is as posted in my first post in this thread.
I am also not getting the same error message. My error message is as posted in my first post in this thread.
- Tue Apr 11, 2017 4:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to solve SystemOutOfMemory errors when running reports?
- Replies: 7
- Views: 6944
Re: How to solve SystemOutOfMemory errors when running reports?
Jim, no we don't understand each other. After installing TM1 10.2.2 I notice some of the warnings in log file and so set MaximumViewSize=2048. I was just letting you to know that this setting is not set as default 500 as it was in TM1 10.1.1. I still haven't fixed "SystemOutOfMemory" probl...
- Mon Apr 10, 2017 5:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to solve SystemOutOfMemory errors when running reports?
- Replies: 7
- Views: 6944
Re: How to solve SystemOutOfMemory errors when running reports?
@Jim, in tm1 v10.1.1 I didn't use any special parameters, but now after migration in tm1 10.2.2 I noticed some warnings in log file and searched the web and suggested solution was to increase the MaximumViewSize parameter, I did and warnings were gone. I set parameter value to: MaximumViewSize=2048
- Fri Apr 07, 2017 8:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to solve SystemOutOfMemory errors when running reports?
- Replies: 7
- Views: 6944
How to solve SystemOutOfMemory errors when running reports?
Hi, we are executing reports using Cognos BI 10.2.1 against TM1 server. We have migrated TM1 from version 10.1.1 64-bit Fixpack 2 to version 10.2.2 64-bit Fixpack 6. What we are now seeing as a problem in new TM1 server (previous TM1 server working fine) is some of the reports returning error (cubes...
- Tue Dec 13, 2016 2:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get info from tm1server.log for which cube indivitual info is related to?
- Replies: 1
- Views: 2375
How to get info from tm1server.log for which cube indivitual info is related to?
Hi, in Cognos TM1 10.2.2 fixpack 6 I would like to monitor if Stargate views are created or not for my cube. In tm1s-log.properties in my tm1 server I added: log4j.logger.TM1.Cube.Stargate=DEBUG log4j.logger.TM1.Cube.Stargate.Reference=INFO log4j.logger.TM1.Cube.Invalidation=DEBUG Now I see somethin...
- Wed Nov 04, 2015 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What is the URL for Cognos Analysis for Microsoft Excel to access TM1 server?
- Replies: 1
- Views: 3715
What is the URL for Cognos Analysis for Microsoft Excel to access TM1 server?
Hi, on my Windows 7 I have installed "Cognos Analysis for Microsoft Excel v10.2.2" and also installed fixpack 5 for this product. I started Microsoft Excel 2013 and I can see "IBM Cognos" tab. Clicking on Options button I can configure URL for "IBM Cognos BI" server and...
- Tue Nov 03, 2015 1:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What are the TM1 various tools to insert data into cube?
- Replies: 0
- Views: 1639
What are the TM1 various tools to insert data into cube?
Hi, we are currently using Cognos TM1 v10.1.1 Fixpack 2 64-bit on Windows 2008 R2 and creating cubes with TM1 Architect. Up till now we have been using TM1 for reporting only. So we have been accessing TM1 Server with Cognos Business Intelligence v10.2.1 Fixpack 6. But now we have a requirement that...
- Fri Oct 30, 2015 7:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: [SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?
- Replies: 3
- Views: 2916
Re: What is TurboIntegrator function to assign Measure Dimension cube property to cube?
In Epilog of create cube TI process I added code: CellPutS('Dimension_name', '}CubeProperties', 'Cube_name', 'MEASURES_DIMENSION'); Where: 'Dimension_name' is measure dimension name and 'Cube_name' is cube name. Thanks for help. Problem solved. P.S.It totally flip my mind that TM1 settings are also ...
- Fri Oct 30, 2015 6:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: [SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?
- Replies: 3
- Views: 2916
[SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?
Hi, using Cognos 10.1.1. Every time I create a cube from TurboIntegrator I manually right click on cube and select Properties option, then I select a dimension for "Measure Dimension" setting. I have to assign measure dimension because of Cognos BI requirement. My idea is to just add some ...
- Tue Oct 20, 2015 9:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
- Replies: 5
- Views: 6688
Re: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
I did additional test with DB2 UTF-8 defined database storing data in varchar data type (data stored in UTF-8) and using vargraphic (data stored in UCS-2 code page). I am still wondering what is the Unicode code page used by TM1 internally? Is it UTF-8 or something else like UTF-16 or something else...
- Tue Oct 20, 2015 8:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
- Replies: 5
- Views: 6688
Re: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
@Wim Gielis, thanks for help. According to TM1 Reference Guidle documentation: For formats lacking a valid byte-order-mark, the characters must be converted from some other encoding to UTF-8. The SetInputCharacterSet function lets you specify the character set used in a TurboIntegrator data source. ...
- Tue Oct 20, 2015 7:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
- Replies: 5
- Views: 6688
Re: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
Thank you for answer. One additional related question: How to specify in TM1 Architect that source text file is encoded in UTF-8 code page? I created simple text file with cyrillic letter and from sample it is clear that source file is recognized as Windows-1250 code page (default Windows server set...
- Fri Oct 16, 2015 1:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
- Replies: 5
- Views: 6688
What does "Use Unicode" checkbox means in TM1 Architect Turbo Integrator?
Hi, using Cognos TM1 10.1.1 fixpack 2 64-bit. 1. In TM1 Architect right click on Processes and select Create new Process. 2. Turbo Integrator dialog opens. Click on ODBC. 3. There is "Use Unicode" checkbox. What does this checkbox means? a) Source data from ODBC data source are in Unicode?...
- Fri Aug 14, 2015 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What is the TM1 element member name maximum size limitation?
- Replies: 5
- Views: 6440
What is the TM1 element member name maximum size limitation?
Hi, in Cognos TM1 10.1.1 (TM1 Architect development tool) I have the following problem (simplified): I have a one single contract in purchases system that can be fulfilled (goods delivered) by multiple suppliers. I know this doesn't sound correct but it is. Out company makes contract with enterprise...
- Tue Jun 02, 2015 12:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 used for reporting. Simple sparse cube report never ends
- Replies: 11
- Views: 9367
Re: TM1 used for reporting. Simple sparse cube report never
You can change this behaviour, but it requires a bit of work (keyword: IsUnderFed). Hi, Excellent. That's it!!! I have got one problem with one of my cube having complex rules and I just though it was a bug, so reported a PMR at IBM and got reply if you have some problems with Cognos BI and feeders...
- Thu May 21, 2015 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 used for reporting. Simple sparse cube report never ends
- Replies: 11
- Views: 9367
Re: TM1 used for reporting. Simple sparse cube report never
Instead, you should have a drill through to your data warehouse defined so that users running reports can get those invoice and order details when they need to. I was already thinking on reducing the size of cube removing order/invoice from it, but I have to get this info back somehow, drill-throug...
- Thu May 21, 2015 11:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 used for reporting. Simple sparse cube report never ends
- Replies: 11
- Views: 9367
Re: TM1 used for reporting. Simple sparse cube report never
First of all I see that your Buyer dim has 18 thousand elements in the data warehouse, but a whopping 1.1 million in TM1. Why the difference? Are you sure you're comparing things that can be compared? Anyway - a few quick questions that pop to mind are: Good spotted. There are the same data, but ma...
- Thu May 21, 2015 4:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fix Pack Releases: 10.2 Series
- Replies: 49
- Views: 300178
Re: Fix Pack Releases: 10.2
Cognos TM1 10.2.2 FP3 Interim Fix: http://www-01.ibm.com/support/docview.wss?uid=swg21903242&myns=swgimgmt&mynp=OCSS9RXT&mync=E&cm_sp=swgimgmt-_-OCSS9RXT-_-E Intended for users that have downloaded previously broken FP3, so downloaded FP3 before 2015-05-19. Cognos TM1 10.2.2 FP3 (alr...