Search found 15 matches

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

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: 14
Views: 1110

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: 14
Views: 1110

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: 14
Views: 1110

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: 14
Views: 1110

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: 14
Views: 1110

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: 14
Views: 1110

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: 14
Views: 1110

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

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

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

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

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

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

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

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 530 times