List of Contributions

Hubert Heijkers

Contact Details

My Content

1 to 20 of 50+ total
Posted By Hubert Heijkers Fri March 15, 2024 10:49 AM
Found In Egroup: Planning Analytics
\ view thread
Wasn't thinking about embedding another language but rather take a leap step and make the TI 'language' (if we dear calling it that) into something we would dear calling a scripting language, without breaking backwards compatibility preferably (people seem to be adverse to forced change so I'm going ...
Posted By Hubert Heijkers Fri March 15, 2024 04:42 AM
Found In Egroup: Planning Analytics
\ view thread
Hold that thought, that's the world backwards not;-? I admire all your creativity but isn't what you are really saying that TI is simply to limited in functionality for what people ended up using it for (for a long time already) and what you'd really want is effectively be able to do in TI what you ...
Posted By Hubert Heijkers Mon March 04, 2024 03:49 AM
Found In Egroup: Planning Analytics
\ view thread
Hi, Wim beat me to it but wanted to add that whilst they seem like constants, this is still TI after all, they are just another TI function that does nothing more and nothing less than always return the same number (at least for a particular version of TM1, albeit I don't recall us changing those numbers). ...
Posted By Hubert Heijkers Mon January 22, 2024 03:14 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Bilal, Just so it is clear to me, in step 4 where you update the instance from MAIN branch, does that operation succeed? I guess I'm confused as to what you mean with "At deployment time" in step 5. Is that still part of the GitPull of the update or is that when you execute the Chore AFTER the update? ...
Posted By Hubert Heijkers Tue January 02, 2024 04:19 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Calvin, First up, let me apologize for the cryptic 'Dimension not found' error as all Hierarchies of a dimension in TM1 are, under the covers, implemented as separate "Dimensions". But I get the feeling, given the fact that you seem to have specified the element's name as the hierarchy name ...
Posted By Hubert Heijkers Mon November 13, 2023 03:00 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Edward, Not only are there plans, they have already been set in motion as well. Exact details to follow but high level the plan is to allow picking up a while as the [partial] body of an ExecuteHttpRequest and having it base64 encoded before being injected in the body, but also an equivalent ...
Posted By Hubert Heijkers Tue October 24, 2023 03:24 PM
Found In Egroup: Planning Analytics
\ view thread
Hi David, I'm guessing that API to send those e-mails has a way to inject attachments as 'part' of the body, potentially even base64url encoded or something I'm guessing (Microsoft Graph API is OData compliant as well;-). That would, today, still be a bit of a challenge in TI. And since these ...
Posted By Hubert Heijkers Thu October 19, 2023 11:46 AM
Found In Egroup: Planning Analytics
\ view thread
Cool, it should indeed not be any harder then that. And with the upcoming support for JSON in TI constructing that JSON becomes even nicer as well! Just to give you an idea, building the body using those new JSON function would look something like: vBody = JsonAdd( '()', '/personalizations/to/email', ...
Posted By Hubert Heijkers Thu October 19, 2023 06:01 AM
Found In Egroup: Planning Analytics
\ view thread
There are many e-mail delivery services out there that have REST API that can all be interacted with using ExecuteHttpRequest (services like SendGrid, MailChimp, etc.). Amazon, if you don't have an Amazon WorkMail account already in which case for low volumes you might be able to simply us that, has ...
Posted By Hubert Heijkers Thu October 12, 2023 10:43 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Ardian, Not sure what you mean by a 'GIT deployment packages' but I if you are asking if there are plans to include PAW contents in source for a TM1 database I'd expect the answer would be no, that seems unlikely, but more a question for Stuart. Are you looking for a GIT based 'solution' ...
Posted By Hubert Heijkers Thu October 12, 2023 08:42 AM
Found In Egroup: Planning Analytics
\ view thread
Great to see Planning Analytics starting to take full advantage of the GIT integration functionality provided by TM1 (a.k.a. PAE), love it! Just wanted to add thought that, whilst people seem to be looking for capabilities to simply 'move objects across', the GIT integration functionality was designed ...
Posted By Hubert Heijkers Tue October 03, 2023 05:52 PM
Found In Egroup: Planning Analytics
\ view thread
Sorry Joshua, have to ask, if you'd reorder again to the order you chose, does it blow up the file again? And if so, would it be a model (cube with supporting assets) you could share with IBM to study what might be off (6MB to 47GB can't be right IMHO). ------------------------------ Hubert ...
Posted By Hubert Heijkers Tue October 03, 2023 05:18 PM
Found In Egroup: Planning Analytics
\ view thread
Hi Joshua, Just out curiosity, did you try changing the order back and if so does the file size go back down to approximately those 6MBs? Also, how many dimensions does this cube have? Cheers, ------------------------------ Hubert Heijkers STSM, Program Director TM1 Functional ...
Posted By Hubert Heijkers Mon September 25, 2023 03:05 AM
Found In Egroup: Planning Analytics
\ view thread
So noted @Vlad Didenko;-! As for $filter and $order, those can be applied to open properties too but those would still need to be valid OData identifiers if we follow the OData standard. Truth be told I like the DIMENSION PROPERTIES based solution best as well and, as you say, in the case of Ex ...
Posted By Hubert Heijkers Fri September 22, 2023 02:37 PM
Found In Egroup: Planning Analytics
\ view thread
Don't particularly like it, as IMHO that's mixing up protocol, query with actual action execution but I can see that could be a workaround (yet still something not trivial as you can imagine request execution happens at a different level/layer then selection/projection, but not impossible). My preferred ...
Posted By Hubert Heijkers Mon September 18, 2023 05:32 PM
Found In Egroup: Planning Analytics
\ view thread
I'll bite;-), it is technically an issue caused by myself where I decided to map attributes to open properties of an open type to make querying and interacting with attributes way easier then treating attribute names as values of a property itself, full well knowing that attribute names do not have to ...
Posted By Hubert Heijkers Mon September 18, 2023 03:35 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Vlad, That is indeed correct, our REST API, which is OData compliant, to be able to parse whatever you put on the URL of the request, sticks to the URL convention rules which state that what you can use in $select, $expand and other query options, have to be valid OData Identifiers. We have been ...
Posted By Hubert Heijkers Wed September 13, 2023 01:51 PM
Found In Egroup: Planning Analytics
\ view thread
Hi Médard, Let me start by saying that support for multiple database directories, as described in the tm1s.cfg configuration documentation referenced by you, is and will continue to be supported in TM1 v11. Stuart's comments were wrt PAA. I'll leave it up to Stuart to comment if anything changed ...
Posted By Hubert Heijkers Mon May 01, 2023 04:22 AM
Found In Egroup: Planning Analytics
\ view thread
As you know locking is part of normal operations, part of TM1's two-phase locking protocol it uses to it's concurrency control. This mechanism guarantees concurrent/exclusive access to objects in the system by threads if and when they need them. When however multiple threads need elevated access to an ...
Posted By Hubert Heijkers Tue April 25, 2023 11:50 PM
Found In Egroup: Planning Analytics
\ view thread
Understood John, absolutely! In the meantime I've fixed it (for good;-) and we are making sure this fix goes into TM1 Server 11.8.20 which is the version that ought to be picked up by PA 2.0.9.17. Apologize for the inconvenience, ------------------------------ Hubert Heijkers STSM, Program ...