TM1 Forum

hi guys, anyone know Is the effect of A and B the same when executed in TI process? A: DimensionSortOrder (cDim01, ‘ByName’, ‘Ascending’,‘ByHierarchy’, ‘Ascending’); B: CellPutS(‘BYNAME’, ‘}DimensionProperties’, cDim01, ‘SORTCOMPONENTSTYPE’); CellPutS(‘ASCENDING’, ‘}DimensionProperties’, cDim01, ‘SO...

With one potential "gotcha" proviso; it only applies to TI processes which are called from the chore itself. If you have to call (say) an upload process a variable number of times, and therefore use a loop to run a series of ExecuteProcess() functions, the commit will not happen until aft...

The difference is a commit step after each of the TIs, or only 1 commit after all TIs are finished. With one potential "gotcha" proviso; it only applies to TI processes which are called from the chore itself. If you have to call (say) an upload process a variable number of times, and ther...

Anyone know what is the difference between SingleCommit with MultipleCommit When i set a chore task?

I'm guessing you have Pulse installed? On install Pulse modifies or creates the tm1s-log.properties file to create this separate log file where GlobalCollection, File & System loggers are monitored. It is managed in a separate log file to not pollute the default tm1server.log file. Pulse monito...

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!

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...

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...

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...

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.

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

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.

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?

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...

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...

thank you very much

Anyone knows how to count the number of views opened by user in TM1?

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 ...

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 ...

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...