TM1 Forum

This is a life changer !! Thanks a lot for sharing

Maybe this can help: https://www.tm1forum.com/viewtopic.php?t=12142

I have a requirement to hide TM1 databases or Servers in Architect/Perspectives/PAW/PAX. Is there a way? We want to allow only users that are in a particular group to open the databases. It is not hiding a server but if you want to prevent users from accessing a TM1 databases, then you can use the ...

I would probably use the IBM Planning Analytics for Excel API.

https://ibm.github.io/paxapi/#introduction

Look at the TurboIntegrator Functions and REST API.

Adam wrote: ↑Tue May 17, 2022 9:55 pm Did you rename the Excel file in Windows?

No I did not.

Hello, I have a complex Quick Report and for some reason, it is no longer connected to TM1 database. I can see the Host, TM1 Server and cube name in cell A1, A2 & A3. I can also see the correct name in the Name Manager. Refresh doesn't do anything and I don't see my Quick Report in the Task Pane...

Hello,

Is there an easy formula to understand TM1 memory usage ?

I thought it should be something like:
Memory Used (}StatsForServer) = Total Memory Used (}StatsByCube) + Memory in Garbage (}StatsForServer)

Am I missing something ?

Hi Mark, We had a similar issue and we decided to use the }Capabilities cube. Not sure if it will work for Admin https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=configuration-capability-assignments Take a look at Allow Spreading . Also, not sure what you mean by "Web-application"...

Hi, With the good old Architect, we can simply right click -> Server Manager -> Select Client and see who is connected. For some reason I feel like there is a discrepancy between the users I'm seeing in Architect vs Workspace/Administration.. Am I crazy ? Which one is good ? Most of our users are on...

A couple methods come to mind: 1. look at the last modified date/time of the csv file and then search the tm1server.log file to see which TI process finished around that time 2. use the new processes.search_string_in_code function in TM1py 1.9.0 to look for the exact filename string in a TI process...

ElementSecurityPut function will check for the security cube, if it doesn't exists, it will create the security cube automatically.

ElementSecurityPut in a TI is probably the easiest way.

It may sounds stupid but have you try to restart tm1web ?

Hello, I had the same problem and I used the bedrock process to unload/load rule in my cube before I load my data https://github.com/cubewise-code/bedrock/blob/master/main/%7Dbedrock.cube.rule.manage.pro And then make sure to reprocess feeders at the end https://github.com/cubewise-code/bedrock/blob...

That's what I thought when I looked at the .xbv file.

Thanks !

Thanks everyone for your answers, it gives me a lot of idea. My next question would be; is there an "easy" way to convert MDX view to Native view? I know we can use tm1py to convert native view to MDX but I was wondering if the opposite is possible ?

I know that we can use PublishView to publish a named private view on the server but it only works with native view. Is there a way for a non-admin user to create a view in Workspace (MDX) and then publish it so another non-admin user can see it in PAX ? We would also want to use views created by no...

Mark RMBC wrote: ↑Wed Jun 23, 2021 3:45 pm My reading of IBM's response is that they regard it as a defect, and so do I!

Thanks for your answer Mark. So you already raised a ticket to IBM ?

I tried luizg2019 solution in PAW but apparently only users with ADMIN access can see the custom error message. Normal users (non-admin) only see "Process completed with messages". Am I missing something here ?

Hello Wim,

It may sounds stupid but in the screenshot it shows log from 2020-09-29. Maybe they changed the UseSSL parameter recently ?