Search found 20 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?...
by amit_hhh
Mon Oct 09, 2017 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help to create TI process to copy data
Replies: 5
Views: 771

Need help to create TI process to copy data

Hello All, I am new to Cognos TM1 and have to create a TI process to copy data for specific fields from a particular month of a year for Version 1 to all the months of next year for version 2. e.g. Data for Nov-16 for version 1 is to be copied to months from Jan-17 to Dec-17 for version 2 of the sam...
by amit_hhh
Fri Sep 22, 2017 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to launch TM1 Perspective
Replies: 4
Views: 705

Re: Unable to launch TM1 Perspective

gtonkin wrote:
Fri Sep 22, 2017 4:14 am
I had this issue with a client a while ago and sent my colleague this link to try and resolve. He seemed to fix it but not sure exactly what he did in the end. Have a read and see if any of the suggestions work for you.
Thanks!!! It worked.
by amit_hhh
Fri Sep 22, 2017 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to launch TM1 Perspective
Replies: 4
Views: 705

Re: Unable to launch TM1 Perspective

Thanks Alan for looking into this. But the issue still persists. Even after reinstalling the excel, I am getting the same error.
by amit_hhh
Thu Sep 21, 2017 4:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to launch TM1 Perspective
Replies: 4
Views: 705

Unable to launch TM1 Perspective

I recently have installed TM1 v 10.1.1 on my machine, but while opening the perspective, I am getting below message. Can someone please help?
Error.png
Error.png (52.68 KiB) Viewed 705 times