Search found 24 matches

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

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

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

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

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

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

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

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 appro...
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: 2627

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

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

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

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

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

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

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

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

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...
by amit_hhh
Tue Jun 05, 2018 6:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 2627

TI process taking too much time to create a subset

Hi All, I have created a TI to export cube data. In prolog, I am creating the source cube view by creating subsets for different dimensions of the cube. There is a dimension A whose .dim file size is around 4 MB. This means it has millions of records since the dimension is updated daily from databas...
by amit_hhh
Tue May 29, 2018 2:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI for placing a file on SFTP server
Replies: 4
Views: 878

TI for placing a file on SFTP server

Hi All, I am trying to create a TI which will place a text file from data directory to an external SFTP server to be used by Database team. The database team has provided the host name, port number, file protocol(SFTP), userid/pwd to connect to the location to place the file. Can someone please guid...
by amit_hhh
Sun Mar 18, 2018 2:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add validation error message for users?
Replies: 3
Views: 782

How to add validation error message for users?

Hello, I have 2 dimensions which are used in different cubes to build model, let's name them A & B. The elements of these dimensions are selected through TM1 web when users are doing planning. I have to implement a logic in such a way that while selecting the elements, one element of dimension B can...
by amit_hhh
Mon Oct 16, 2017 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is the future of Cognos TM1/PA?
Replies: 1
Views: 717

What is the future of Cognos TM1/PA?

Hello Everyone, I recently have started learning and working in Cognos TM1. Previously I was working in Cognos EP and BI for around 4 years. I want to know the scope of TM1 in future. What else should I learn along with TM1 to be an expert in this field or switching to data science makes more sense?...