Search found 14 matches
- Fri Jul 08, 2016 8:33 am
- Forum: Useful code, tips and tricks
- Topic: Clear TM1 Formulae from Excel
- Replies: 15
- Views: 47329
Re: Clear TM1 Formulae from Excel
Thank so much for your help.... much appreciated.
- Fri Jun 24, 2016 11:59 am
- Forum: Useful code, tips and tricks
- Topic: Clear TM1 Formulae from Excel
- Replies: 15
- Views: 47329
Re: Clear TM1 Formulae from Excel
Hello , Does anyone know how to combine Steve Vincent's code with Alan Kirk's speed upgrade? I am using Steve's code but it is very slow on a large workbook. I normally use Alan Zapper add on, but i would like to add a button on this spreadsheet so the user can hardcore the formula themselves. Appre...
- Wed Mar 30, 2016 8:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Syntax
- Replies: 2
- Views: 2261
Re: MDX Syntax
Thank you very much for your help, worked perfectly
Cheers
Cheers
- Tue Mar 29, 2016 4:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Syntax
- Replies: 2
- Views: 2261
MDX Syntax
Hello everyone I have created a subset using SubsetCreateByMdx - I now want to change the parent selection to run from the Variable on the Process ( instead of being hard coded) SubsetCreatebyMDX('CostCDetailReport', '{TM1SORT( {TM1FILTERBYLEVEL( {DESCENDANTS([r_Cost_Centre].[200] )}, 0)}, ASC)} ' )...
- Tue Jan 12, 2016 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools VBA update
- Replies: 3
- Views: 3744
Re: TM1 Tools VBA update
Thanks you very much lotsaram
This make perfect sense now that someone has spelt if out to me.
Thank you for your help
This make perfect sense now that someone has spelt if out to me.
Thank you for your help
- Tue Jan 12, 2016 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools VBA update
- Replies: 3
- Views: 3744
TM1 Tools VBA update
Hello Everyone I have been using the TM1 tools http://www.tm1forum.com/viewtopic.php?f=21&t=2515 that someone with far more skill than me has written. I have then copied part of the code and put them into my VBA. This has allowed me to run numerous TM1 processes from inside VBA. This has been gr...
- Mon Jun 15, 2015 10:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 VBA param
- Replies: 4
- Views: 4800
TM1 VBA param
Hello everyone, I hope you can help. I have a VBA code that runs a TM1 process. before i have only had one parameter so just used a simple code like this. pParam = Range("B2").Value bCheck = ExcecuteProcess(sServer, sProcess, pParam) however i now have two parameters, so i tried this, pPar...
- Wed Mar 18, 2015 1:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security - default view
- Replies: 7
- Views: 5709
Re: Security - default view
Thanks for the reply I am using perspective, using cognos express so how can i set up a universal view with element security say i have dimension of cost center - with 1 hierarchy of "total cost center" and then three cost centers as childs i have three users, each only to have access to t...
- Wed Mar 18, 2015 11:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security - default view
- Replies: 7
- Views: 5709
Re: Security - default view
Hello
I did try that but it still doesn't let me
it come up and says "default: No Read Access to elements, cannot view.
as soon as i change default view to being facilities then it works.
I did try that but it still doesn't let me
it come up and says "default: No Read Access to elements, cannot view.
as soon as i change default view to being facilities then it works.
- Wed Mar 18, 2015 9:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security - default view
- Replies: 7
- Views: 5709
Security - default view
Hello Everyone, I hope that you can all help I have a cube which shows the group P+L I have a default view which is the top hierarchy for all dimensions - for example Total cost centers in the cost center dimension This is perfect for most people using the system. however i have to let someone (my m...
- Thu Jan 22, 2015 10:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Running TM1 process from VBA
- Replies: 6
- Views: 5144
Re: Running TM1 process from VBA
Thanks a lot everyone for your help, I have now copied across the VBA needed to run a process. this all works fine on my machine, but on other it comes up with errors as they need a 64 bit machine to run the process. Bit of a shame as it was all working fine for me, any ideas? Just on one final note...
- Tue Jan 20, 2015 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Running TM1 process from VBA
- Replies: 6
- Views: 5144
Running TM1 process from VBA
Hello everyone
is there a simple bit of code to run a TI process from Excel? is this all the code i need?
ExcecuteProcess(sServer, sProcess)
Thanks
jaimie
is there a simple bit of code to run a TI process from Excel? is this all the code i need?
ExcecuteProcess(sServer, sProcess)
Thanks
jaimie
- Tue Jan 20, 2015 4:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RPTDATARNG1
- Replies: 2
- Views: 2885
Re: TM1RPTDATARNG1
Thanks a lot for your help, at least i can stop looking now
thanks again for taking the time
thanks again for taking the time
- Tue Jan 20, 2015 10:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RPTDATARNG1
- Replies: 2
- Views: 2885
TM1RPTDATARNG1
Hello I have an active form within excel. I want to right information on the right hand side of the active form without it being part of the active form. I have tried to change the name range of the TM1RPTDATARNG1 range so that it only goes up to a certain column. however when i update the active fo...