Search found 1231 matches

by David Usherwood
Wed May 09, 2018 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 301

Re: stored values in tm1

I had an actuary client who didn't like the leftover rounding bits and bobs - so I just took the small change out of my pocket and offered 1 UK penny as full and final settlement for the discrepancy.
by David Usherwood
Sun May 06, 2018 11:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In pop up window - After successful login into Cognos BI redirect to c# application
Replies: 7
Views: 392

Re: In pop up window - After successful login into Cognos BI redirect to c# application

Surely you should just implement IBM's approach to using CAM authentication with TM1:
http://www-01.ibm.com/support/docview.w ... wg21958925
I find it pretty messy but it what the vendor documents and supports - and your approach seems even harder work.
by David Usherwood
Fri Apr 27, 2018 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of levels above an element
Replies: 4
Views: 182

Re: Number of levels above an element

TM1 supports the (rarely used) ASCENDANTS function which could help. Alternatively write a recursive TI - but remember that elements can have multiple parents.
by David Usherwood
Thu Apr 19, 2018 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 on GPU
Replies: 2
Views: 246

Re: TM1 on GPU

Has anyone tried running TM1 on GPU, with Linux OS?
I don't believe IBM support GPU execution - so I can't think how you would make that happen. It's been used by other OLAP products eg
https://knowledgebase.jedox.com/knowled ... rator-faq/
by David Usherwood
Tue Apr 17, 2018 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Scripting
Replies: 3
Views: 255

Re: TM1 Scripting

You can't.
If you don't want the code executed, either remove the mappings etc which generated the code, or wrap the code block as follows:

Code: Select all

if(1=0);
# generated code
....
# end generated code
endif;
by David Usherwood
Fri Apr 13, 2018 8:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 19
Views: 913

Re: Exporting data from view to file consuming memory

Re: Exporting data from view to file consuming memory Post by vladino » Thu Apr 12, 2018 3:17 pm David Usherwood wrote: ↑ Thu Apr 12, 2018 3:06 pm If memory is really constrained you could clear the cache periodically by changing a value somewhere and changing it back again What do you mean by clea...
by David Usherwood
Thu Apr 12, 2018 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 19
Views: 913

Re: Exporting data from view to file consuming memory

If memory is really constrained you could clear the cache periodically by changing a value somewhere and changing it back again. But I suspect your export view includes many more data points than you really need, especially consolidations. Depending (geddit?) on your dependences, the cellputn may be...
by David Usherwood
Mon Apr 09, 2018 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing TM1 objects: file format is too new
Replies: 2
Views: 342

Re: Missing TM1 objects: file format is too new

I just hit this moving a server between PA Local versions, specifically from 10.3.10200.60377 back to 10.3.10000.60286 . Only the new objects were kicked out. :evil:
by David Usherwood
Tue Mar 13, 2018 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 6301

Re: How to Use DBSW

I'm prepared to be corrected, but my belief is that if you wrap DBRWs or DBSWs in other functions, the performance benefit from using Stargate Views(via VIEW()) does not apply.
by David Usherwood
Mon Mar 12, 2018 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 6301

Re: How to Use DBSW

I agree that DBSW still has a part to play - but with your testing logic I don't believe you will get the Stargate VIEW() performance win. Given that you don't want any data to go unless your complicated tests are passed, I think you would be better off changing your cubename cell ($C$4) to be a for...
by David Usherwood
Thu Mar 01, 2018 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 574

Re: Server Crash Due To Page File

Turn on Performance Monitor and study }StatsbyCube and }StatsforServer - that should tell you what's eating memory (and thus your pagefile).
by David Usherwood
Fri Feb 23, 2018 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 10
Views: 828

Re: TM1 Chore Schedule Information

Marius Wirtz' TM1py has some sample code which appears to address what you want: http://tm1py.readthedocs.io/en/latest/api.html#tm1-objects Extracts from the docs: class TM1py.ChoreService(rest) Service to handle Object Updates for TM1 Chores activate(chore_name) create(chore) create_task(chore_name...
by David Usherwood
Mon Feb 19, 2018 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data encryption at rest with PA local v 2.0.3
Replies: 6
Views: 572

Re: Data encryption at rest with PA local v 2.0.3

Finally! :o
Must have a look at how they've done it.
by David Usherwood
Wed Jan 31, 2018 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Table on TM1
Replies: 3
Views: 383

Re: Table on TM1

You can certainly use a sequential dimension to capture your data. But since your content doesn't seem to work well in TM1, can you explain what you are going to do with it?
by David Usherwood
Mon Jan 08, 2018 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data encryption at rest with PA local v 2.0.3
Replies: 6
Views: 572

Re: Data encryption at rest with PA local v 2.0.3

I raised this with IBM in Feb 17 about PA Local 2.0 and received nothing of use. I suspect that the FIPSOperationMode parameter may be relevant but (again) the documentation is of no help.
by David Usherwood
Thu Dec 21, 2017 11:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple TM1 Applications on one Application Server
Replies: 1
Views: 263

Re: Multiple TM1 Applications on one Application Server

Short answer is yes. In PM you can connect to and build applications from multiple servers. Possibly stating the obvious, the applications should have different names. I haven't used the application migration facility as it had a poor reputation (possibly been fixed) and I found that rebuilding an a...
by David Usherwood
Mon Dec 18, 2017 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- Cell Background Color Change
Replies: 3
Views: 324

Re: TM1 Web- Cell Background Color Change

That looks like a grid, not an active form. If you use an active form, you can put conditional formatting rules in the format area at the top and they will apply to the current output.
by David Usherwood
Mon Dec 11, 2017 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 951

Re: PAW questions

The current version is supported under Docker for Windows (Server 2016) but I have not heard positive reports about it so you are better off installing on Linux (IBM push Red Hat but Ubuntu is fine) I have now heard from the InfoCat team that the latest release of PAW for Windows is stable and reco...