Search found 130 matches

by Emixam
Mon Aug 08, 2022 5:16 pm
Forum: Useful code, tips and tricks
Topic: Quickly promote or copy a PAW book
Replies: 4
Views: 1095

Re: Quickly promote or copy a PAW book

This is a life changer !! Thanks a lot for sharing
by Emixam
Thu Jul 14, 2022 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide TM1 Servers in Architect/Perspectives/PAW/PAX
Replies: 4
Views: 457

Re: Hide TM1 Servers in Architect/Perspectives/PAW/PAX

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 ...
by Emixam
Tue Jul 12, 2022 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add elements to a dimension from PAfE
Replies: 6
Views: 937

Re: Add elements to a dimension from PAfE

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.
by Emixam
Tue May 17, 2022 10:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Re-establish connection in a Quick Report
Replies: 2
Views: 1264

Re: Re-establish connection in a Quick Report

Adam wrote: Tue May 17, 2022 9:55 pm Did you rename the Excel file in Windows?
No I did not.
by Emixam
Tue May 17, 2022 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Re-establish connection in a Quick Report
Replies: 2
Views: 1264

Re-establish connection in a Quick Report

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...
by Emixam
Tue Apr 12, 2022 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding TM1 memory usage a bit more
Replies: 8
Views: 6793

Re: Understanding TM1 memory usage a bit more

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 ?
by Emixam
Mon Mar 28, 2022 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Data Spread for ADMIN
Replies: 12
Views: 1513

Re: Prevent Data Spread for ADMIN

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"...
by Emixam
Fri Mar 25, 2022 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to determine who is logged onto TM1 server in PA
Replies: 2
Views: 545

How to determine who is logged onto TM1 server in PA

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...
by Emixam
Thu Feb 17, 2022 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need to find the TI name with the extract file
Replies: 7
Views: 1475

Re: Need to find the TI name with the extract file

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...
by Emixam
Sat Nov 27, 2021 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How is }ElementSecurity_dimensionname create?
Replies: 4
Views: 16408

Re: How is }ElementSecurity_dimensionname create?

ElementSecurityPut function will check for the security cube, if it doesn't exists, it will create the security cube automatically.
by Emixam
Sat Nov 27, 2021 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How is }ElementSecurity_dimensionname create?
Replies: 4
Views: 16408

Re: How is }ElementSecurity_dimensionname create?

ElementSecurityPut in a TI is probably the easiest way.
by Emixam
Sat Nov 27, 2021 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web failed to login
Replies: 15
Views: 64360

Re: TM1 Web failed to login

It may sounds stupid but have you try to restart tm1web ?
by Emixam
Fri Oct 01, 2021 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules effect on a Data load
Replies: 6
Views: 4661

Re: Rules effect on a Data load

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...
by Emixam
Fri Aug 06, 2021 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publish MDX views
Replies: 8
Views: 5973

Re: Publish MDX views

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

Thanks !
by Emixam
Fri Aug 06, 2021 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publish MDX views
Replies: 8
Views: 5973

Re: Publish MDX views

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 ?
by Emixam
Mon Jul 26, 2021 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publish MDX views
Replies: 8
Views: 5973

Publish MDX views

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...
by Emixam
Wed Jun 23, 2021 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workspace - what can it do?
Replies: 21
Views: 14625

Re: PA Workspace - what can it do?

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 ?
by Emixam
Wed Jun 23, 2021 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workspace - what can it do?
Replies: 21
Views: 14625

Re: PA Workspace - what can it do?

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 ?
by Emixam
Tue May 18, 2021 8:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UseSSL
Replies: 6
Views: 19019

Re: UseSSL

Hello Wim,

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