TM1 Forum

Hi all. Below is code to enable double clicking on a cell to bring up the drill though selections (normally this is selected on by right clicking on a cell with the DBRW and selecting Drill). Just a neat way to use double clicking, The code needs to be on each worksheet that you want to enable this ...

Hi. For those who want to use TM1SystemServerConnect with Xcelerator below is an example of the code required which is used in place of TM1SystemServerConnect - Declare Function - Declare Function TM1SystemServerConnectWithCAMNamespace Lib "tm1api.dll" (ByVal hPool As Long, ByVal vServerNa...

& = AND eg (Value1 > 5) & (Value1 < 10) Returns TRUE if the value is greater than 5 and less than 10.
% = OR eg (Value1 > 10) % (Value1 < 5) Returns TRUE if the value is greater than 10 or less than 5.
~ = NOT eg ~(Value1 > 5) Equivalent to (Value1 <= 5)

Hi.

IF ( entity @= '1000' % entity @= '5000' );
... do something;
ENDIF;

check out Tm1 help on 'logical operators'

Hi. It's not difficult to loop through the dimension - though is there are reason you want to replicate the same data across multiple versions? eg In the data tab you would have the following - however it is important to remember that this loop will occur for each record returned from your source. T...

Hi. CellPutN is as follows: CellPutN( value, CubeName, Element of Dim1, Element of Dim2, Element of Dim2 etc) Assuming BILLDAYS is in your variables tab and is numeric you'd need something like this: CellPutN(BILLDAYS,'Planning',vNumber,vPeriod,'Actual'); CellPutN(BILLDAYS,'Planning',vNumber,vPeriod...

1. First you need to stop the Tm1 service (save your data first) 2. Create a blob file using text editor and place it under the appropriate applications folder (if any), eg under }Applications\MyReports (or just }Applications if there are no sub folders) - save the following as a file called say Boo...

Hi. You don't need to assign the dimension to titles/rows/columns etc in a zero out view. Just assign the elemenst you want to zero out to a subset that is then assigned to the zero our view. If your DIMIX('base_month_dates',vDate) is saved say as the subset CurrentMonths and this contains the eleme...