Search found 14 matches

by Jayme1
Fri Jul 08, 2016 8:33 am
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 45152

Re: Clear TM1 Formulae from Excel

Thank so much for your help.... much appreciated.
by Jayme1
Fri Jun 24, 2016 11:59 am
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 45152

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...
by Jayme1
Wed Mar 30, 2016 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Syntax
Replies: 2
Views: 2229

Re: MDX Syntax

Thank you very much for your help, worked perfectly

Cheers
by Jayme1
Tue Mar 29, 2016 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Syntax
Replies: 2
Views: 2229

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)} ' )...
by Jayme1
Tue Jan 12, 2016 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Tools VBA update
Replies: 3
Views: 3706

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
by Jayme1
Tue Jan 12, 2016 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Tools VBA update
Replies: 3
Views: 3706

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...
by Jayme1
Mon Jun 15, 2015 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 VBA param
Replies: 4
Views: 4722

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...
by Jayme1
Wed Mar 18, 2015 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security - default view
Replies: 7
Views: 5659

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...
by Jayme1
Wed Mar 18, 2015 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security - default view
Replies: 7
Views: 5659

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.
by Jayme1
Wed Mar 18, 2015 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security - default view
Replies: 7
Views: 5659

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...
by Jayme1
Thu Jan 22, 2015 10:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running TM1 process from VBA
Replies: 6
Views: 5076

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...
by Jayme1
Tue Jan 20, 2015 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running TM1 process from VBA
Replies: 6
Views: 5076

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
by Jayme1
Tue Jan 20, 2015 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTDATARNG1
Replies: 2
Views: 2847

Re: TM1RPTDATARNG1

Thanks a lot for your help, at least i can stop looking now

thanks again for taking the time
by Jayme1
Tue Jan 20, 2015 10:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTDATARNG1
Replies: 2
Views: 2847

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