Search found 2494 matches

by Wim Gielis
Thu Oct 15, 2020 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

Thanks for the feedback above, I will take it into account. For now, the latest code is here on Github: https://github.com/cubewise-code/tm1py/issues/393 Marius will have a look at it and add to tm1py what belongs there instead of being written in custom scripts. Please try it out and comment or con...
by Wim Gielis
Wed Oct 14, 2020 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Admin access - Read Only
Replies: 2
Views: 617

Re: Admin access - Read Only

I haven't tried it, but I think you can use your regular (non-admin) groups in the security. Then add the client(s) and mark them as Read_only in the }ClientProperties cube (for instance, enter a value of 1 there). I don't think there's an easy other way. Or, maybe, add the user to the SecurityAdmin...
by Wim Gielis
Thu Oct 08, 2020 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI not writing string value to consolidated element
Replies: 7
Views: 179

Re: TI not writing string value to consolidated element

Did you look at ViewExtractSkipConsolidatedStringsSet ?
by Wim Gielis
Thu Oct 08, 2020 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

Newest version, it's becoming an invaluable tool ;-) Next step is to incorporate the code of Scrumthing to avoid hardcoded port numbers. Also, get the }TM1_DefaultDisplayValue instead of }Clients principal element names. Feel free to join this and turn it into an even more useful script ! from TM1py...
by Wim Gielis
Wed Oct 07, 2020 8:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

Thanks, I will have a look at that one.
The use case for my script is an investigation at one of our customers, where they have 5 TM1 models, 4 of which are actively used.
So I entered the port numbers in a list to know which ones to query.
by Wim Gielis
Tue Oct 06, 2020 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

If I want to retrieve the }TM1_DefaultDisplayValue, is it already coded as one of the attributes that we can retrieve through tm1py ? I thought that I would use the Name property, giving me the client ID (element name in }Clients), and Friendly name would give me this alias. But this does not appear...
by Wim Gielis
Tue Oct 06, 2020 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

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. from TM1py import TM1Service from TM1py.Objects import User ADDRESS = "localhost" USER = "Admin" PWD = "..." SSL = True ports = [8001, 8009, 8015, 8016] for port in ports: tm1 = TM1Service(addr...
by Wim Gielis
Mon Oct 05, 2020 9:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for elements that exist in both subsets
Replies: 4
Views: 147

Re: MDX for elements that exist in both subsets

Actually, why not having less of these, and avoiding syntax headaches ? This works too:

Code: Select all

INTERSECT(
    [DimensionName].[SubsetName1],
    [DimensionName].[SubsetName2] )
by Wim Gielis
Mon Oct 05, 2020 9:25 am
Forum: Useful code, tips and tricks
Topic: PAfE not calculating and returning #VALUE!
Replies: 1
Views: 120

Re: PAfE not calculating and returning #VALUE!

Hi George, Thanks. For this exercise, I tend to use code from the late Chip Pearson: http://www.cpearson.com/excel/findall.aspx There is a procedure called 'FindAllOnWorksheets'. After that you can simply loop over any results returned. It's good to add "xlFormulas2" in the Find procedure, though, l...
by Wim Gielis
Sun Oct 04, 2020 9:37 am
Forum: Bugs
Topic: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash
Replies: 8
Views: 11990

Re: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

I am developing TM1 models for the last 13 years (if we wait 4 days). I have never ever used dimension worksheets, rules sheets, TI code sheets or whatever they would be called, in Excel. Can someone explain to me the relevance and benefit(s) they bring ? Then I can have a better idea on this. Aren'...
by Wim Gielis
Fri Oct 02, 2020 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

Updated coding. from TM1py import TM1Service from TM1py.Objects import User ADDRESS = "localhost" PORT = 8001 USER = "Wim" PWD = "" SSL = False tm1 = TM1Service(address=ADDRESS, port=PORT, user=USER, password=PWD, ssl=SSL) admin_users = [] full_admin_users = [] security_admin_users = [] data_admin_u...
by Wim Gielis
Fri Oct 02, 2020 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

- If I understand your code correctly you are only checking for Admins but not for OperationsAdmin, etc. Exactly. I am extending the code. - to get the read-only users querying the only client properties cube is the only way. IBM should add that flag to the users-requests. Agreed - I personally do ...
by Wim Gielis
Fri Oct 02, 2020 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

Re: tm1py: count and list TM1 users

Hi Christoph,

Thanks. I forgot to mension that I used a snippet of your code regarding the ReadOnly property.

I will comment later on the other feedback, thanks.
by Wim Gielis
Thu Oct 01, 2020 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py: count and list TM1 users
Replies: 13
Views: 1138

tm1py: count and list TM1 users

Hi all, For some time now I use a TI process to count TM1 users, in the following ways: - Number of Admin users - Number of Write users - Number of Read users - Number of Disabled users - Number of non-admin users - Number of read only users I decided to rewrite the process using tm1py. I succeeded ...
by Wim Gielis
Thu Oct 01, 2020 10:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

Could be possible, I don't have such an installation for testing.
by Wim Gielis
Thu Oct 01, 2020 3:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

No idea MarenC. But in my generic TI process, I count them separately. Up to the sales colleagues to use the information or not.
I'm planning on rewriting this TI process in tm1py, curious to see how I will advance (or not).
by Wim Gielis
Wed Sep 30, 2020 9:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

For me it works. Here are screenshots.
PAL version 11.6.0.14
02.png
02.png (6.36 KiB) Viewed 282 times
01.png
01.png (36.63 KiB) Viewed 282 times
03.png
03.png (5.99 KiB) Viewed 282 times