TM1 Forum

Hi Jim, if I got it, you suggest to put all months in the sheet and then use SUBNM to filter them, right? But how can we use SUBNM for columns? Now we have two different Excel files, one for FCST II and one for FCST III, respectively. Maybe we could also put them in different sheets in the same Exce...

Hello guys, our financial planning application consists of Excel sheets published in TM1 Applications (version 10.2.2.0) There are two different kinds of scenario: FCST II and FCST III. The former considers 8 months (from May XXXX to December XXXX), while the latter takes into account 18 months, fro...

Gabor, Mems, thank you for your support. The TM1 Application is an Excel sheet. We could fix the issue with a workaround based on SUBNM and DBSS. In the form we used SUBNM("Server_Name:Picklist_Dimension";"";1), where Picklist_Dimension is a dimension whose unique elements are Y ...

Hi, we have a picklist issue in TM1 Application, version 10.2.2. We created a picklist as Dimension:Dim_Name, where Dim_Name has elements Y and N. Everything works fine in Perspectives: the picklist is shown correctly and the cube is updated instantaneously. However, when we deployed the form and op...