Search found 13 matches
- Mon Feb 19, 2024 11:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: An interesting point that I found when updating the "Current Version" thread. (PAW and Windows Server 2019)
- Replies: 5
- Views: 1782
Re: An interesting point that I found when updating the "Current Version" thread. (PAW and Windows Server 2019)
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...
- Fri Mar 04, 2022 3:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for Weeks in a Year using a Parameter for Year
- Replies: 2
- Views: 946
Re: MDX for Weeks in a Year using a Parameter for Year
Got it! Used the following:
{TM1FilterByLevel(Descendants( [Time].[FY2022]) , 0)}
And boom, tish!
{TM1FilterByLevel(Descendants( [Time].[FY2022]) , 0)}
And boom, tish!
- Fri Mar 04, 2022 3:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for Weeks in a Year using a Parameter for Year
- Replies: 2
- Views: 946
MDX for Weeks in a Year using a Parameter for Year
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...
- Sun Mar 31, 2019 11:03 pm
- Forum: Enhancements
- Topic: TI Commands To Change / Update The Schedule of Chores
- Replies: 3
- Views: 46514
Re: TI Commands To Change / Update The Schedule of Chores
Thanks Alan. I have upvoted your suggestion.
- Thu Aug 16, 2018 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Web Dashboards via REST API
- Replies: 5
- Views: 4210
Re: Web Dashboards via REST API
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!
- Thu Aug 16, 2018 8:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Web Dashboards via REST API
- Replies: 5
- Views: 4210
Re: Web Dashboards via REST API
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.
- Sun Aug 12, 2018 11:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Web Dashboards via REST API
- Replies: 5
- Views: 4210
Web Dashboards via REST API
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...
- Fri Apr 20, 2018 4:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeding a C Level Calculation
- Replies: 4
- Views: 3663
Re: Feeding a C Level Calculation
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
C: C level calculation of, say, 10
N1: 0
N2: 0
- Thu Apr 19, 2018 7:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeding a C Level Calculation
- Replies: 4
- Views: 3663
Feeding a C Level Calculation
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...
- Wed Oct 18, 2017 3:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Date Display Using Attribute Format
- Replies: 7
- Views: 7746
Re: TM1 Date Display Using Attribute Format
Cool. Thanks Alan.
- Mon Oct 16, 2017 11:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Date Display Using Attribute Format
- Replies: 7
- Views: 7746
Re: TM1 Date Display Using Attribute Format
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?
- Mon Oct 16, 2017 7:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Date Display Using Attribute Format
- Replies: 7
- Views: 7746
Re: TM1 Date Display Using Attribute Format
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...
- Sun Oct 15, 2017 11:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Date Display Using Attribute Format
- Replies: 7
- Views: 7746
TM1 Date Display Using Attribute Format
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 ...