Search found 29 matches

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: 2338

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: 2338

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" problem. Do you...
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: 2338

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: 2338

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: 811

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: 1301

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 I can without a problem get d...
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: 549

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: 788

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: 788

[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 TI functio...
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: 2556

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: 2556

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: 2556

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: 2556

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? b) Target...
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: 3
Views: 1811

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: 4418

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: 4418

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: 4418

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: 48
Views: 27983

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 (already includes ab...
by Stanislav2
Wed May 20, 2015 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 used for reporting. Simple sparse cube report never ends
Replies: 11
Views: 4418

TM1 used for reporting. Simple sparse cube report never ends

Hi, I have created quite simple report "Quantity sold" measure in Rows with "Buyer's Country" and "Product ID" in Columns. Report created in Cognos BI Report Studio accessing data from TM1 cube. Cube is quite sparse and result is for sure result of sparse data. The query in Report Studio is executin...
by Stanislav2
Tue May 19, 2015 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [SOLVED]Advanced Rules Editor in TM1 10.2.2 fp2 doesn't open
Replies: 10
Views: 5973

Re: Rules Editor in TM1 v10.2.2 fixpack 2 does not open

Also working from memory (so I could be wrong as my memory is terrible) I think that you no longer NEED to install the .NET Framework version that advanced rules editor needs as part of the Install of TM1; so you should check that you have the required version. On my computer .NET Framework 64-bit ...