Search found 31 matches

by Stanislav2
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: 1911

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...
by Stanislav2
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: 1911

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...
by Stanislav2
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: 6811

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.
by Stanislav2
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: 6811

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...
by Stanislav2
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: 6811

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
by Stanislav2
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: 6811

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...
by Stanislav2
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: 2323

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...
by Stanislav2
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: 3590

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...
by Stanislav2
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: 1605

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...
by Stanislav2
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: 2868

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 ...
by Stanislav2
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: 2868

[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 ...
by Stanislav2
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: 6593

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...
by Stanislav2
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: 6593

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. ...
by Stanislav2
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: 6593

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...
by Stanislav2
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: 6593

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?...
by Stanislav2
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: 6314

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...
by Stanislav2
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: 9265

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...
by Stanislav2
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: 9265

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...
by Stanislav2
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: 9265

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...
by Stanislav2
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: 291733

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...