Search found 140 matches

by Drg
Wed Apr 08, 2020 8:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: get a list of all groups the user is a member of. On the rules and without feeding.
Replies: 5
Views: 39

get a list of all groups the user is a member of. On the rules and without feeding.

Hello. Faced the non-trivial task of getting a list of user groups in the cube, then use these groups for analysis in access in other cubes (maybe some access groups intersect). In my attempts, I implemented two options, and both of them failed miserably: First option:  I created a group and placed ...
by Drg
Wed Feb 12, 2020 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monitoring User Logins
Replies: 21
Views: 1735

Re: Monitoring User Logins

Check }CubeProperties LOGGINING mustbe "YES"
by Drg
Tue Nov 19, 2019 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI
Replies: 2
Views: 284

Re: PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI

Hi all. If I understand the essence of the discussion correctly (correct me). Then I dare to please you that PAX can work with old CAFE forms that use url pmhub in their paramters. So with new forms in the parameters of which the URL of the PAW server is indicated. Therefore, I think this is a tempo...
by Drg
Thu Oct 31, 2019 7:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF function return undefined type Error
Replies: 9
Views: 6921

Re: IF function return undefined type Error

wow lotsaram a nice example of finding numbers in a string.
Thank you for your answer, he really confirmed that this is a pain and not a lack of my knowledge.
You are right the future for various api services.
by Drg
Wed Oct 30, 2019 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF function return undefined type Error
Replies: 9
Views: 6921

Re: IF function return undefined type Error

Thanks guys. I repair post. Can you also repair your post such that it becomes clear what you want to achieve ? What issues you are encountering ? What are variables / parameters / what is the data source ? Your exact code (where all typo's are corrected) And so on. Maybe if you do so, helpers can ...
by Drg
Mon Oct 28, 2019 10:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF function return undefined type Error
Replies: 9
Views: 6921

Re: IF function return undefined type Error

Thanks guys.
I repair post.
by Drg
Fri Oct 25, 2019 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF function return undefined type Error
Replies: 9
Views: 6921

IF function return undefined type Error

Hey brains. how you workaround this issue: Example1: proc = pProc; executeprocess( proc , IF(param_type @= 'N' , Numbr( param_val ) , param_val ) ); Example2: if( param_type @= 'N' ); out = Numbr( param_val ); ELSE; out = param_val; ENDIF; OR out = IF(1=1 , '1' , 1); so far a solution with multiple ...
by Drg
Fri Oct 25, 2019 11:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 20
Views: 13594

Re: RunProcess and Process Ends msg

Our manager in ibm temm us you need use rest api (pass them you QUEID) to retrive status execution process.

We still wait norml function retriving status in TI.
by Drg
Mon Sep 09, 2019 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

i create some litle script maybe any one his help: !only windows architecture! this script connect to AD(use tm1 service user) and create csv file with you fileds and filter this script support data transformation for any field formated as array separated ';'(Pdlmtr) to convert objectguid i use next...
by Drg
Mon Sep 09, 2019 6:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 12456

Re: How to make system appear "offline" - TM1Web login unavailable

Yep you right. MaximumLoginAttempts it's dynamic params you cn change it anytime.

integratedmode dinamic params only in PA not in TM1/. :|
by Drg
Fri Sep 06, 2019 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Picklists does not display for some ids
Replies: 2
Views: 1277

Re: Picklists does not display for some ids

Hi.

Write more details what you create picklist(by attribure or picklist cube), wich elements contain's dimension, wich permission uses for this dimension elements and etc...
by Drg
Thu Sep 05, 2019 6:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 12456

Re: How to make system appear "offline" - TM1Web login unavailable

lotsaram wrote:
Wed Sep 04, 2019 5:23 pm
This sounds useful! But does unload work for }ClientProperties?
We tested. YES :P
by Drg
Wed Sep 04, 2019 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 12456

Re: How to make system appear "offline" - TM1Web login unavailable

Hello We use for this 2 step: 1 tm1kill.exe to kick all users from model. 2 run process append to all users *LOCK* string to passworh hash. I would like to warn you against using this approach. if you delete the line * LOCK * and insert the old password hash, we encounter a problem, cellpuss uses th...
by Drg
Thu Aug 08, 2019 8:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

Thank you guys all! Especially Paul SImon, you were right that CAMID is a derivative of the client’s property. And how it is all arranged, I will now tell for inquiring minds and for people whose life has faced this situation. So, we begin: The structure of CAMid is as follows: CAM (<NAMESPACEID>: <...
by Drg
Wed Aug 07, 2019 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

macsir, paulsimon there is one important detail, we avoid associating users with AD or BI groups; therefore, we use Integration Mode 5 so that we have the opportunity to bind CAm users to groups created in TM1! You have already spent more time posting on this board than it would have taken you to m...
by Drg
Wed Aug 07, 2019 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

Hi You can import the AD Groups from Server Explorer. If you are using CAM then the Users are automatically created and assigned to Groups according to their AD profile when they first sign in, but the Groups must be created first. Not sure how many Groups you need to create. The standard default i...
by Drg
Wed Aug 07, 2019 6:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

What you need to do is assign users into a proper cognos group as you are using CAM. The way I am doing is using Powershell with ActiveDirectory module to read AD info and then using Cognos SDK with Java to manipulate users and groups. Obviously you need SDK license to do so. A very interesting app...
by Drg
Wed Aug 07, 2019 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

macsir, paulsimon

there is one important detail, we avoid associating users with AD or BI groups; therefore, we use Integration Mode 5 so that we have the opportunity to bind CAm users to groups created in TM1!
by Drg
Tue Aug 06, 2019 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

Re: automation import users from active directory

jim wood wrote:
Tue Aug 06, 2019 1:44 pm
Are you using CAM?
Yep
by Drg
Tue Aug 06, 2019 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 10722

automation import users from active directory

Hello colleagues. interested in the possibility of adding users from AD using any means of automation. The essence of the problem is that you need to import about 1000 users at once and assign them to tm1 groups (integration mode 5). Are there any thoughts on this subject? UPD: I’ll explain that use...