Search found 574 matches

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

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

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

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

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

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

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 433 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: 567

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

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

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 ...
by gtonkin
Fri May 04, 2018 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Stuck on Zero Out
Replies: 4
Views: 327

Re: Process Stuck on Zero Out

Note sure if it is getting unhappy here: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, SUBSETGETSIZE(dimIndex, subRef) + 1); may be worthwhile trying: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, 0); If memory serves, I remember the 0 index adds to the end but you will need to test. Failing...
by gtonkin
Thu May 03, 2018 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instance stuck on restart on StatsBy... cub files
Replies: 8
Views: 345

Re: TM1 instance stuck on restart on StatsBy... cub files

Are your saves in Epilog?-had issues previously with these in Prolog.
by gtonkin
Sun Apr 29, 2018 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add attributes to control dimension
Replies: 9
Views: 441

Re: Add attributes to control dimension

If the dimension is used in a cube, have you tried creating a picklist cube then writing the relevant rule against the dimension?
by gtonkin
Fri Apr 27, 2018 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 11
Views: 1051

Re: TM1RunTI Parallel Processing with Batch File Error Capture

There are some parameters for START - type in START /? at the command prompt - there may be something like the /I parameter that may work. The other issue that comes to mind is with the multiple commands being run, you can have a return code from each of them. Even if you were to have separate batch...
by gtonkin
Fri Apr 27, 2018 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 11
Views: 1051

Re: TM1RunTI Parallel Processing with Batch File Error Capture

Instead of START, try using

Code: Select all

cmd /c c:\ibm\cognos\tm1_64\bin64\tm1runti.exe -i "D:\TM1\Example\RunProcess.ini" -process "BuildDim" pDim="Dim1"... 
I have not tested with multiple statements but worth a try.
by gtonkin
Sat Apr 21, 2018 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 11
Views: 1051

Re: TM1RunTI Parallel Processing with Batch File Error Capture

HI ptownbro, just fired up my server-I was getting stuck at START C:\ibm... - exit code was 9059. Try removing the START to see what you get: I am using: "C:\program files\ibm\cognos\tm1_64\bin64\tm1runti.exe" -i "C:\temp\RunTM1Process.ini" I dropped the -p as this is already in the INI file. You ma...
by gtonkin
Thu Apr 19, 2018 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 11
Views: 1051

Re: TM1RunTI Parallel Processing with Batch File Error Capture

Have a look at ERRORLEVEL is not %ERRORLEVEL% which may give you a bit more insight. I may only have some time to test out your batch file on the weekend to give more pointed advice.
HTH
by gtonkin
Thu Apr 12, 2018 6:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working days on TM1
Replies: 1
Views: 261

Re: Working days on TM1

A good start is your Calendar cube. In its most simple form, you would have a time dimension and a measures dimension. The measures dimension usually has calendar days and business days. Ensure that you can derive Working days MTD and YTD. If you are going to span years, would suggest a single, cont...
by gtonkin
Tue Apr 10, 2018 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 564

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

Generally when you create a hierarchy with levels, you would set sort order to Hierarchy so that it represents as a tree structure. This however depends on your goal as you may choose manual and order elements as you want. No right answer here. Would refer you to the manuals/online help with element...
by gtonkin
Tue Apr 10, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 564

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

Ashleigh W wrote:
Tue Apr 10, 2018 11:24 am
Set to sort manually by Name.
Currently set or was set? Did you change to automatic by hierarchy?
If you select element 903, can you roll it up to check what its parent is?
by gtonkin
Tue Apr 10, 2018 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 564

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

Right click your dimension, click Set Elements Order then Automatic and Hierarchy. You can use TI to set this too, to set to Hierarchy and name, but try the right-click method first.