Search found 138 matches
- 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...
- 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 !
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 !
- 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.
- 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...
- 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 ?
Out of curiosity, anybody knows what could be the reason ?
- 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...
- 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...
- 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.
- 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
- Tue Jul 26, 2022 3:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Font Size between Citrix Workspace and Windows Desktop
- Replies: 3
- Views: 1816
- 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 ...
- 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.
https://ibm.github.io/paxapi/#introduction
Look at the TurboIntegrator Functions and REST API.
- 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
- 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...
- 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 ?
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 ?
- 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"...
- 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...
- 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...
- 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.
- 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.