Search found 532 matches

by gtonkin
Thu Jan 18, 2018 5:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder for cells with value based on rule
Replies: 2
Views: 175

Re: Feeder for cells with value based on rule

This would be a very rare case as generally the values being used in the calculation should be coming from an assumptions or driver cube which could then be used to feed the result. I worked on a cube recently which had values for a probability of default per client rating band-15 maturity buckets n...
by gtonkin
Tue Jan 16, 2018 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a new blank unsaved TI... it executes a different TI
Replies: 9
Views: 269

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

My Perspectives forces a save first (PA2.0.1) Architect gives same error.
Can only recommend that you save your process then run - without saving, the objects are probably not registered opening up a slew of possible issues.
by gtonkin
Tue Jan 16, 2018 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Creating View Array
Replies: 9
Views: 407

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: 9
Views: 269

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: 9
Views: 170

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: 9
Views: 170

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: 9
Views: 170

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: 9
Views: 407

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: 9
Views: 269

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

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

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

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

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

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

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

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

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

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

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

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, ...