Search found 559 matches

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: 5
Views: 369

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

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

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

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

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.
by gtonkin
Tue Apr 10, 2018 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 287

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

Check your dimension sort order. Try set to Hierarchy, by Name if not set already.
by gtonkin
Tue Mar 13, 2018 6:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 644

Re: Improve TI Processing Time

Please vote for an RFE for IBM to provide the function to copy rule based cells to values. https://www.ibm.com/developerworks/rfe/ ... _ID=116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube Noted that the comments on this RFE say that on 1 March 2018, IBM declined this req...
by gtonkin
Mon Mar 12, 2018 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 6007

Re: How to Use DBSW

I normally use something like:

Code: Select all

=IF($C$4,DBSW(...),"No Send")
C4 would have an expression to return True or False or just have a data validation. When TRUE, the DBSW is executed otherwise cells show "No Send". Works for me...and seems like it works for others too after reading right from the top.
by gtonkin
Sun Mar 11, 2018 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Parallel Processing with Batch File Error Capture
Replies: 5
Views: 369

Re: TM1RunTI Parallel Processing with Batch File Error Capture

Not sure if you have come across the Using TM1RunTI guide but based on the fact that you are using an INI file, you may have. What you need to do in your batch file is to use ERRORLEVEL - this variable will give you the return codes after executing the TM1RunTI command. Have a look here for more on ...
by gtonkin
Sat Mar 10, 2018 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI Won't Work or Return Error
Replies: 6
Views: 313

Re: TM1RunTI Won't Work or Return Error

May be that your ini file is located in your user folder, to which the server has no access-try move it to a folder that the user who started the TM1 service has access to.
by gtonkin
Thu Mar 01, 2018 6:32 pm
Forum: Useful code, tips and tricks
Topic: Recovering when an N element has been made a consol
Replies: 5
Views: 461

Re: Recovering when an N element has been made a consol

Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.
by gtonkin
Thu Mar 01, 2018 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 466

Re: Server Crash Due To Page File

Here's the interesting thing, we haven't loaded or modified any new dimension, cube, hierarchy whatsoever. Have you been loading data via SQL by any chance? Noticed a similar increase in memory at a client, luckily did not crash but seem to remember garbage collection also sitting with quite a lot ...
by gtonkin
Thu Mar 01, 2018 5:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 466

Re: Server Crash Due To Page File

May also be worthwhile deleting your feeder files if you are using persistent feeders, especially if you have been making rule changes and other structure changes. From some dev environments I have noticed that you can accumulate a lot of rubbish which then seems to be loaded, even if not needed, pu...
by gtonkin
Thu Feb 22, 2018 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 10
Views: 725

Re: TM1 Chore Schedule Information

Have a look here - Wim has done a lot of work around this, alternatively, look into the CHO file itself. There are some posts on interpreting the CHO file.
by gtonkin
Wed Feb 14, 2018 6:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issue
Replies: 4
Views: 277

Re: MDX Issue

Try something like: {Filter( {TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)}, [AR History].([AR Measures].[Recent Activity],[Months].[Feb 2018])=0 )} The cube name should be after the tuple/set then the area defined within the brackets. I split the code for readability.
by gtonkin
Wed Feb 14, 2018 8:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1server.log not getting updated
Replies: 3
Views: 265

Re: tm1server.log not getting updated

Confirm that you are looking in the correct location by checking the config in your TM1S.CFG
by gtonkin
Tue Feb 13, 2018 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 356

Re: MDX in TI to include additional group of the same dimension

Generally the brackets are used to enclose a set. I have had varied experiences when using or omitting them. I try use them when expecting multiple elements being returned. Maybe someone has a more technical answer to your question though. Have a look at this link: https://mobile.databasejournal.com...
by gtonkin
Tue Feb 13, 2018 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 356

Re: MDX in TI to include additional group of the same dimension

sMDX = '{TM1FILTERBYLEVEL( TM1DRILLDOWNMEMBER (TM1DRILLDOWNMEMBER {[' | vDimName | '].[(PROPOSED BUDGET)]},{[' | vDimName | '].[(RESTATED BUDGET)]}, ALL, RECURSIVE), 0)}'; .. Think you were almost there, just duplicated the TM1DRILLDOWNMEMBER( and mixed some brackets- try: sMDX = '{TM1FILTERBYLEVEL...
by gtonkin
Fri Feb 09, 2018 5:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 669

Re: Excel Subtotals at the top of Active Form

This one has been worrying me as I know I have some reports with 3000+ rows and am running on 10.2.2 FP4 i.e. Java, where we currently get a sum at the top of the column due to the way we derive the Active Form via MDX. One day we will need to migrate to PA and I wanted to confirm the impact. I buil...