Search found 50 matches

by Niko
Fri Jan 12, 2024 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Instance starting up failure
Replies: 1
Views: 471

Tm1 Instance starting up failure

Hi everyone

someday my tm1 instance cannot restart again, normally it will start up within 10 minutes, but now it cannot restart and the tm1serverlog also stop to record start-up details at particular lines.

anyone has encountered this scenario before?


Thanks!
by Niko
Wed Sep 06, 2023 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1044

Re: Any tm1web log setting to get user access websheet info

I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first. If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported. I am surprised how pu...
by Niko
Sun Sep 03, 2023 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1044

Re: Any tm1web log setting to get user access websheet info

Here's another reference that may help: Using TM1 Web logging Edit: and another that looks useful Include user names and memory usage in TM1 Web logs The following information is included in logs: Timestamp Application and Active Form name Number of rows that were generated User name Current heap m...
by Niko
Sun Sep 03, 2023 12:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1044

Re: Any tm1web log setting to get user access websheet info

Here's a link to another thread on the topic. https://www.tm1forum.com/viewtopic.php?t=14808 The tm1web logs can produce this information such as who accessed what websheet and when. After changing the Log4j properties you'll then need to parse through the file to extract the information you need i...
by Niko
Sat Sep 02, 2023 4:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1044

Any tm1web log setting to get user access websheet info

I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
by Niko
Sun Apr 23, 2023 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone Know About TM1 Function RoundP
Replies: 2
Views: 881

Anyone Know About TM1 Function RoundP

Anyone Know how to use TM1 FUNCTION Roundp like excel round function, and is curious about different tm1 version will get different results:

Excel:
Round(0.615,2) =0.62
Round(0.625,2) =0.63

TM1 11.6
RoundP(0.615,2) =0.62
RoundP(0.625,2) =0.62

TM1 11.8
RoundP(0.615,2) =0.62
RoundP(0.625,2) =0.63
by Niko
Thu Mar 23, 2023 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: what is difference between TM1 9.1 and TM1 11.6
Replies: 6
Views: 976

Re: what is difference between TM1 9.1 and TM1 11.6

Wim Gielis wrote: Wed Mar 22, 2023 1:32 pm Are you talking about 15 years ago ?
Sorry,i don not know it was released 15 years ago,i want to know whether it can also be used to develop new module like cost budget / forecast analysis,etc.
by Niko
Wed Mar 22, 2023 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: what is difference between TM1 9.1 and TM1 11.6
Replies: 6
Views: 976

what is difference between TM1 9.1 and TM1 11.6

Anyone Know what is difference between IBM Cognos tm1 9.1 and IBM Cognos tm1 11.6 <PA2.0.9> Version ?
I mainly want to know usability , such as Websheet function / RULE function / TI function , Any aspects what is frequently-used?
by Niko
Mon Mar 13, 2023 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 how to copy private view from one user to another user?
Replies: 5
Views: 1047

Re: tm1 how to copy private view from one user to another user?

Someone with access to the TM1 data directory can copy over the objects (views and maybe subsets) from 1 folder to the other. The receiving user should log off and log on. Or create a script to copy files and remove the manual work. Or try to do it with the TM1 REST API. thank you very much. i thin...
by Niko
Mon Mar 13, 2023 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 how to copy private view from one user to another user?
Replies: 5
Views: 1047

tm1 how to copy private view from one user to another user?

anyone know how to copy private view from one user to another user within tm1/PA? background : A User create a private view through tm1web , then he want to share this view with others. I don't know if this is feasible: use publishview function to transfer private view to public , then generate a Vi...
by Niko
Mon Mar 13, 2023 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to count view opening times
Replies: 2
Views: 477

Re: How to count view opening times

:D thank you very much
by Niko
Sun Mar 12, 2023 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to count view opening times
Replies: 2
Views: 477

How to count view opening times

Anyone knows how to count the number of views opened by user in TM1?
by Niko
Sun Feb 05, 2023 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Can not register blob Error need help
Replies: 0
Views: 1342

TM1 Can not register blob Error need help

4955328 4964 50 Error Sun 7:25:10 PM TM1.Application Failed to load and register blob "Email Setting.xlsx_20170914133435.xlsx". 4955322 4964 50 Error Sun 7:25:10 PM TM1.Application Failed to load and register blob "Dimension CSV Data File Template.csv_20180423124004.csv". Anyone ...
by Niko
Sun Jan 15, 2023 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web global Homepage Setting for two instance
Replies: 2
Views: 871

Re: TM1web global Homepage Setting for two instance

In each TM1 instance, you can set a homepage per user in the }ClientSettings cube. After logging in the user will be redirected to whichever page you set here. Since the }ClientSettings cube is different per instance, but the same client can exist in both - this allows the same user to be directed ...
by Niko
Sat Jan 14, 2023 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web global Homepage Setting for two instance
Replies: 2
Views: 871

TM1web global Homepage Setting for two instance

Until now , i know how to set one instance TM1Web global homepage , because i know one tm1admin server can connect multiple instance , Suppose i have two instances , one called "FB" and another caller "FC" ,i want to set different homepage for these two instances. i try to set an...
by Niko
Fri Nov 11, 2022 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get Data from PowerBI
Replies: 1
Views: 670

Re: Get Data from PowerBI

Generally speaking,power bi is a bi visualization tool. Many people load data from csv/db/dw to power bi ,so the data is not stored in power bi ,so i don't understand the question you asked
by Niko
Tue Sep 06, 2022 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1299

Re: TM1web data writeback is slowly!

Hi, As Elessar has pointed out it could be locking that causes this, but I assume this wait happens every time? If so it is unlikely that you are in a wait state every time... unless it's a high user concurrency system and/or there are TIs scheduled to constantly run against the view in question. t...
by Niko
Sat Sep 03, 2022 7:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1299

Re: TM1web data writeback is slowly!

Hi, There can be 2 reasons of slow data entry: Somebody locked something, and you are in queue The cell you are writing data in overfeeds something (most probably, a large consolidation) Use tm1top (or PAW administration) to determine this. But, is it really data entry? You say that you wait 10 min...
by Niko
Sat Sep 03, 2022 12:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 2261

Re: Powershell Snd-MailMessage Fail to Attach File

Hi all, I have a functioning TI process to send email. I'm trying to modify it to attach file but failed. sFrom = 'TM1_Alert@123XYZ.com'; sTo1 = pRecipient1; sSubject =pSubject; sBody = pBody; sSMTPServer = 'smtp.123XYZ.com'; sAttachment = 'E:\System\ExtractFiles\Test.csv'; # build powershell comma...
by Niko
Sun Aug 28, 2022 2:16 pm
Forum: Useful code, tips and tricks
Topic: TM1 / Planning Analytics - MDX Reference Guide
Replies: 11
Views: 19371

Re: TM1 / Planning Analytics - MDX Reference Guide

after my test, TM1FILTERBYPATTERN the third parameter(attribute) can not support Chinese