Search found 158 matches

by Drg
Sun Mar 03, 2024 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Drill process return handle
Replies: 3
Views: 173

Re: }Drill process return handle

yep Wim thanks
by Drg
Sun Mar 03, 2024 12:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 344

Re: RAM and PVU licensing

Hello yes we keep 20-25% RAM free on prod server(local) bacause if you get some memory leak server may crash realy qick and get all you model on this server. :)
by Drg
Sat Mar 02, 2024 11:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Drill process return handle
Replies: 3
Views: 173

}Drill process return handle

Hello all. Has anyone encountered returning data from a drill process where the source is specified as a csv file? The official doc is silent on this matter, but there are still some references that the function is reserved and works through the rest api. So maybe I’m doing something wrong or it doe...
by Drg
Tue Sep 19, 2023 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: notepad ++ plugin
Replies: 0
Views: 8635

notepad ++ plugin

worked plugin for hightlight formulas, functions.
by Drg
Sat Sep 16, 2023 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW using the Podman container engine
Replies: 1
Views: 1225

Re: PAW using the Podman container engine

Hello. Me install paw 2.0.73 on red os(linux) Instructions: 1.Install podman yum install -y podman systemctl enable --now podman.service systemctl enable --now podman.socket usermod -aG root $USERNAME$ chmod g+rx /run/podman 2.Install podman-docker translater dnf install -y podman-docker 4.Install P...
by Drg
Thu Sep 14, 2023 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Vs Google Big Query - One Person's Experience
Replies: 5
Views: 2532

Re: ODBCOutput Vs Google Big Query - One Person's Experience

Alan, I'm not a BQ expert, but have you tried this syntax? Or is this what you meant by batching inserts? It is indeed what I meant. INSERT INTO `your_project_id.your_dataset_id.your_table_id` (column1, column2, column3) VALUES ('value1', 'value2', 'value3'), ('value4', 'value5', 'value6'), ('value...
by Drg
Thu Sep 14, 2023 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: paw Lifecycle Management limit 100
Replies: 0
Views: 8719

paw Lifecycle Management limit 100

Hello all. We have 2 server PAW and ned to migrate from PAW1 -> PAW2 some books use lifecycle managment. In our solution we have 150 books linked between each. (parent book have link to level 1 books, level 1 have link to parent and to level 2 ...) and wheen i try to transfer separated package (75 i...
by Drg
Mon May 17, 2021 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 30
Views: 19533

Re: Local Backup

I'll add my five cents.
Not all types of archives support Unicode in filenames(yes objects may names as chines or russian character etc//) in my practice, it is best to use zip? but not for model folders with persistence feeders :) .
by Drg
Mon May 10, 2021 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Mode 2 - External AD
Replies: 2
Views: 3619

Re: PAW Mode 2 - External AD

Hello. I will not say that I am an expert in this area. but I presume that the tm1 server must have access to the company's ldap server. Take server pav must have access to the server tm1. Authorization occurs by redirecting a request from the pav server to the tm1 server from the tm1 server to the ...
by Drg
Thu May 06, 2021 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it safe to overwrite }Clients alias }TM1_DefaultDisplayValue?
Replies: 3
Views: 3201

Re: Is it safe to overwrite }Clients alias }TM1_DefaultDisplayValue?

That's not really the case guys! :evil: in service 10 2 2, this alim is updated when the user reconciles the slices in pmpsvc applications. At the beginning of the process, your alias will be there, and at the end of the process, this alias will be overwritten with what comes from the bi. As far as ...
by Drg
Mon May 04, 2020 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server registering with Admin server
Replies: 13
Views: 6011

Re: TM1 server registering with Admin server

A stupid question but you do have a SaveData chore executing before your batch file takes down the TM1 service, right? If you don't it will save the data during the takedown, which can take a while if the service has been up for a long time. Maybe this is why it works fine with the extra timeout. I...
by Drg
Mon May 04, 2020 4:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cellsecurity rules
Replies: 2
Views: 2447

Re: Cellsecurity rules

Wow Wim thats great idea.

never before thought about the string comparison mechanism, but it is most likely bitwise.
If you want, you can tell the Choate for the properties of the cube on the last screen, I'm not quite familiar with the method of their work.
by Drg
Mon May 04, 2020 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Single Sign On problem
Replies: 4
Views: 5440

Re: Single Sign On problem

we configure this but its more pain to do this(ower 50 steps to correctlu work on all clients).
We active use our IBM support to correctly configure this with ssl and sso.
Think you need to folow on IBM customer supports.
by Drg
Mon May 04, 2020 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API Logout
Replies: 5
Views: 4957

Re: TM1 REST API Logout

Hi. you have a 2 variante to close session correctly. 1 if you need close current session use logout https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/dg_tm1_odata_auth.html 2 if you need close any user session /api/v1/Threads('thread№')/tm1.Cancel...
by Drg
Mon May 04, 2020 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 8363

Re: TM1+CAM Security: see what any user would see

We ahve test domain account. arhitect, browser etc "run as different user" mode. for excel we create litle batch file to run diff user Creat *.lnk file C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command "&{start-process \"$env:windir\system32\RunDll32.exe\&quo...
by Drg
Mon May 04, 2020 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server registering with Admin server
Replies: 13
Views: 6011

Re: TM1 server registering with Admin server

So the model doesn’t appear on the admin host at all, or does it appear during a manual start? For reliability, try on both servers (the host and model server) to start the tm1 configurator and re-save the model with the creation of cryptography. and restart the admin host with saving the config fil...
by Drg
Fri Apr 10, 2020 7:09 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: 7
Views: 3664

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

Thanks you all.

Yuri that this my second variant but calculatintg time kill all idea.

Yep mayme this task resolving only TI.
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: 7
Views: 3664

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

Re: Monitoring User Logins

Check }CubeProperties LOGGINING mustbe "YES"