Search found 585 matches

by gtonkin
Sun Aug 19, 2018 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sluggish ODBC recordset
Replies: 4
Views: 63

Re: Sluggish ODBC recordset

Hi Paul, There is no Excel on the server but querying the table via HeidiSQL portable (no SSMS on server either), I get the same results as from the workstation, roughly 7 seconds. I know this is not a like-for-like comparison as I am not using ODBC but at least gives an indication that the network ...
by gtonkin
Sun Aug 19, 2018 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sluggish ODBC recordset
Replies: 4
Views: 63

Re: Sluggish ODBC recordset

Thanks for the reply Paul. Tried the SELECT TOP 17549 records from the query but made no difference. There appears to be only varchar and decimal columns in the recordset, as well as the filters-does not look like anything out of the ordinary. The table was re-indexed but no changes. Apologies,what ...
by gtonkin
Sun Aug 19, 2018 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sluggish ODBC recordset
Replies: 4
Views: 63

Sluggish ODBC recordset

I have a basic process on a DEV TM1 server to retrieve a set of records from a SQL server via ODBC. The query returns roughly 18,000 records, 20 columns of numeric and text data. We are talking a fairly small data set here, no huge text chunks, binary objects etc. If I run the process it seems to ha...
by gtonkin
Sat Aug 04, 2018 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form showing wrong value
Replies: 1
Views: 208

Re: Active Form showing wrong value

What does it show when you rebuild the AF with Alt+F9?
by gtonkin
Mon Jul 02, 2018 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web does not show any TM1 Service
Replies: 6
Views: 255

Re: TM1 Web does not show any TM1 Service

I had to update the Java Keystore and make changes to the PMPSVC batch file too when I patched 10.2.2 FP4 previously. Check on the forum or IBM for the process document, my batch file had the below which may give you some things to check: @echo off set TM1_INSTALL_DIR=C:\Program Files\ibm\cognos\tm1...
by gtonkin
Wed Jun 27, 2018 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- #NAME? error in 1 column
Replies: 3
Views: 156

Re: TM1 Web- #NAME? error in 1 column

Have a look at the Excel Functions that are supported in TM1Web - the two you are using are not supported AFAIK.
by gtonkin
Tue Jun 26, 2018 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementInsert
Replies: 13
Views: 411

Re: SubsetElementInsert

If you only run: ViewCreate(pCube, sView); and nothing further, you will notice that the each of the dimensions references a subset called "All". THis is what Lotsaram was saying about not having to assign subsets if you don't need to. The "All" subsets contain as you expect, all elements, and as Lo...
by gtonkin
Mon Jun 25, 2018 7:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 468

Re: Retrieving member name by alias

Try using a scan and subst function to find the hyphen between the code and description then subst to chop from the right to the end. If your codes are all uniform in length, you can subst from character 8 onwards (or wherever the description starts)
by gtonkin
Mon Jun 25, 2018 7:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementInsert
Replies: 13
Views: 411

Re: SubsetElementInsert

Yes, that is correct. You need to create a view if you do not have one then for each dimension, assign the relevant subset to ensure that you zero out only what you intend to. Make sure that you know what is going to be zeroed. If you want to check your view, hash out the ZeroOut or add a ProcessQui...
by gtonkin
Mon Jun 25, 2018 7:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementInsert
Replies: 13
Views: 411

Re: SubsetElementInsert

If you already have an All N subset, assign that to your view to be zeroed out. Alternatively, create dynamic subset for All N using SubsetCreatebyMDX. You should be able to find quite a few examples with a quick search - don't forget to set the last parameter to avoid an error on an empty subset.
by gtonkin
Mon Jun 25, 2018 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 468

Re: Retrieving member name by alias

You can try using:
DBRA(<dimension name>,<element>,<alias>) e.g DBRA('Account','5010','Account Description') if in Perspectives (hoping PAX too)
or in rules, use ATTRS(<dimension name>,<element>,<alias>)
HTH
by gtonkin
Mon Jun 11, 2018 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - use a file as datasource of a process
Replies: 1
Views: 150

Re: PAW - use a file as datasource of a process

Not going to be too much help but think you already know that an HTTP code of 500 relates to permissions. Guessing you cannot create the upload file on the Cloud instance. Not sure if this is by design with the sample/test environment through Concierge. p.s. were you able to create users using the f...
by gtonkin
Fri May 25, 2018 6:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import data from SQL table into TM1 cube with user input
Replies: 4
Views: 335

Re: Import data from SQL table into TM1 cube with user input

Leading on from what Declan and Lotsaram have said. I normally create an attribute on my measures dimension to indicate that the measure will be used for input. This is generally referenced in the security model but leveraged in TI. In my load process I use MDX to create an All N subset with a filte...
by gtonkin
Sat May 19, 2018 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 691

Re: PAW - missing dimensions and processes

trentban wrote:
Sat May 19, 2018 2:07 pm
is there a workaround to assign an admin user after the first login?
Have a look in the guide I posted the link to in the previous post - Chapter 6 - Change a User's Role.
I am still playing on a single user (admin) instance but let us know how you get on.
by gtonkin
Fri May 18, 2018 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 691

Re: PAW - missing dimensions and processes

Found this document today which seems to contain a lot more than I previously had on Workspace - It details the roles, permissions and administration. HTH
by gtonkin
Thu May 17, 2018 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 691

Re: PAW - missing dimensions and processes

What I did pick up from the installing PAW on Windows 2016 Youtube video is that the *first* user to log into PAW is deemed the administrator from there on out. Not sure how you change this or where at this stage.
by gtonkin
Thu May 17, 2018 1:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 691

Re: PAW - missing dimensions and processes

Could be permissions or version - I am logged in as Admin on PAW 2.0.4 running on Windows 2016 and see:
PAW_Control_Objects.PNG
PAW_Control_Objects.PNG (26.81 KiB) Viewed 650 times
Further down are the Control Processes.
by gtonkin
Tue May 15, 2018 5:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 800

Re: Filtered by string measure in a 3 dimension cube

Your "AAA" string is stored in a cube so filtering by pattern will not work. Have a look around on the forum for where INSTR is used in MDX as you would need to use that to do your wildcard match.
by gtonkin
Wed May 09, 2018 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form crashes Excel
Replies: 3
Views: 304

Re: Active Form crashes Excel

Column C seems to be needed before column D can resolve but the AF is relying on column D to drive it. The dependencies seem to be "circular" which is why it works when you use a static element in column C. When you say it works on TM1 Web - as you have it with formulas in column C and D or with col...
by gtonkin
Sat May 05, 2018 5:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web active form speed issue
Replies: 5
Views: 415

Re: TM1 web active form speed issue

Hi Mark, If you are using an Active Form, the TM1RPTVIEW will replace the VIEW - not sure that even if you have other DBRWs referencing this, you will see gains. The first thing I always try and think about is what drives the Active Form - I then link the relevant DBRWs to the TM1RPTVIEW and create ...