Search found 1267 matches

by David Usherwood
Tue Jun 11, 2019 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 10
Views: 1082

Re: TM1 Perspective Vs Pax

From what I can see the aim is for PAW to take on the developer admin tasks and PAX to be purely Excel reporting and budgeting. Even on these there is a way to go since PAX does not support the new named hierarchies in Dynamic (or Static) Reports so the best way to generate decent interactive report...
by David Usherwood
Thu Jun 06, 2019 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 11
Views: 423

Re: Manage Rights when a big chunk of elements are deleted

It's the TI command CellSecurityCubeCreate, supported in 10.2.something onwards:

Code: Select all

https://www.tm1forum.com/viewtopic.php?f=3&t=11423&p=54152#p54152
by David Usherwood
Sat Jun 01, 2019 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 10
Views: 305

Re: RunTI Issue

Please re-read and digest Paul's suggestion that dividing the loads by 250 GL accounts is not the best use of resources. If you rethink your 'granularity' and divide the loads to match the (TM1) cores you have you should get better performance and the extra second delay to manage login contention wi...
by David Usherwood
Mon May 20, 2019 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RestAPI View has less figures Ascii Export
Replies: 10
Views: 1342

Re: RestAPI View has less figures Ascii Export

You have a rather good analytics engine available. I suggest you create a new cube with a measure
Ascii
Rest
Difference = Ascii - Rest
and import the two feeds. You should then be able to identify the differences.
by David Usherwood
Wed Mar 27, 2019 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spread functionality
Replies: 4
Views: 316

Re: Spread functionality

'Equal Spread Leaves' is probably the spread option you want - the last choice on the right click menu in Architect.
by David Usherwood
Tue Mar 26, 2019 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 5
Views: 893

Re: JAVA Extension

From what I can see there were deprecation notices issued for the JavaTI extensions but they have disappeared: Deprecation of Java TI (local only) - IBM https://www.ibm.com/support/knowledgecenter/.../pa_nf_javati_depn.html Local only IBM Planning Analytics Local 2.0.6 is the last release with suppo...
by David Usherwood
Wed Mar 20, 2019 9:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sage Line 50 ODBC
Replies: 0
Views: 125

Sage Line 50 ODBC

Has anybody had any success with using Sage's Line 50 ODBC drivers to pull data directly into TM1? They are somewhat odd as Line 50 doesn't use an RDBMS - data is stored on the file system, one company per folder. We get 'unable to open connection to database' when creating the TI. Excel (32 bit) wo...
by David Usherwood
Wed Mar 20, 2019 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CubeUnload
Replies: 5
Views: 262

Re: TM1 CubeUnload

TM1 never hands back memory to the OS. If you can identify cubes which are not required and also not linked via rules or feeders to cubes you do need, you can set these to Load on Demand and reduce the RAM footprint. Otherwise I agree with orlando - review your feeders using the Performance Monitor ...
by David Usherwood
Wed Mar 13, 2019 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 5
Views: 893

Re: JAVA Extension

You are in luck then - the REST API has been around since 10.2.something. I suggest you look at TM1PY as a well supported and functional Python library for TM1.
by David Usherwood
Mon Jan 28, 2019 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 11
Views: 400

Re: Cube Viewer suppress zeroes hiding non-zero cells

Returning to @jamesbennett's problem - you should be able to identify the feeder issue by careful review of your rules and feeders.
by David Usherwood
Sun Jan 27, 2019 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 11
Views: 400

Re: Cube Viewer suppress zeroes hiding non-zero cells

That does look correct - but I am pretty sure you do have a feeder issue. Suggest you restart the server and recheck - possibly you have conditional feeders and the parameters have changed without a restart or refeed.
by David Usherwood
Sun Jan 27, 2019 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Element Insert
Replies: 10
Views: 697

Re: Subset Element Insert

You are recreating your subset in the Data tab every time you read a record. Move the destroy/create code to the Prolog.
by David Usherwood
Fri Jan 25, 2019 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 11
Views: 400

Re: Cube Viewer suppress zeroes hiding non-zero cells

You selected 'Trace Calculations'. You need to select 'Check Feeders'. Make sure you are at the N level and on a calculated value.
by David Usherwood
Fri Jan 25, 2019 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 11
Views: 400

Re: Cube Viewer suppress zeroes hiding non-zero cells

Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.
by David Usherwood
Thu Jan 24, 2019 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking for Underfed cells
Replies: 10
Views: 827

Re: Checking for Underfed cells

You could try this - quite similar to yours but doesn't involve changing the rules. Create a clone cube with an extra measure dimension Difference = Values - Fed Values Write a TI to export N level values from your real cube to the clone cube Run it with zero suppress on, writing to Fed Values Run i...
by David Usherwood
Tue Jan 22, 2019 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing Parameters to a HANA View
Replies: 1
Views: 216

Re: Passing Parameters to a HANA View

In the Prolog, build up the query with the parameters you want as a string and write it to the local variable DATASOURCEQUERY.
by David Usherwood
Thu Jan 10, 2019 10:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button: eliminate borders
Replies: 7
Views: 484

Re: Action button: eliminate borders

it is such option that I'm looking for, but don't find it in TM1 10.2
I should have made clear that the Developer toolbar is an Excel option - not a TM1 option:
https://www.techonthenet.com/excel/ques ... ab2013.php
by David Usherwood
Wed Jan 09, 2019 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button: eliminate borders
Replies: 7
Views: 484

Re: Action button: eliminate borders

Enable the Developer menu
Select Properties of the object
Format Shape
Shape Options\Line\No Line

I've tested this with PAX Action Buttons but I believe this would work with Perspectives Action Buttons
by David Usherwood
Tue Jan 08, 2019 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 3779

Re: TM1 REST API

@bgregs, I don't think you are being quite fair in your post. TM1PY is written and supported by Marius Wirtz of Cubewise Germany. In my opinion (I have been working with TM1 since 1995) he has done a stonking job at rendering the TM1 REST Api accessible to those of us who don't wish to become full-o...
by David Usherwood
Sun Nov 04, 2018 7:59 am
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 1451

Re: Deactivating chores in Architect takes time

It's Marius' (sample) code, not mine. I suggest you install Python and TM1PY and play around with it. My own view is that this is far and away the best way to use the REST API for most purposes. (I have made some progress with using TM1PY to integrate TM1 with PowerBI.)