TM1 Forum

If anyone is interested, we have a full installation guide for PAW on Windows 2019 at https://exploringtm1.com/how-to-install-planning-analytics-workspace-to-windows-server-2019/. This also then includes a link for installing Mirantis Container Runtime on Windows 2019 and changing the drive used for...

Got it! Used the following:
{TM1FilterByLevel(Descendants( [Time].[FY2022]) , 0)}

And boom, tish!

Hi all, I need to write some MDX that returns the weeks that are N level to a year in a Time dimension. For example, for 2022, I want to get 2022.Wk1, 2022.Wk2 etc. I am only interested in the N level, so for 2022, I should have 52 elements in the subset. I will then replace 2022 with pYear so it ca...

Thanks Alan. I have upvoted your suggestion.

I thought of that @DavidUsherwood, but PAW won't give the fine granular control I need to create the web pages or apps. Thanks for the thoughts though!

Hello @sighurd, well yes and probably more, no. This will not be an end user tool, it will be coded fixed dashboards as the front end of a web based application.

Hi Everyone, I want to create a web and phone-based application that uses TM1 as the engine and is presented using schmick browser and app dashboards. I need to have write-back available to the TM1 server. I get the TM1 side and will use the REST API to get to the data. I am then thinking of using s...

Thanks @mvaspal. So is what you are saying that we need to have something feeding at least one of the N level elements, even if there is no value on any of those elements? So in the example below to feed something to either N1 or N2:

C: C level calculation of, say, 10
N1: 0
N2: 0

Hi all, We have a C level calculation in play where it is quite likely that none of the children of the calculation will have a value, and are therefore not forcing the consolidation to take place. We will have a ConsolidateChildren inserted, but that still does not feed upwards. Can anyone please r...

Cool. Thanks Alan.

Wow. Ok, so thanks for that Alan. So if I am going to use date formatted cells, then so I can make the model work correctly it sounds like I should force the use of dates to use 1-Jan-1900. That way everything will be consistent. Would you agree?

There is something that I hadn't updated in the Dates And Times document, which applies to PA only; look for the "UseExcelSerialDate=T" config parameter in the Installation Guide. (I've added a cross-reference to this thread to the guide as an interim solution.) If you look in your server...

Hi all, I want to store dates in a cube. I have a Simple element called "Variation Date" that then has date formatting applied to it via attributes using "c:dd-mmm-yy". I understand that TM1 dates start from 1-Jan-1960 and that the "real" value stored in this cell will ...