Search found 1238 matches

by David Usherwood
Thu Jul 12, 2018 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 336

Re: Check if the data of two cubes are the same

Where to start... Firstly, it wouldn't be sensible to review the destination cube till all the concurrent processes are complete. Secondly, TM1 exists to roll up data to totals. If the dimensions of your cubes have been designed sensibly there will be totals on almost all dimensions. Create a slice ...
by David Usherwood
Thu Jul 12, 2018 9:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 852

Re: Executing Java application through TM1 process

I would argue that you can do much, much more with the REST API than just retrieving data from a TM1 server. But I agree with you that TM1Web is not customisable in the way that the OP had imagined. That doesn't stop them from using the REST API to populate a TM1 cube which can then be put on a webs...
by David Usherwood
Tue Jul 10, 2018 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 852

Re: Executing Java application through TM1 process

I just gave it as a first hand example as this was not the only thing we wanted to do, that is why I dabbled with the API, so that we can expand on it. Getting logged clients is just a starting point of our TM1 extension using TM1 API. Be aware that there are many APIs available. I would recommend ...
by David Usherwood
Mon Jul 09, 2018 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 852

Re: Executing Java application through TM1 process

I would suggest you are out of luck, since you can neither transfer the JAR file to the server nor execute it there. Time to rethink your approach. If you are willing to recode in Python, I have a good opinion of Marius Wirtz' TM1PY libraries ( https://code.cubewise.com/tm1py/ ) I'm also going to as...
by David Usherwood
Fri Jun 29, 2018 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Benefits of REST API over native TM1py/TM1JavaApi
Replies: 3
Views: 226

Re: Benefits of REST API over native TM1py/TM1JavaApi

To quote from the TM1PY page: By wrapping the IBM Planning Analytics (TM1) REST API in a concise Python framework, TM1py facilitates Python developments for TM1. So, by using TM1PY, you are using the Rest API - just wrapped in a more manageable package. I'm a fan of TM1PY and think Mariusz has done ...
by David Usherwood
Fri Jun 22, 2018 8:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA when running TI processes Kick out RDP
Replies: 6
Views: 393

Re: PA when running TI processes Kick out RDP

Probably the issue is that the credentials under which the TM1 instance on the server is running do not have the same access as those on the local instance - remember it's the instance rather than the user who executes the TI which determines access. But I have some wider questions - since TM1 as a...
by David Usherwood
Tue Jun 19, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 936

Re: Using dimension PickList to filter data on import to cube

Suggest IF (DimIx ('2 Major Project PL List', Planning_Project_Code) > 0); CellPutS(Planning_Project_Code, 'Major Project Assumption', job_unique_id, 'Major Project Number'); ELSE; itemskip; ENDIF; Also - I don't think you should be adding elements into the dimension using if (DIMIX('3 Major Project...
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: 468

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

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

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

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

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

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

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

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

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

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

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