Hi Guys,
Can someone please suggest few real life use cases of using TM1py? Thanks!
Search found 28 matches
- Sat Jul 04, 2020 6:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1py Use Case
- Replies: 3
- Views: 1951
- Tue Jun 30, 2020 12:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Experience with PAW and its future prospects
- Replies: 13
- Views: 6598
Experience with PAW and its future prospects
Hi Everyone,
I want to get an insight on how the experience with PAW has been and what are the challenges that we still face? Do you think that we can completely get away with TM1 architect for development and adopt PAW? What is its future prospects? Thanks!
I want to get an insight on how the experience with PAW has been and what are the challenges that we still face? Do you think that we can completely get away with TM1 architect for development and adopt PAW? What is its future prospects? Thanks!
- Sun Jun 21, 2020 6:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1py and python integration with TM1
- Replies: 13
- Views: 7417
Re: TM1py and python integration with TM1
Thank you Everyone for your insights on this. I have been exploring TM1py samples and this has really given a better picture of python and TM1 integration and its capabilities.
Can you guys please suggest some use cases on TM1py which I can start working on that you have explored?
Can you guys please suggest some use cases on TM1py which I can start working on that you have explored?
- Mon Jun 15, 2020 6:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1py and python integration with TM1
- Replies: 13
- Views: 7417
TM1py and python integration with TM1
Hi Everyone, This is a general question regarding TM1 and python integration. I have recently started exploring TM1py library and based on sample codes what I could understand is that it is used for creating dim, subsets, cube , perform CRUD operations etc. What is unclear to me is that when we can ...
- Sun Jan 27, 2019 4:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset not found error
- Replies: 4
- Views: 2734
Re: Subset not found error
Thank you for your response. I am able to fix the issue by myself. The issue was that in prolog after destroying the temp view, it was not being created just after destroying it, but in the next else statement it was being created. That was resulting this error. I am on version 10.2.2. In PA, we hav...
- Fri Jan 25, 2019 12:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset not found error
- Replies: 4
- Views: 2734
Subset not found error
Hi, While executing a TI, I am getting the error as subset can not be found on the SubsetElementInsert function in prolog tab. The TI is creating a temporary subset. Creating in Prolog and deleting in the epilog then. The TI was working fine in DEV but when migrated to QA, it throws the error. Pleas...
- Sun Jan 20, 2019 9:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to use PAW
- Replies: 4
- Views: 2881
How to use PAW
Hi Everyone,
I have recently started using PAW in our Dev environment. Can you suggest some training resources or some use cases to use PAW to the best of its ability?
Thank You!
I have recently started using PAW in our Dev environment. Can you suggest some training resources or some use cases to use PAW to the best of its ability?
Thank You!
- Tue Jan 08, 2019 5:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: FileExists function returns 1 even when file is not present
- Replies: 2
- Views: 2223
FileExists function returns 1 even when file is not present
Hi,
I am facing a strange issue in TI where FileExists function returns 1 even when the file is not present in the specified directory. It returns 1 also when the file is present.
Not sure why it is happening and it is causing TI logic to fail. Please suggest.
Thanks!
I am facing a strange issue in TI where FileExists function returns 1 even when the file is not present in the specified directory. It returns 1 also when the file is present.
Not sure why it is happening and it is causing TI logic to fail. Please suggest.
Thanks!
- Thu Aug 16, 2018 5:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to know last cube updated time in TM1
- Replies: 7
- Views: 5345
How to know last cube updated time in TM1
Hi All, I have a scenario in which there is a cube export TI which executes every 15 min and places the file at the specific location. Now I need to enhance this logic in a way that the export TI should execute only when there is data change in the cube, not every 15 min as the former way is taking ...
- Wed Aug 08, 2018 9:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to deploy application in performance modaller
- Replies: 2
- Views: 2249
Re: Unable to deploy application in performance modaller
Thanks babytiger for your reply!
But in my case the issue is due to having different approval hierarchy dimension in both the applications and cube is shared in the 2 applications with different views.
I think that is the crux of the issue.
Will control dimension work in this case also?
But in my case the issue is due to having different approval hierarchy dimension in both the applications and cube is shared in the 2 applications with different views.
I think that is the crux of the issue.
Will control dimension work in this case also?
- Mon Aug 06, 2018 8:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to deploy application in performance modaller
- Replies: 2
- Views: 2249
Unable to deploy application in performance modaller
Hi All, There is an issue I am facing with the PM. When trying to deploy or validate one application, I get the error 'A different approval dimension 'Dimension A' is used in a Shared cube 'cube A' in application 'Application A.' Actually there are 2 applications e.g. A & B which use different a...
- Wed Jul 04, 2018 3:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Thanks! Got it.Wim Gielis wrote: ↑Tue Jul 03, 2018 6:20 am Indeed, TM1 caches data for faster retrieval later on, unless the cache is invalidated because you load a new value in a cell (that is part of the cache).
- Tue Jul 03, 2018 5:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Clever colleague you have 8-) The approach is correct. I think it’s logical that whenever you have a dynamic subset and you insert or delete an element, the dynamic character is gone. TM1 takes the set of elements that are in the subset at that time and continues working on it in a static way. If y...
- Mon Jun 18, 2018 7:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI for placing a file on SFTP server
- Replies: 4
- Views: 3905
Re: TI for placing a file on SFTP server
You could use a tool like WinSCP to do the transfer. You can write a script for that program that can be called from a TI process in the same way that you'd call a .bat file. I created the below batch file and executed it through TI. ********************* @ECHO On set _datetime=%date%_%time% set sf...
- Wed Jun 13, 2018 5:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Yes, I expect the dynamic subset to expand since the dimension is getting updated daily with elements. I think since I am creating a temporary view in prolog and deleting it in epilog, I believe this solution will keep the subset updated everyday when TI executes. Your opinion/ advice is highly app...
- Tue Jun 12, 2018 2:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Here is a possible helpful hint for dealing with MDX subsets going forward: if an MDX statement with filters does not return any members, then SubsetCreateByMDX will fail. One thing to do in order to guarantee the MDX statement will compile (assuming of course the statement is syntactically correct...
- Mon Jun 11, 2018 7:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Or would you expect the MDX definition of a dynamic subset to keep on expanding every time you make a change to it ? An alternative TI function is SubsetMDXSet. See: http://www.wimgielis.com/tm1_neatmdxtricks_EN.htm http://www.wimgielis.com/tm1_subsetcreatebymdxandsubsetmdxset_EN.htm Yes, I expect ...
- Sat Jun 09, 2018 3:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Ok, then I would do a bit of trial and error testing on 2 things: 1/ just create your subset with a simple while loop in your actual TI instead of bedrock 2/ just create the subset with MDX in your actual TI instead of bedrock - make static in the prolog as well 3 / leave the dimensions aith no sub...
- Wed Jun 06, 2018 3:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Why are you doing this to start with? As normal practice you would export leaf cells with null suppression turned on. Therefore for any dimension where you have no need to apply a filter (e.g. you want all leaf elements) then you simply do not assign a subset for these dimensions as there is no nee...
- Wed Jun 06, 2018 3:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process taking too much time to create a subset
- Replies: 18
- Views: 11358
Re: TI process taking too much time to create a subset
Assuming that your source view has skip consolidations enabled just dont create a subset and for that dimension leave the cube view with no subset assigned, it will default to just taking every element and due to having skip consolidations ticked it would only be n level elements. Thanks Declan for...