Search found 530 matches

by gtonkin
Tue Jan 16, 2018 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Creating View Array
Replies: 8
Views: 286

Re: Error Creating View Array

Mark RMBC wrote:
Tue Jan 16, 2018 11:30 am
...
When you say refresh security do you literally mean SecurityRefresh or ElementSecurityPut?
...
I mean run a SecurityRefresh, as a test for now, to rule out that after adding a new element, there is not a permissions issue for non-admin users.
by gtonkin
Tue Jan 16, 2018 5:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a new blank unsaved TI... it executes a different TI
Replies: 6
Views: 175

Re: Running a new blank unsaved TI... it executes a different TI

Are you running perspectives off your local machines or via a remote desktop/Citrix environment? Have seen some weird behaviour in a shared environment where users are not configured correctly and seem to share the same temporary folders and TM1 ini.
by gtonkin
Tue Jan 16, 2018 5:53 am
Forum: Useful code, tips and tricks
Topic: Could not create dynamic subset
Replies: 7
Views: 92

Re: Could not create dynamic subset

...Still works, but the DimName has to be the 4th Argument Thanks for testing and confirming TM123 - appreciated. I am still cautious of using undocumented features as they could potentially stop working with any future upgrade. They also make it a bit confusing when handing over to another resourc...
by gtonkin
Mon Jan 15, 2018 7:18 pm
Forum: Useful code, tips and tricks
Topic: Could not create dynamic subset
Replies: 7
Views: 92

Re: Could not create dynamic subset

Have not tested this in 10.2.2FP4 as 3rd parameter is now for temporary object-will have to test if 4th works as third did previously.

Edit: thanks for the reminder TM123
by gtonkin
Mon Jan 15, 2018 6:49 pm
Forum: Useful code, tips and tricks
Topic: Could not create dynamic subset
Replies: 7
Views: 92

Could not create dynamic subset

With 10.2.2 FP4 and above you can get around the error thrown by SubsetCreateByMDX when the MDX returns a blank result. SubsetCreateByMDX.PNG Traditionally you would code something like: sDim='Versions'; sSubsetName='CurrentVersion'; sMDX='{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Versions] )}, "2018")}'...
by gtonkin
Mon Jan 15, 2018 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Creating View Array
Replies: 8
Views: 286

Re: Error Creating View Array

Do you have element security on the Version dimension? If so, do you do a security refresh?
by gtonkin
Fri Jan 12, 2018 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a new blank unsaved TI... it executes a different TI
Replies: 6
Views: 175

Re: Running a new blank unsaved TI... it executes a different TI

When you say " I create a brand new process, and immediately run this blank/empty process."

How are you running the process?
-Right click on process, run
-Clicking the Run icon within the process
-Action Button
-Other
by gtonkin
Thu Jan 11, 2018 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View not visible after load server
Replies: 14
Views: 2420

Re: View not visible after load server

Resurrecting this one as we seem to have the same issue as the OP. There was a power failure and the server went down at 18 seconds past midnight (in a data center!) Log file was corrupt and one or two other issues - }Groups attributes cube corrupt and another cube, both restored from earlier backup...
by gtonkin
Tue Jan 09, 2018 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 293

Re: Poll : Which version of Excel is used in your business

Also not a straight forward answer as many of my clients have a blend of either 2010/2013 or 2013/2016 - there are some 2007 still floating around. At this stage, only TM1 series out there so not too concerned, yet.
by gtonkin
Mon Jan 08, 2018 7:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Put Value In Rule Based Cell
Replies: 4
Views: 155

Re: TI Process Put Value In Rule Based Cell

I always have a dimension for Version/Type and it generally contains Actual and Rolling Forecast - Rolling Forecast is generally live with rules, Actual is what is imported from source. Rolling Forecast is populated with Actuals for historic months and STET'ed and Calcs as required by the model. At ...
by gtonkin
Mon Dec 18, 2017 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 786

Re: Count in rules

Posting this link to the IBM Developer Works site as there is a Proven Practice article dealing with Feeders that you and others should benefit from.
by gtonkin
Mon Dec 18, 2017 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 786

Re: Count in rules

The syntax you had previously was correct but you need to have the source you are feeding from on the left and the target on the right. For now just switch the measure names.

I do suggest further reading on feeders as you will not get far in TM1 without a thorough understanding of them.
by gtonkin
Mon Dec 18, 2017 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 786

Re: Count in rules

... Not Working Rule and Feeders : Skipcheck; ['Cases with TurnAround' ] =N: IF( ['TurnAround Time' ] > 0,1,0); ['Average TurnAround Time' ] =C:DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !...
by gtonkin
Sun Dec 17, 2017 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 786

Re: Count in rules

You may have confused yourself here. If you are deriving Average Turnaround time based on Cases with Turnaround Time, this (Cases with Turnaround Time) needs to be on the left I.e. feed from the dependent variable into the one being calculated.
HTH
by gtonkin
Fri Dec 15, 2017 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 508

Re: Change in Element Name of a frequently used Dimension

... 4 . Restarted the Server. However,please know, here i had not changed any value in the cubes( i think this is the concept of "Dirty cubes" which gtonkin was referring to, though i am unsure of that). ... Same as what Lotsaram was saying, you just need to change a cell in the cubes that use the ...
by gtonkin
Thu Dec 14, 2017 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 508

Re: Change in Element Name of a frequently used Dimension

... I do not even know how to use a hex editor to find the references to the dimension element i want. I surely get that it is a painful job but i would certainly like to get an idea of that. Can Pspad be used for this purpose? You need a proper hex editor, not a text editor, I use Free Hex Editor ...
by gtonkin
Thu Dec 14, 2017 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 508

Re: Change in Element Name of a frequently used Dimension

... These aren't text files so you'll need a hex editor in order to find the references to the dimension element you want. I've never tried this before and I highly doubt it will work but give it a try. Just make sure you do it on backup copies of everything... I have often used the Hex Editor meth...
by gtonkin
Mon Dec 11, 2017 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 714

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

"worksheet scoped named ranges" relate to named ranges that are valid only on the sheet you define them. For example, If you have a workbook with multiple sheets and each of them had a Business Date cell for example, you could reference that cell using the cell reference e.g. $B$6 or alternatively, ...
by gtonkin
Fri Dec 08, 2017 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 714

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

I would recommend using worksheet scoped named ranges for the process and parameters references. This way, column and rows changes do not affect the Action button. I have also found that between office versions, the Action Button properties seem to change/break, especially the server reference - dou...
by gtonkin
Wed Dec 06, 2017 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 213

Re: MDX to Filter on Numeric Attribute

Steve Rowe wrote:
Wed Dec 06, 2017 10:24 am
...Personally I rarely use them since they behave like strings and I can't write rules versus them...
Thanks Steve, agree on the strings and the usage of another cube as you can secure better as well as use picklists to populate the text "attribute".