TM1 Forum

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

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

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.

'Equal Spread Leaves' is probably the spread option you want - the last choice on the right click menu in Architect.

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

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

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

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.

Returning to @jamesbennett's problem - you should be able to identify the feeder issue by careful review of your rules and feeders.

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.

You are recreating your subset in the Data tab every time you read a record. Move the destroy/create code to the Prolog.

You selected 'Trace Calculations'. You need to select 'Check Feeders'. Make sure you are at the N level and on a calculated value.

Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.

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

In the Prolog, build up the query with the parameters you want as a string and write it to the local variable DATASOURCEQUERY.

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

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

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

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

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