Search found 138 matches

by Emixam
Thu Jan 04, 2024 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Dependency Query
Replies: 2
Views: 708

Re: Rule Dependency Query

Hi, I've never done any testing but during server startup, can you see the cube dependency being created ? 12345 [] INFO 1900-01-01 00:00:00:00 TM1.Cube.Dependency Adding cube dependency: Cube 'Cube A' depends on cube 'Cube B' You could also use log4j.logger.TM1.Cube.Dependency=DEBUG in tm1s-log.pro...
by Emixam
Fri Sep 01, 2023 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 instance without TI (TM1 REST API only)
Replies: 1
Views: 704

TM1 instance without TI (TM1 REST API only)

Hello,
With TM1 REST API becoming more and more popular, I was wondering if anybody ever created a model using only the TM1 REST API without any TI ? And what about only using TM1py ?

Thanks and have a good day !
by Emixam
Sat Feb 04, 2023 11:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why transaction logs are only available in Architect ?
Replies: 3
Views: 1107

Re: Why transaction logs are only available in Architect ?

Thanks lotsaram. This is our plan but I was more curious about why it is not available in Workspace/Arc and why querying transaction from TM1py seems to be slower than Architect.
by Emixam
Thu Feb 02, 2023 10:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why transaction logs are only available in Architect ?
Replies: 3
Views: 1107

Why transaction logs are only available in Architect ?

Hello, As far as I know, we can only query transaction log from the good old Architect, TM1 Rest API (TM1py) or directly from the tm1s files. Is there a reason why web app like Workspace or Arc haven't yet provided such functionality ? We are looking to implement a solution to expose transaction log...
by Emixam
Thu Oct 27, 2022 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to write value in a cube with active drill through
Replies: 3
Views: 1903

Re: Unable to write value in a cube with active drill through

For those who are interested, the issue was with the subset creation. In my drill process, I changed the subsets creation from MDX to manually loop on elements and SubsetElementInsert. Everything works perfectly now !

Out of curiosity, anybody knows what could be the reason ?
by Emixam
Tue Oct 25, 2022 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to write value in a cube with active drill through
Replies: 3
Views: 1903

Re: Unable to write value in a cube with active drill through

Update: The script also crash when I try to get_value in 'My Cube' and there is a view open using the drill through functionality TM1py.Exceptions.Exceptions.TM1pyRestException: Text: '{"error":{"code":"501","message":"\"Current Index\" : member...
by Emixam
Tue Oct 25, 2022 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to write value in a cube with active drill through
Replies: 3
Views: 1903

Unable to write value in a cube with active drill through

Hello I have a tm1py script to query log delta and load the result into a target cube. I got inspired by this sample TM1_MEASURE_LOG = ['User','TimeStamp','OldValue','NewValue'] with TM1Service(**config) as tm1: cube_source = 'My Cube' cube_target = '}Log_My Cube' tm1.server.initialize_transaction_l...
by Emixam
Tue Oct 18, 2022 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: rule line error runtime error :circular reference, evaluation stack
Replies: 11
Views: 1700

Re: rule line error runtime error :circular reference, evaluation stack

People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum.
by Emixam
Mon Aug 08, 2022 5:16 pm
Forum: Useful code, tips and tricks
Topic: Quickly promote or copy a PAW book
Replies: 8
Views: 13446

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

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

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

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

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

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

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

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

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

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

Re: How is }ElementSecurity_dimensionname create?

ElementSecurityPut in a TI is probably the easiest way.