TM1 Forum

Have you looked at the TI function CellPutProportionalSpread

https://www.ibm.com/docs/en/planning-an ... onalspread

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

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

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

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

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

Hi,

Just wondering if anyone got this working?

Thanks,

Tom

Hi,

Just wondering if anyone has got a key err* tracer to work with 64-bit Excel, particularly Excel 2013 64-bit?

Thanks,

Tom

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

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

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

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

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

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

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

Hi,

Have you taken a look at the "Creating Drill-Through Processes and Rules" section in the Developers Guide ?

Tom

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

Hi Martin,

32 bit TM1 on a 64 bit server should be able to access 4GB RAM without having to make any changes.

Tom

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

Thanks for that.

Very useful.

Tom