Have you looked at the TI function CellPutProportionalSpread
https://www.ibm.com/docs/en/planning-an ... onalspread
Search found 32 matches
- Mon Sep 27, 2021 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spreading data in a procedure
- Replies: 6
- Views: 4931
- Thu Mar 05, 2020 12:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Snapshot with Excel Formulas
- Replies: 3
- Views: 2371
Re: TM1Web Snapshot with Excel Formulas
Hi,
Note that the Print Reports feature in Perspectives will do this for you if you select the snapshot option in TM1 10.2.2.
I do realise you ideally want it in TM1Web but not possible in 10.2.2 or Planning Analytics.
Tom
Note that the Print Reports feature in Perspectives will do this for you if you select the snapshot option in TM1 10.2.2.
I do realise you ideally want it in TM1Web but not possible in 10.2.2 or Planning Analytics.
Tom
- Mon Dec 04, 2017 11:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create view consisting of C elements
- Replies: 4
- Views: 3151
Re: Create view consisting of C elements
Hi, ViewSubsetAssign is expecting a Subset as the final argument and I think you are just putting in a Consolidated Element. I suspect that the full message you are getting is something like: Subset "All Cost Center" not found in dimension "Cost Center" If so probably the easiest...
- Wed Nov 23, 2016 11:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
- Replies: 164
- Views: 122951
Re: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Hi, I did a Cognos Express 10.2.1 SSL Update recently. It says in Step 5 that you may not have a pmpsvc folder so some of the steps may not be applicable. I did have a pmpsvc folder but didn't have pmpsvc\WEB-INF\Bin64\ssl folder so I ignored the 3rd bit of Step 5 and also ignored some of the later ...
- Sat Jun 11, 2016 2:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Reopen the same Sheet/Application after closing it
- Replies: 1
- Views: 1666
Re: Reopen the same Sheet/Application after closing it
Hi, If you effectively need a button to reset your Active Form to the way it was originally on TM1Web, (before you made other selections), I can think of 2 ways to achieve this. 1. In your Reset button in Worksheet\Advanced Options you could set (e.g. if your Subnm was on the Company dimension and w...
- Fri Jan 22, 2016 12:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Two active forms alongside
- Replies: 5
- Views: 4075
Re: Two active forms alongside
Hi,
As you mention you cannot use the Excel function INDIRECT on TM1Web. However, from memory, you can use the Excel function OFFSET on TM1Web to achieve the same result.
Tom
As you mention you cannot use the Excel function INDIRECT on TM1Web. However, from memory, you can use the Excel function OFFSET on TM1Web to achieve the same result.
Tom
- Thu Jun 18, 2015 11:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 tools excel add-in not working in Excel 64 bit
- Replies: 15
- Views: 16080
Re: TM1 tools excel add-in not working in Excel 64 bit
Hi,
Just wondering if anyone got this working?
Thanks,
Tom
Just wondering if anyone got this working?
Thanks,
Tom
- Wed Mar 18, 2015 11:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Key Err* Tracer for Excel 64-bit
- Replies: 0
- Views: 1875
Key Err* Tracer for Excel 64-bit
Hi,
Just wondering if anyone has got a key err* tracer to work with 64-bit Excel, particularly Excel 2013 64-bit?
Thanks,
Tom
Just wondering if anyone has got a key err* tracer to work with 64-bit Excel, particularly Excel 2013 64-bit?
Thanks,
Tom
- Mon Feb 20, 2012 6:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: COUNTIF not working in TM1 Web ActiveSheets
- Replies: 4
- Views: 3781
Re: COUNTIF not working in TM1 Web ActiveSheets
Hi,
I have come across issues with COUNTIF on TM1web before which I needed to work around.
Try the following :
Add the following formula into column BY
=IF(OR(LEFT(BX1,6)="Please",LEFT(BX1,4)="Item"),1,0)
Then your formula becomes
=SUM(BY:BY)
Tom
I have come across issues with COUNTIF on TM1web before which I needed to work around.
Try the following :
Add the following formula into column BY
=IF(OR(LEFT(BX1,6)="Please",LEFT(BX1,4)="Item"),1,0)
Then your formula becomes
=SUM(BY:BY)
Tom
- Mon Jul 25, 2011 9:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using Excel as ODBC - can't write sql
- Replies: 2
- Views: 2679
Re: Using Excel as ODBC - can't write sql
You need to specify the sheet, as you have already specified the workbook in the ODBC setup.
You also need to add an $ at the end so try:
Select * from [Department$];
I have never used this on a live system - usually trying to get away from Excel datasources.
Tom
You also need to add an $ at the end so try:
Select * from [Department$];
I have never used this on a live system - usually trying to get away from Excel datasources.
Tom
- Wed Jul 13, 2011 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Forms Stacked Dimensions Formatting
- Replies: 8
- Views: 8291
Re: Active Forms Stacked Dimensions Formatting
Hi, I had a similar issue and worked around it by using conditional formatting in the Format Area. E.g. If the formatting on the N level was on row 7 in the format area, put in formula based conditional formatting in cell B7 =B7=B6 and set the font to Black or Automatic This will ensure that all col...
- Thu Apr 29, 2010 3:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Totals for Dynamic Subsets
- Replies: 5
- Views: 4810
Re: Totals for Dynamic Subsets
Hi, Not sure either of these precisely matches your requirements but may give you ideas : (1) If you have a subset (dynamic or otherwise) on your Supplier dimension you can use that subset name in an Excel slice as if it was an element in the Supplier dimension - if you are only interested in the to...
- Mon May 18, 2009 5:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Freeze data ?
- Replies: 5
- Views: 4365
Re: How to Freeze data ?
I think the nearest you'll get is ElementSecurityPut which means you will need to have a statement for each security group or loop through them.
HTH.
Tom
HTH.
Tom
- Mon May 18, 2009 2:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Freeze data ?
- Replies: 5
- Views: 4365
Re: How to Freeze data ?
Hi,
Open the Subset Editor for the relevant Scenario dimension, right click on the relevant element and select Security\Lock.
Just select Unlock to reset later.
Tom
Open the Subset Editor for the relevant Scenario dimension, right click on the relevant element and select Security\Lock.
Just select Unlock to reset later.
Tom
- Thu May 07, 2009 5:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Delete in TI by current year
- Replies: 1
- Views: 2150
Re: Delete in TI by current year
Hi,
If you simply want to generate the current calendar year in TI, the following code will work in 8.4.
CurrYear = TIMST( Now(), ' \Y');
Tom
If you simply want to generate the current calendar year in TI, the following code will work in 8.4.
CurrYear = TIMST( Now(), ' \Y');
Tom
- Thu Apr 30, 2009 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill-Through Example tm1
- Replies: 1
- Views: 2039
Re: Drill-Through Example tm1
Hi,
Have you taken a look at the "Creating Drill-Through Processes and Rules" section in the Developers Guide ?
Tom
Have you taken a look at the "Creating Drill-Through Processes and Rules" section in the Developers Guide ?
Tom
- Wed Dec 10, 2008 5:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Re-Order Failed
- Replies: 11
- Views: 7967
Re: Dimension Re-Order Failed
The only time I have seen this is if you try and move a dimension containing string values which is typically the last dimension.
Leave that alone and move the rest and you should be fine.
Tom
Leave that alone and move the rest and you should be fine.
Tom
- Fri Dec 05, 2008 3:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 32 bit install on 64 bit server
- Replies: 3
- Views: 3395
Re: 32 bit install on 64 bit server
Hi Martin,
32 bit TM1 on a 64 bit server should be able to access 4GB RAM without having to make any changes.
Tom
32 bit TM1 on a 64 bit server should be able to access 4GB RAM without having to make any changes.
Tom
- Tue Oct 21, 2008 9:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 API Element Security
- Replies: 4
- Views: 4033
TM1 API Element Security
Hi, We are having an issue with TM1 9.1 API's on 64 bit. We are updating an application that was originally written in TM1 V6 API but currently being used in TM1 v8.4 (32 bit) The problem is with updating Element Security. In version 8 it takes minutes compared to hours in v9 for approximately 250,0...
- Thu Aug 14, 2008 11:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 9.1 - Logging Client Properties
- Replies: 15
- Views: 11404
Re: 9.1 - Logging Client Properties
Thanks for that.
Very useful.
Tom
Very useful.
Tom