Search found 545 matches

by gtonkin
Thu Feb 22, 2018 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 5
Views: 93

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

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

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

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

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

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...
by gtonkin
Thu Feb 08, 2018 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access from different domain
Replies: 1
Views: 105

Re: Access from different domain

Hi Loki, Have a look here - I remember going through a similar process trying to get integrated login with TM1 Web working - points 1 through 6 are probably relevant. I now use a field in the }ClientProperties to enter the Domain and then use a rule for the unique id - there should also be a post co...
by gtonkin
Wed Feb 07, 2018 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Login History of users
Replies: 3
Views: 178

Re: Login History of users

I use the the alternate logging method to create a log file with logins. I then run a TI as a chore to process this file and write to a cube so that I can track frequency and last date of login.

Have a look at this thread for some guidelines
by gtonkin
Tue Feb 06, 2018 6:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 402

Re: Excel Subtotals at the top of Active Form

... setting WebsheetRowThreshold to a large enough value to ensure the active form is always fully rendered (which will have definite negative performance impacts!) Apologies tm123-Lotsaram has highlighted the flaw-I was testing on a smallish sample. Thanks for your input Lotsaram makes perfect sen...
by gtonkin
Tue Feb 06, 2018 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 402

Re: Excel Subtotals at the top of Active Form

Tried it on PA 2.0.1 before posting-seems to work fine-had an Active form with levels and it summed as I collapsed and expanded-numbers obviously nonsense but functioned as expected.
by gtonkin
Tue Feb 06, 2018 9:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 402

Re: Excel Subtotals at the top of Active Form

Try this alternative then:

Code: Select all

=SUM(INDEX(TM1RPTDATARNG1,,COLUMN()))
Assuming the formula will be in the column it is summing, otherwise change accordingly.
by gtonkin
Fri Feb 02, 2018 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 402

Re: Excel Subtotals at the top of Active Form

You can try this:

Code: Select all

=SUM(OFFSET(TM1RPTDataRng1,0,3,ROWS(TM1RPTDataRng1),1))
Replace TM1RPTDataRng1 with the relevant range per your workbook. The range starts in column A, so an offset of 3 in my example reads from column D.
by gtonkin
Sun Jan 28, 2018 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM TM1 license details
Replies: 2
Views: 298

Re: IBM TM1 license details

License are firstly counted based on the users contained within the }Client dimension. Based on your post, if you create 28 users, you will need 28 licenses. Not sure if any of those users are Admin too, if not you would need and Admin license in addition to the users. It gets more complicated based...
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: 241

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

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

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

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

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

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

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")}'...