TM1 Forum

Hey Everyone, We are using a SUBNM formula in a cell in PAfE. When Excel is set to Manual Calculation mode, selecting an element from the SUBNM dropdown or the subset editor results in the cell displaying RECALC instead of the selected element's name. This issue only occurs when the calculation mode...

Hi All, Can we write rules in }ClientGroups cube? I have written below rule, but it does not provide required access to the user. The rule calculates correctly. e.g. it does update 'ADMIN' in the }ClientGroups cube for user X, but does not provide admin rights to the user X []=S: IF(DB('Cube1',ATTRS...

I don't think this is a preferred option, but the set editor is an available widget in the PAW api . You can render the set editor within a userform in excel. This method would require the modifying & saving a public subset and then calling a refresh of the list pointed to that subset after the...

I have below query: I am fetching date using SUBNM in an Excel sheet. Cell A2 = 26-01-2024 This date is in format DD-MM-YYYY. There is further excel calculation. For example, Cell B2 = A2+3 When the windows date format is the same, Cell B2 is calculating fine. However, when the windows format change...

Hello Guys, I am new in TM1 and need a help from the experts. I have a client requirement to create forecasting & budgeting depending on the actuals data provided. They haven't given any specific requirement for forecasting & budgeting. Could you please help me with any function/way to forec...

Requirement: Header Dimensions: Dimension 3 Dimension 4 Dimension 5 Dimension 6 Dimension 7 Amount Dimension 1 Dimension 2 Jan Primary Code CNT 45 Primary Code N 34 Code 1 CNT 45 Code 2 N 34 Header Dimensions: Dimension 3 Dimension 4 Dimension 5 Dimension 6 Dimension 7 Amount Dimension 1 Dimension 2...

Hello everyone, I am using a cube view as datasource in TI. I am doing some calculation where I need data in descending order, so the source cube data should flow in data & Metadata tabs in descending order. I tried using 'Filter option available in cube viewer, but it works only in the cube vie...