Search found 16 matches

by prameson
Thu Feb 06, 2020 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI / Runprocess issues
Replies: 7
Views: 1009

Re: TM1RunTI / Runprocess issues

Thanks Everyone for your help. I have managed to solve the problem using the following steps: 1. Changed the ExecuteProcess comands that I used for the View create sub process calls to RunProcess comands 2. Removed the ZeroOut view creation from the View create sub process and put it in the prolog o...
by prameson
Wed Feb 05, 2020 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI / Runprocess issues
Replies: 7
Views: 1009

Re: TM1RunTI / Runprocess issues

You are creating a view to zero out each year which puts a write lock on that view. Now, before that process has a chance to finish and thus release the lock, you are calling a sub-process to load to the same area that the original process has a write lock for. Do you understand? What I am saying i...
by prameson
Wed Feb 05, 2020 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI / Runprocess issues
Replies: 7
Views: 1009

Re: TM1RunTI / Runprocess issues

Thanks Tom

I'm creating separate zero out views for each year and then zeroing out in the prolog of the control process. The epilog then calls the DataLoad process.

If I create the views as temporary then surely they won't exist when I call the load processes using RunProcess?
by prameson
Wed Feb 05, 2020 12:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI / Runprocess issues
Replies: 7
Views: 1009

TM1RunTI / Runprocess issues

Hi All We recently upgraded to PA (we are now on 2.08) and to Security Mode 3 (from 2) to simplify user login are having some issues with some processes using TM1RunTI (which worked fine in the previous versions).  We created an admin user account with the name of the Server service account in order...
by prameson
Thu Jan 16, 2020 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using RunTI with Integrated Security
Replies: 1
Views: 431

Using RunTI with Integrated Security

We have recently upgraded to Planning Analytics PAx from Perspectives. We used to use IntegratedSecurityMode 2 and users had the "Use Integrated Login" checkbox in the Perspectives TM1 Options window checked to make login seamless. Since moving to PAx we have used IntegratedSecurityMode 3 in order t...
by prameson
Wed Jun 07, 2017 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1top SSL Cognos Express v10.2
Replies: 2
Views: 1559

Tm1top SSL Cognos Express v10.2

Hi All I know this has come up before, but we are still unable to find a resolution to getting TM1top working since the release of new SSL certificates. We are using Express 10.2. I have copied all TM1top files to a separate directory as well as the new SSL directory. Firstly, should the SSL files b...
by prameson
Mon May 19, 2014 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Subset using MDX based on another dimension
Replies: 4
Views: 2984

Re: Create Subset using MDX based on another dimension

Thanks for the replies guys

I will go with using TI code to create the subset.
by prameson
Mon May 19, 2014 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Subset using MDX based on another dimension
Replies: 4
Views: 2984

Re: Create Subset using MDX based on another dimension

Thanks Jim, That is an option but this is part of what will be quite a large chore that will run quite frequently so if there is a cleaner (quicker?) way of creating this subset using MDX I would like to find it. I'm really not sure if this is fairly straight forward and I'm just messing up the synt...
by prameson
Mon May 19, 2014 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Subset using MDX based on another dimension
Replies: 4
Views: 2984

Create Subset using MDX based on another dimension

Hi All There are a few posts on this topic but none of them has helped me solve this issue. I have 2 dimensions used in different cubes: Account MIDI_Accounts MIDI_Accounts contains a subset of Accounts (which have a source attribute of 'U') as well as other Accounts not in the Account dimension (wi...
by prameson
Wed Nov 23, 2011 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewSuppressZeroesSet when creating a View in TI
Replies: 2
Views: 1945

Re: ViewSuppressZeroesSet when creating a View in TI

Many thanks.

Your point 3 answered my question and confirmed my suspicion as to how the zero suppress works with a view extract.

I managed to solve the problem by creating and using a consolidation of the 3 elements.
by prameson
Thu Nov 17, 2011 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewSuppressZeroesSet when creating a View in TI
Replies: 2
Views: 1945

ViewSuppressZeroesSet when creating a View in TI

Hi all Just a quick query about the way ViewSuppressZeroesSet works when creating a View using TI. Does it zero out each record passed or does it work in the same way as a zero suppress on a slice works - i.e. is it only zeroing out rows and columns which contain all zeros? The query arises as I'm t...
by prameson
Tue Jul 05, 2011 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Excel and change elements in dimensions
Replies: 2
Views: 807

Re: Using Excel and change elements in dimensions

if you're looking to add an element to the dimension (as opposed to just change the selection), then you may find this helpful:

http://www.tm1forum.com/viewtopic.php?p=10127

They are referring to websheets, but the process is the same for Excel.
by prameson
Fri May 13, 2011 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recreate Specific Hierarchies in a dimension
Replies: 5
Views: 2057

Re: Recreate Specific Hierarchies in a dimension

Thanks Martin. The tool will give me the hierarchy name so yes, I can just select all parents in that hierarchy and de-couple them from their children. Then pull in the data from the hierarchy tool, re-build the hierarchy and probably best to create a check consol to contain any parents that no long...
by prameson
Fri May 13, 2011 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recreate Specific Hierarchies in a dimension
Replies: 5
Views: 2057

Re: Recreate Specific Hierarchies in a dimension

Why not? If this new tool is supposed to hold ALL your hierarchical metadata then why can't you rebuild all the hierarchies each time the process is run. Why muck everything up if there is an easier answer. That would be one way of doing it, but I have been asked to give it the flexibility of being...
by prameson
Thu May 12, 2011 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recreate Specific Hierarchies in a dimension
Replies: 5
Views: 2057

Recreate Specific Hierarchies in a dimension

Hi All We have a non-TM1 web based process for managing all hierarchies. We want to be able to take data from this database and use it to re-create hierarchies in TM1 dimensions. The data will be hierarchy rather than dimension specific, so it will be possible that only one of the (possibly many) hi...