Search found 1264 matches

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: 7
Views: 520

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.)
by David Usherwood
Fri Nov 02, 2018 2:17 pm
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 1394

Re: Deactivating chores in Architect takes time

I sometimes feel like a stuck record promoting TM1PY, but one of Marius' examples does exactly that: https://github.com/cubewise-code/TM1py-samples/blob/master/Update%20Objects/update%20chore.py To repeat the key code: with TM1Service(**config['tm1srv01']) as tm1: # Read chore: c = tm1.chores.get('r...
by David Usherwood
Fri Oct 26, 2018 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Applications (Contributor) Question
Replies: 3
Views: 448

Re: Cognos Applications (Contributor) Question

It's not been said in this thread, but 'Applications Web' (=Contributor) is still available with PA. I doubt it supports named hierarchies (which, IMO, are not really finished anyway) but, with all its known fragility and flakiness, it's there. I have my doubts about what IBM will do in PAW to deliv...
by David Usherwood
Wed Sep 26, 2018 5:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to delete a view via right click in PAW?
Replies: 5
Views: 708

Re: How to delete a view via right click in PAW?

The toolbar I see at the top left (if that's what you have in mind) has no delete icon (I imagine a dustbin or whatever) when a view is selected (in chrome, as admin). Can you elucidate?