Search found 1347 matches
- Tue Jun 11, 2019 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspective Vs Pax
- Replies: 10
- Views: 8694
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...
- 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: 6033
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
- Sat Jun 01, 2019 10:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunTI Issue
- Replies: 11
- Views: 6365
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...
- 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: 5747
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.
Ascii
Rest
Difference = Ascii - Rest
and import the two feeds. You should then be able to identify the differences.
- Wed Mar 27, 2019 3:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spread functionality
- Replies: 4
- Views: 2707
Re: Spread functionality
'Equal Spread Leaves' is probably the spread option you want - the last choice on the right click menu in Architect.
- Tue Mar 26, 2019 9:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: JAVA Extension
- Replies: 9
- Views: 5677
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...
- Wed Mar 20, 2019 9:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sage Line 50 ODBC
- Replies: 0
- Views: 1985
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...
- Wed Mar 20, 2019 8:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 CubeUnload
- Replies: 5
- Views: 3717
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 ...
- Wed Mar 13, 2019 9:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: JAVA Extension
- Replies: 9
- Views: 5677
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.
- 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: 12
- Views: 9574
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.
- 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: 12
- Views: 9574
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.
- Sun Jan 27, 2019 8:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Element Insert
- Replies: 10
- Views: 6005
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.
- 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: 12
- Views: 9574
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.
- 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: 12
- Views: 9574
Re: Cube Viewer suppress zeroes hiding non-zero cells
Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.
- Thu Jan 24, 2019 9:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Checking for Underfed cells
- Replies: 13
- Views: 6900
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...
- 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: 1605
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.
- Thu Jan 10, 2019 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action button: eliminate borders
- Replies: 7
- Views: 4442
Re: Action button: eliminate borders
I should have made clear that the Developer toolbar is an Excel option - not a TM1 option:it is such option that I'm looking for, but don't find it in TM1 10.2
https://www.techonthenet.com/excel/ques ... ab2013.php
- Wed Jan 09, 2019 10:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action button: eliminate borders
- Replies: 7
- Views: 4442
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
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
- Tue Jan 08, 2019 4:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 REST API
- Replies: 20
- Views: 26488
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...
- Sun Nov 04, 2018 7:59 am
- Forum: Useful code, tips and tricks
- Topic: Deactivating chores in Architect takes time
- Replies: 9
- Views: 21998
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.)