Search found 127 matches

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: 17
Views: 508

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: 17
Views: 508

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: 17
Views: 508

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: 17
Views: 508

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: 17
Views: 508

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: 17
Views: 508

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: 17
Views: 508

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...
by Drg
Tue Jul 30, 2019 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 242

Re: Server crashing with "Evalution stack overflow"

Hi.

1 yes - you model start longest
2 try clear data in cubes and restart on small data sets
3 yep if you do not touch 1 point

Maybe you have a feeders from leaf level to parent (leaf+1 level) recursion ...???
by Drg
Wed Jul 24, 2019 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 471

Re: Reclaiming disk space after PAW upgrade

gtonkin wrote:
Tue Jul 23, 2019 7:34 am
The only way I have cleaned up stubborn containers in the past has been a sledge-hammer approach i.e. docker-ci-zap
Unfortunately this removes ALL containers in the WindowsFilters folder but is useful when you have broken your PAW beyond repair.
Oh nice, thx i try it!
by Drg
Tue Jul 23, 2019 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 471

Re: Reclaiming disk space after PAW upgrade

We are faced with such a situation that the docker does not see containers that have remained a rudiment from previous versions. The only solution that I found is to completely delete the folder manually using utilities. docker creates files that cannot be deleted using standard windows methods. Any...
by Drg
Fri Jul 19, 2019 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 5
Views: 764

Re: PAX has blank task pane

Hi, show us screenshot and config connection PAX :shock:
by Drg
Thu Jul 18, 2019 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 872

Re: Slow Login in Architect

Some time ago, we also noticed the problem of the slow work of Architect (but here I’m not only talking about logging) that was caused by the failure of several processes creating subsets and the views of ~ 100 views for each cube.

maybe at some point you have a lot of unnecessary subsets or views?
by Drg
Thu Jul 18, 2019 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Occasionally stuck making ODBC connection
Replies: 5
Views: 228

Re: Occasionally stuck making ODBC connection

I think you need more information from tm1 logs: TM1.ODBC TM1.Sql TM1.SQLAPI TM1.Lock TM1.Lock.Exception see more here: https://www.tm1forum.com/viewtopic.php?t=12170 This example how create extended logs to different file: #tm1s-log.properties log4j.logger.TM1.Lock.Exception=DEBUG, LOCKS log4j.appe...
by Drg
Wed Jul 17, 2019 1:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 WEB context area
Replies: 3
Views: 361

Re: TM1 WEB context area

you can change class

Code: Select all

.tm1webHidden {
display: none !important; <--change this 
}
In flat.css on default themes(flat)

BUT i do not find how show horizontal scroll tab. Maybe some one skilled find the solution.
by Drg
Wed Jul 17, 2019 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create temp view and open them by returnviewhandle
Replies: 3
Views: 233

Create temp view and open them by returnviewhandle

At someone it turned out to create a temporary view and subsets and return them in }dril process by returnviewhandlel? Or is it impossible? My research resulted in the fact that if you use temporary subsets or views, the view is deleted before the is actually returned. But In fact, the returnviewhan...
by Drg
Wed Jul 17, 2019 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 425

Re: PowerShell issue

but it also brings a little pain with quotes and double quotes Indeed, don't you close the double quotes in the code ? Oh Yes, I hurried with the answer so I missed them [corrected] But I thought the essence of the question is that you don’t know how to execute the scripts. However, I was talking a...
by Drg
Tue Jul 16, 2019 6:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 425

Re: PowerShell issue

Hi all i use next construction tu run powershell comands. powershell -command "& { <write your script here> } PSscript='powershell -command "& {set-content -path '|Filepath|' -value '|exportstring|' }"'; EXECUTECOMMAND( PSscript , 1 ); this saves us situations when the script needs to be given permi...
by Drg
Thu Jul 04, 2019 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any risk to copy Cell Annotation values ?
Replies: 2
Views: 246

Re: Any risk to copy Cell Annotation values ?

from experience I will say that CELLPUTS uses the Trim function for Value, so if your comments start / end with separator characters, then there is a big chance to get something that you did not expect.
Otherwise, this is a regular cube with strings.
by Drg
Thu Jul 04, 2019 6:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Programmatically Update Websheets to TM1 Web
Replies: 15
Views: 3151

Re: Programmatically Update Websheets to TM1 Web

We use the following strategy to change the destination server: We unpack the excel file and use the powershell scripts to change the server name in all files. We also use similar logic for the BI contentstore exel. There is one thing, but namely if you have active buttons in the forms of prospects,...
by Drg
Thu Jul 04, 2019 5:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: subset MDX works in one cube view, not in another
Replies: 3
Views: 138

Re: PAW: subset MDX works in one cube view, not in another

Hi
Perhaps the problem is that the PAW does not know how to currentmeber?
As far as I remember for the operation of this filter, the [Accounts Master] element should be in the context of the view.