Search found 727 matches

by paulsimon
Mon Feb 03, 2020 10:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 285

Re: String size limit of a parameter in a TI

Hi

Also when you run a TI process always check the return code eg

vRet = ExecuteProcess(...)

IF( vRet <> ProcessExitNormal() ) ;
.... Some error handling
ENDIF ;
by paulsimon
Mon Feb 03, 2020 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 21
Views: 7498

Re: RunProcess explanation

Hi Are all the processes operating on separate views with separate subsets? If not then one process may be destroying the view used by another part way through. Using temporary subsets and views may help overcome that. However, I still tend to agree with others here, that experimenting with parallel...
by paulsimon
Sun Feb 02, 2020 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 285

Re: String size limit of a parameter in a TI

Good point Declan. I recently had an issue where someone had used a hard-return in the column heading of an Excel worksheet and then saved it as a CSV file. When read in, it made the TI miss out something like the first 500 lines of the file. It wasn't something you could detect and fix in the TI be...
by paulsimon
Sun Feb 02, 2020 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 285

Re: String size limit of a parameter in a TI

Hi It can depend on how you are passing the parameter. If you are passing it from an Action Button via Excel then I believe the limit is only 255 chars, but this is due to a limitation in Excel rather than TI. I have never really needed to pass a parameter that big, but in TI I have certainly built ...
by paulsimon
Mon Jan 27, 2020 10:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of DimensionDeleteAllElements
Replies: 3
Views: 135

Re: Use of DimensionDeleteAllElements

Hi There are some other reasons to avoid using DimensionDeleteAllElements. If the rebuild fails a) Elements will be deleted from any Static Subsets b) Any views that referenced the deleted element in title subsets may be invalidated c) If you reference consolidated elements in rules, the rules will ...
by paulsimon
Thu Jan 23, 2020 9:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 256

Re: Process Error Log Not Available

Hi Tom Your solution is pretty much what we do. However, one suggestion is that rather than have the attribute on the process dimension, have it on the client dimension or a copy of that. The reason being that if two users run the same process and both get an error, then there will only be a record ...
by paulsimon
Tue Jan 21, 2020 10:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 271

Re: Dynamic YTD Calculation on a Continuous Time Dimension

Hi As Lotsaram says, consolidation is the way to do this. Rules are in general 100 times slower than consolidation. However, be careful how you arrange the rollups. In the past I would have done this using a chaining method like this. 1st Jan YTD = 1st Jan 2nd Jan YTD = 1st Jan YTD + 2nd Jan 3rd Jan...
by paulsimon
Mon Jan 20, 2020 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Protect DBRW fomrula in Perspectives
Replies: 8
Views: 325

Re: Protect DBRW fomrula in Perspectives

Hi Your profile shows that you are still on 10.2.2. If so, then I would consider upgrading to Planning Analytics. You can then use PAX which will give faster performance than Perspectives. I say this because if you are about to start writing VBA you might end up having to re-write it again when you ...
by paulsimon
Thu Jan 16, 2020 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 12
Views: 439

Re: To know Active Users & Inactive Users of TM1

Hi Deleting users is a bad idea for many reasons. You will potentially lose Private Views and Subsets stored against those users. If there is anything else stored against the user it will also be lost, such as TM1 Web settings, Locks on Dimension Elements, etc. If the user does not already exist, th...
by paulsimon
Wed Jan 15, 2020 11:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Protect DBRW fomrula in Perspectives
Replies: 8
Views: 325

Re: Protect DBRW fomrula in Perspectives

Hi I know what you mean. Users simply deleting DBRW formula is one issue. The worst case is where they start cutting and pasting and you end up with a DBRW alongside one row column combination that is actually pointing at a completely different row and column and it is therefore showing the wrong va...
by paulsimon
Thu Jan 09, 2020 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 160

Re: Asciioutput Data Export is not working

Hi You only quoted part of my answer. If you read my full answer then that will answer your question. "There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using a native view, albeit with a fairl...
by paulsimon
Thu Jan 09, 2020 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Being Removed From Security Group in TM1
Replies: 2
Views: 103

Re: User Being Removed From Security Group in TM1

Hi Peter The fact that the security is resetting itself at login almost certainly means that it is something to do with CAM since that is the point at which CAM will copy Group membership from the security store, typically Windows Active Directory, in to TM1 Security Groups. If you open up }ClientGr...
by paulsimon
Wed Jan 08, 2020 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 160

Re: Asciioutput Data Export is not working

Hi Are you outputting text values rather than numerics? I am guessing that you are since you don't have any conversion on the asciioutput There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using...
by paulsimon
Fri Jan 03, 2020 9:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Getting Subset Properties
Replies: 2
Views: 122

Re: Error Getting Subset Properties

Hi Are you talking about PAX? We encountered a similar issue whereby even a Native View has to have a column dimension. A View that only has rows, and context elements won't work. Does your view with filtered MDX on the rows have at least one dimension on the columns? We have encountered similar iss...
by paulsimon
Wed Dec 18, 2019 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 14
Views: 1588

Re: TM1 Server crash on saving dimension (status Suspended)

Hi It looks like Ken's problem was specific to the Dimension Editor, but from PavoGa's description it looks like a crash from a TI process. Is that the case? We have also had some crashes with the Dimension Editor but fortunately only in Non-Production environments, as we don't really use the Dimens...
by paulsimon
Tue Dec 17, 2019 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add Elements to own Control Dimension
Replies: 3
Views: 398

Re: Add Elements to own Control Dimension

Hi You have solved your own problem. Put the code in the Prolog or MetaData and it will work. However, I would advise you against starting dimensions with }. It can become difficult to differentiate these from real Control Dimensions. You run the risk that IBM might use this dimension name at some p...
by paulsimon
Mon Sep 16, 2019 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with dimension Leaves
Replies: 4
Views: 867

Re: Working with dimension Leaves

@Lotsaram What I was getting at is that from what I have seen TI functions such as DimensionElementInsert operate on the Main Hierarchy, or the Default Hierarchy, what most of us think of as the traditional dimension, but of course, the idea of a traditional dimension goes as soon as you introduce a...
by paulsimon
Sun Sep 15, 2019 11:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with dimension Leaves
Replies: 4
Views: 867

Re: Working with dimension Leaves

Hi When using Real Named Hierarchies, any of the Dimension TI Functions actually apply to the Main aka Default Hierarchy of the Dimension - What we traditionally think of as the Dimension. So I would guess that what you are seeing is that DimensionDeleteAllElements is clearing all elements from the ...
by paulsimon
Fri Sep 13, 2019 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 2274

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi

Just an update on this. We have now got data coming in the correct columns. However, the problem is now that any text attribute values are being read in as numbers instead of as text. IBM have re-produced this and are investigating.

Regards

Paul Simon
by paulsimon
Tue Sep 10, 2019 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 2274

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi Wim

Thanks for the offer but we should have our own test server with 2.0.8 up in a week or so.

I have referred the issue over to IBM.

Regards

Paul Simon