Search found 1276 matches

by David Usherwood
Tue Oct 08, 2019 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule causing service to go down?
Replies: 2
Views: 516

Re: Rule causing service to go down?

If you have access to the server directory, edit the .RUX file with Notepad and comment out the problematic rule. Then look for the matching .BLB file and delete or rename it. Then restart the server.
by David Usherwood
Fri Oct 04, 2019 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How user will add element and run process on their own?
Replies: 1
Views: 419

Re: How user will add element and run process on their own?

Seems to me that you have not yet completed development - though it is possible that the users did not say what they needed (amazing I know, but it does happen). The solution is to build them a websheet with an action button to call the TI(s) to create the element and copy the content. Make sure you...
by David Usherwood
Wed Oct 02, 2019 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unique identity to identify elements in TM1 subsetEditor
Replies: 1
Views: 244

Re: Unique identity to identify elements in TM1 subsetEditor

Elements are unique in a dimension (unless you are brave enough to use the unfinished named hierarchy functionality, in which case they are unique in a hierarchy) - so DIMIX gives you the index of the element. I suggest that a clean up/deduplication of your subset would make life easier for your use...
by David Usherwood
Fri Sep 27, 2019 7:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuring rights
Replies: 1
Views: 649

Re: Configuring rights

Suggest you start here: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/c_controllingaccesstotm1objects_n60007.html (It's pre PA but still applies.) High level summary: TM1/PA Security is based on groups Users are members of one or more groups...
by David Usherwood
Sun Aug 25, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 5322

Re: loading fields from csv without knowing the type of value

Until around 2002 InfoCat did both TM1 and Lotus Notes work. I recall that there was then an ODBC driver for Lotus Notes - but Notes' data model was quite unusual in that fields could be multi valued and the multiple values did not need to be the same data type. In practice the design and usage of t...
by David Usherwood
Thu Aug 22, 2019 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User at a lower level cannot view data on a chart created at a level above
Replies: 3
Views: 1820

Re: User at a lower level cannot view data on a chart created at a level above

IMO Tomok hasn't explained enough to get you to address the issue. You probably have security set up on the dimension holding your various hierarchy levels. This link should help. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/t_assigningsecu...
by David Usherwood
Thu Aug 01, 2019 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3273

Re: Dynamic query argument in TI...

My preference is to set the whole query up in the local variable DataSourceQuery and then write it out to a file for debugging purposes eg:

Code: Select all

datasourcequery = 'SELECT *
From A_TABLE
WHERE NUMERIC_DATE <= ' | nDate
;
asciioutput(test.csv',datasourcequery);
by David Usherwood
Fri Jul 19, 2019 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 591

Re: Why IBM should sell off TM1 by James Wakefield

I was working as a graduate consultant and asked by my boss to start learning TM1. I installed TM1 Perspectives, but then couldn't understand why companies would pay for a very bland looking pivot table product. I was then asked to install the server (version 6) and again was thinking, wow this DOS...
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: 1815

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

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: 11
Views: 787

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

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

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

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

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

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

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: 12
Views: 1037

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: 12
Views: 1037

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.