Search found 72 matches

by scrumthing
Tue Jun 15, 2021 9:20 am
Forum: Enhancements
Topic: Mode 1 users able to change password in Pafe
Replies: 6
Views: 3194

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: 1798

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: 1985

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: 6
Views: 3194

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: 1740

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: 1740

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: 11
Views: 5837

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: 1797

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: 1797

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: 1797

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: 15
Views: 21570

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. Maybe ...
by scrumthing
Mon Feb 01, 2021 9:42 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.6
Replies: 6
Views: 3456

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...
by scrumthing
Wed Dec 09, 2020 10:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX connection to PA and CA
Replies: 3
Views: 550

Re: PAX connection to PA and CA

IBM stated that PAX is for PA only. Besides that I honestly do not know.
by scrumthing
Wed Dec 09, 2020 10:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Will IBM ever convert Perspectives to use the Rest API?
Replies: 6
Views: 949

Re: Will IBM ever convert Perspectives to use the Rest API?

Nope. That won't happen. Clear statement from IBM. Don't know what more I could add to that.
by scrumthing
Tue Dec 08, 2020 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Throttle and / or Block a users Rest API connection from third party apps.
Replies: 8
Views: 962

Re: Throttle and / or Block a users Rest API connection from third party apps.

I must admit I don't see how IBM could limit that. As lotsaram pointed out you could put anything in the header. If you have users with such bad intentions limit their general access to the database. Make sure they can only have 1 connection at a time. I must admit that right now I am not 100% sure ...
by scrumthing
Thu Nov 05, 2020 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementSecurity_: do not use it as prefix in a cube
Replies: 1
Views: 430

Re: }ElementSecurity_: do not use it as prefix in a cube

Thanks for the information Wim! Didn't know that. Fascinating. :-)
by scrumthing
Tue Nov 03, 2020 11:43 am
Forum: Enhancements
Topic: Auto-complete and Function picker for MDX in PAW/PAfE set editor
Replies: 3
Views: 2809

Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor

So you are going to reduce the stream of visitors to my MDX page ? :lol: IBM should just pay you to maintain that functionality within the set editor. :-D But that page is still the number one go to place for anything related to MDX for TM1. <-- Just wanted to add that appreciation! :-P And YES IBM...
by scrumthing
Thu Oct 15, 2020 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Admin access - Read Only
Replies: 2
Views: 994

Re: Admin access - Read Only

I think you can make the user part of the ADMIN group and use the read-only flag. That should work. But is a bit risky because some day IBM might realize that this does not make sense.
by scrumthing
Thu Oct 08, 2020 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 2284

Re: tm1py: count and list TM1 users

Thanks for sharing Wim! I have one idea which could increase performance, guess instead of checking all cubes for all groups of every user you could generate a list of groups with WRITE-access and then checking if a user is in one of those groups on the list. Had no time to try that out.
by scrumthing
Wed Oct 07, 2020 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 2284

Re: tm1py: count and list TM1 users

If you have several TM1 models, you could loop over ports. Here I assume the same username, password, SSL. You could get the instances listed at the admin server with a useful function and retrieve ssl and port from there. # get modules from TM1py.Utils import get_all_servers_from_adminhost from TM...