TM1 Forum

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

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

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?

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

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

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

Thanks for the replies guys

I will go with using TI code to create the subset.

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

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

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.

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

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.

this may well help you:

http://www.tm1forum.com/viewtopic.php?f ... and#p21281

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

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

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