Search found 80 matches

by scrumthing
Tue Oct 26, 2021 3:04 pm
Forum: Useful code, tips and tricks
Topic: Undocumented Date Functions
Replies: 5
Views: 32282

Re: Undocumented Date Functions

nice findings... Thanks George!
by scrumthing
Thu Oct 07, 2021 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing TM1 database assets with Git
Replies: 12
Views: 11344

Re: Managing TM1 database assets with Git

Works for us as well. Unfortunately it is only possible to use ssh for all users or for none. That is a bit annoying.
by scrumthing
Tue Aug 10, 2021 11:02 am
Forum: General
Topic: Alternate Solutions to TM1
Replies: 10
Views: 68273

Re: Alternate Solutions to TM1

the intention of having one security framework for both the TM1 server and PAW The will (and should and kind of already have on the cloud) move to OpenID. TM1 server already allows for OpenID connections today (Secret security mode 6 anyone). So I am pretty sure it will not change backend-wise dram...
by scrumthing
Mon Aug 09, 2021 5:34 pm
Forum: General
Topic: Alternate Solutions to TM1
Replies: 10
Views: 68273

Re: Alternate Solutions to TM1

Maybe you should look for an alternative frontend for TM1 to avoid the PAW hustle and try renegotiating your price with either IBM or a partner can do some wonders... Just saying ;-)
by scrumthing
Mon Jul 26, 2021 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44297

Re: Planning Analytics 2.0.9.9

It’s most probably been an issue for ages. I always cursed when I had this. I expect it to have been there forever. Still no reason why IBM should not have tackled this one years ago. I cannot imagine I am the only one out there with a Personal.xlsb and starting perspectives from a blank canvas. Yo...
by scrumthing
Thu Jul 22, 2021 12:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Integration With Google Sheets
Replies: 7
Views: 10246

Re: Planning Analytics Integration With Google Sheets

You could do it with TM1Py I think you can and you should to it with tm1py. :-) Most obvious solution from my point of view would be to use tm1py to put the data from tm1 into a pandas dataframe and push that dataframe into a google sheet. https://towardsdatascience.com/using-python-to-push-your-pa...
by scrumthing
Mon Jul 19, 2021 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44297

Re: Planning Analytics 2.0.9.9

Alan Kirk wrote: Sun Jul 18, 2021 1:32 am
Or the third one, more people will buy Arc and see their blood pressure drop by 30 basis points. (Yes, I know that I keep banging on about Arc but it is just SO. GOOD.)
AGREED!
by scrumthing
Fri Jul 16, 2021 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44297

Re: Planning Analytics 2.0.9.9

Currently it somewhat becomes hard to keep track of the new versions.
by scrumthing
Tue Jun 15, 2021 9:20 am
Forum: Enhancements
Topic: Mode 1 users able to change password in Pafe
Replies: 7
Views: 47922

Re: Mode 1 users able to change password in Pafe

I do not know what to say about that. I proves AGAIN that those people at IBM do neither know how their product works nor how people use it.
Especially because I fear now that they want to force us to use their crapware CAM for authentication.
by scrumthing
Wed May 19, 2021 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Performance Modeler license as ReadOnlyUser
Replies: 7
Views: 4530

Re: Planning Analytics Performance Modeler license as ReadOnlyUser

Technically it works to set an admin user as ReadOnly. Afterwards you cannot change that property back if you do it for your own user.
But I would not trust that feature. It is originally intended for checking license usage and nothing more. The rest is unintended side effects AFAIK.
by scrumthing
Thu Apr 22, 2021 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 202105 - What's your security mode poison?
Replies: 6
Views: 4401

Re: Monthly Poll 202105 - What's your security mode poison?

You triggered me here Alan. Authentication is such a painful experience... We have to rely on native authentication because neither integrated login nor CAM provide the needed functionality. We have to have a single CAM server for multiple internal clients where one user has access to databases from...
by scrumthing
Wed Apr 21, 2021 8:21 pm
Forum: Enhancements
Topic: Mode 1 users able to change password in Pafe
Replies: 7
Views: 47922

Re: Mode 1 users able to change password in Pafe

Steve Rowe wrote: Wed Apr 21, 2021 12:17 pm Currently mode 1 users are unable to change their password in Pafe.
It is like IBM is not even trying to create a decent replacement for Perspectives... One vote from me as well!
by scrumthing
Fri Apr 09, 2021 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Register process via RestAPI
Replies: 14
Views: 7563

Re: Register process via RestAPI

orlando wrote: Fri Apr 09, 2021 7:14 am Hi,
what's the "hidden property code". We are using version 2.08 an 2.09.
It will be more complex code.
Best regards,
orlando
Check this out... https://github.com/bgregs514/vscode-tm1 ... -786979805
by scrumthing
Thu Apr 08, 2021 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Register process via RestAPI
Replies: 14
Views: 7563

Re: Register process via RestAPI

I think your main problem is that you have the process file which is not in the format the rest api would expect. For the rest api to accept your ti you would have to extract all necessary information from the file and create the json file which the rest api expects. If it is just code without param...
by scrumthing
Tue Feb 23, 2021 8:51 am
Forum: Free And Open Source Tools
Topic: Visual Studio Code Extension for TM1
Replies: 12
Views: 65890

Re: Visual Studio Code Extension for TM1

ykud wrote: Tue Feb 23, 2021 4:08 am We can start voting for extension name :) I think it should be vscode-tm1
+1 for that one from my side :-)

Issue tracking on Github sounds like a great idea. Happy to help too.
by scrumthing
Sat Feb 20, 2021 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 7695

Re: Monaco TM1 Editor with Intellisense

ykud wrote: Sat Feb 20, 2021 10:55 am live editing with rest api would be a game changer. I’d be happy to contribute, but will need to learn typescript )
Agreed!
by scrumthing
Fri Feb 19, 2021 7:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 7695

Re: Monaco TM1 Editor with Intellisense

VS Code!!! Definitely!
by scrumthing
Fri Feb 19, 2021 8:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 7695

Re: Monaco TM1 Editor with Intellisense

bgregs wrote: Thu Feb 18, 2021 4:15 pm Stay tuned for updates on TM1 Editor, a slight shift in design will be taking place shortly and I plan on having an announcement out later this week - as soon as we can get over this crazy Texas weather!
Looking forward to that. Can't wait to see what will happen. ;-) Awesome project!
by scrumthing
Mon Feb 08, 2021 9:30 am
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 19
Views: 105162

Re: PickList to show Alias but store Element Name

Very useful function. The only thing I found so far is that it has problems if you have a numeric value (i.e. 1 & 0) as element names and strings as alias (i.e. TRUE & FALSE). Those values cannot be written via that hidden feature. It seems TM1 is writing the value and afterwards changing it...
by scrumthing
Mon Feb 01, 2021 9:42 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.6
Replies: 9
Views: 51126

Re: TM1py 1.6

Very cool release. I especially love the write_dataframe method after some initial struggle with our German locale on the server side. :-D it makes some of the fancy data science **[Expletive Removed]** you can do with Python a lot easier to get back into the cube. The windows authentication is awes...