Search found 103 matches

by chewza
Wed Dec 09, 2020 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SUBNM - #N/A in Workbook
Replies: 1
Views: 246

SUBNM - #N/A in Workbook

Hi there Have a bit of a strange situation with a SUBNM in my slicer. It resolves to "#N/A", but if I hit F2 and enter in my Cell, it resolves properly. The workbook formula I have is: =SUBNM("payroll:Month";"Default";"Unspecified Month";"Description") Always have to hit F2 and enter to get it so sh...
by chewza
Thu Nov 19, 2020 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax Exploration - Automatic Commit
Replies: 1
Views: 310

Pax Exploration - Automatic Commit

Hi Guys I am having an issue with Pax explorations. I want it to auto-commit, and following the steps on how to do this doesn't seem to work. In options, the "Hide commit confirmation" is ticked, and in the CognosOfficeReportingSettings that "CommitWithoutConfirmation" setting is set to true. Any id...
by chewza
Mon Oct 12, 2020 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Issue - Element Name from Alias
Replies: 1
Views: 558

Rule Issue - Element Name from Alias

Hi there I am trying to get the element name from an alias. The rule is in the attribute cube for my Calendar dimension: ['Next'] = s: DimNm('Calendar', DimIx(DB('}ElementAttributes_Calendar',!Calendar,'IdxNext')) ); I get an error of "unexpected parenthases" The dimension has an Idx Alias, and the ...
by chewza
Mon Aug 03, 2020 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - Docker - Installing to C Drive
Replies: 1
Views: 405

PAW - Docker - Installing to C Drive

Hi Guys I am installing Paw for the first time. I reached the point in the installation where it asked if I wanted to switch storage to another drive. I selected "y" , read the web article, and then added "data-root": "d:\\docker" to the config file. I then reran the start.psq1 => it continued strai...
by chewza
Mon Jul 27, 2020 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandbox Reset - Possible?
Replies: 1
Views: 386

Sandbox Reset - Possible?

Hi there

Is there any way to rest a sandbox to the base or do you have to delete and recreate?

Regards
Chris
by chewza
Mon Jul 27, 2020 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidator Rule - Issue With Sandbox
Replies: 1
Views: 394

Consolidator Rule - Issue With Sandbox

Hi Guys I am using the following consolidator rule for the "All Months" Element: ['Cashflow', 'Closing Balance', 'Amount', 'All Months'] = c:['December']; It works perfectly, but with sandboxes it does not seem to "activate" In a sandbox, it adds up the closing balance of all months rather than usin...
by chewza
Mon Jul 27, 2020 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Commit
Replies: 5
Views: 866

Pax - Commit

Hi there

In perspectives, numbers were always committed automatically. In Pax, it seems like you have to click on the Commit icon.
Is there a way to avoit this and have data commit automatically as soon as you hit you enter key?

Many thanks!!

Regards
Chris
by chewza
Thu Jul 16, 2020 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Reports ver 2.0.9 - data misaligned
Replies: 3
Views: 867

Re: Active Reports ver 2.0.9 - data misaligned

applied the fix pack and worked fine.
Thx a million for your help!
This is a rather fundamental issue - pretty surprised to find it.
by chewza
Thu Jul 16, 2020 7:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text Extracts Decimal Issue
Replies: 0
Views: 1107

Text Extracts Decimal Issue

Hi Guys Really hoping you can help here. Am busy with Tm1 upgrade and have hit a big snag with text file extracts. The upgrade involves new servers (moving from Windows 2008 to Windows 2016) and the latest version of Tm1 (tm1_winx64h_2.0.91.41_ml(1).tar.gz – which is fixpack released end April). So ...
by chewza
Mon Jul 13, 2020 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Reports ver 2.0.9 - data misaligned
Replies: 3
Views: 867

Re: Active Reports ver 2.0.9 - data misaligned

Hi Mark

Thx for your feedback. There is a fixpack which seems to address this issue. Will give it a bash and revert.

Many thx
Chris
by chewza
Mon Jul 13, 2020 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Reports ver 2.0.9 - data misaligned
Replies: 3
Views: 867

Active Reports ver 2.0.9 - data misaligned

Hi there We are upgrading to 2.0.9 and many active reports do not seem to be working. The first row returns data, but then the subsequent rows seem to be "mis-aligned". So for example if the Columns are Division, Account, Cost Centre: Row 1 returns Division1, Account1, Cost Centre1. But then the oth...
by chewza
Tue May 26, 2020 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Expand Above
Replies: 1
Views: 440

Pax - Expand Above

Hi Guys

Silly Question - how do you set subset to expand above when you click on it?

Many thanks!!

Regards
Chris
by chewza
Wed May 20, 2020 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1Web - Active Form not rendering
Replies: 2
Views: 920

Tm1Web - Active Form not rendering

Hi Guys

I have some Active Forms which work fine in Perspectives. In Tm1 Web no returns, despite hitting rebuild sheet/book.
We are running Version 11.4.0.21

Any ideas?

Much appreciated!!

Regards
Chris
by chewza
Mon May 18, 2020 8:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 2884

Re: Memory Usage Issues - StatsByCube

Hi Thanks very much for all the advice. In summary, the garbage accounts for more than half the memory. I disabled multi-threaded startup, and the memory usage almost halved. We have 12 virtual cores and all were previously allocated for startup. I played around, and found the 6 is a workable number...
by chewza
Wed May 13, 2020 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PreallocatedMemory.Size and Model Startup
Replies: 1
Views: 625

PreallocatedMemory.Size and Model Startup

Hi there Anyone know exactly what this does? So if I set it to 75000 will to ensure that Tm1 only uses 75GB of Ram. I have set it to this, but as my model starts up, I see that the RAM is hovering around 95%. There are the config parameters I have used: MTCubeLoad=T MTQ=All MTCubeLoad.UseBookmarkFil...
by chewza
Wed May 13, 2020 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 2884

Re: Memory Usage Issues - StatsByCube

Hi Guys

Really appreciate the responses!! Will follow your advice, and revert.

Regards
Chris
by chewza
Wed May 13, 2020 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 2884

Re: Memory Usage Issues - StatsByCube

Hi Steve Actually this does look like a problem - just read that you are supposed to ADD TOGETHER the "Memory Used" and the "Memory in Garbage". So adding this together will give me around 135GB, but the OS only has 86GB in total, and the windows processes says that Tm1 is consuming 78GB. Also the s...
by chewza
Wed May 13, 2020 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 2884

Re: Memory Usage Issues - StatsByCube

Hi Steve Thanks very much for your assistance. I have looked at the StatsForServer cube, and it tells me the following: Memory Used = 85GB Memory in Garbage = 49GB Server Stats: RAM = 84GB Tm1 Process Usage = 78GB So questions I have: Are the above stats an issue? From what I gather, although RAM is...
by chewza
Wed May 13, 2020 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 2884

Memory Usage Issues - StatsByCube

Hi there Our RAM is sitting at 98%, and causing big issues with the model. The StatsByCube cube shows that Tm1 is consuming 32GB, but windows task manager shows it sitting at 78GB Why is would this be the case? Also, we previously had the the same issue where RAM was at 98%. We added an extra 16GB o...