Search found 28 matches

by amit_hhh
Sat Jul 04, 2020 6:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py Use Case
Replies: 3
Views: 1922

TM1py Use Case

Hi Guys,

Can someone please suggest few real life use cases of using TM1py? Thanks!
by amit_hhh
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: 6552

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!
by amit_hhh
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: 7309

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?
by amit_hhh
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: 7309

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 ...
by amit_hhh
Sun Jan 27, 2019 4:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found error
Replies: 4
Views: 2711

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...
by amit_hhh
Fri Jan 25, 2019 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset not found error
Replies: 4
Views: 2711

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...
by amit_hhh
Sun Jan 20, 2019 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use PAW
Replies: 4
Views: 2800

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!
by amit_hhh
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: 2178

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!
by amit_hhh
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: 5217

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 ...
by amit_hhh
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: 2173

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?
by amit_hhh
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: 2173

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...
by amit_hhh
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: 11026

Re: TI process taking too much time to create a subset

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).
Thanks! Got it.
by amit_hhh
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: 11026

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...
by amit_hhh
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: 3794

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...
by amit_hhh
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: 11026

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...
by amit_hhh
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: 11026

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...
by amit_hhh
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: 11026

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 ...
by amit_hhh
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: 11026

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...
by amit_hhh
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: 11026

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...
by amit_hhh
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: 11026

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...