TM1 Forum

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