Search found 8 matches

by Joffes
Fri Oct 16, 2009 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: copying children from 1 parent to another
Replies: 2
Views: 2321

Re: copying children from 1 parent to another

CopyFrom and CopyTo are Parameters which should be variable.
Project_Tasks is defined as a variable and is a subset of all the n level elements in my dimension.

I'll look into defining the CopyTo|'.'|TaskNo into a variable
by Joffes
Thu Oct 15, 2009 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: copying children from 1 parent to another
Replies: 2
Views: 2321

copying children from 1 parent to another

Hi guys, I am trying to write a process to copy children from 1 parent to another. I am using a subset of the n level elements as a a start and parameters for the from and to parents. I have 2 attributes project no and task no. My dimension looks like: All projects project no task no 1 1 1.1 1 1 1.2...
by Joffes
Tue Oct 06, 2009 6:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel macros and action buttons
Replies: 3
Views: 4662

Re: Excel macros and action buttons

Thanks guys, I understand VBA is not supported and why it will not work on web. I am just trying to see if there is some type of workaround using action buttons. My client has many excel reports and input templates where we use excel buttons and vba to add and remove lines in the sheet and limit wha...
by Joffes
Mon Oct 05, 2009 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel macros and action buttons
Replies: 3
Views: 4662

Excel macros and action buttons

Hi guys, I need to add an amount of vb code to a cube slice, this code will run through command buttons, however these as we know are not supported in Tm1Web. I am using Excel 2007 and 9.4.1 FP 2 My questions are: Is there a way of running a macro through action buttons? Is there another method of u...
by Joffes
Tue Oct 14, 2008 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: addin - tm1p error!
Replies: 7
Views: 7748

Re: addin - tm1p error!

I did have the windows intaller problem before, that was solved by reinstalling office on the machine.
by Joffes
Tue Oct 14, 2008 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VUSLICE
Replies: 4
Views: 4746

Re: VUSLICE

Still no luck I'm afraid, anyone have any other ideas?
Can you actually use a vuslice command more than once in a workbook, or maybe its one of those macros that can only run once.
by Joffes
Tue Oct 14, 2008 5:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VUSLICE
Replies: 4
Views: 4746

Re: VUSLICE

I'll give it a try thanks.

The views deifnately still exist and I'm running 9.1 SP3.
by Joffes
Mon Oct 13, 2008 10:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VUSLICE
Replies: 4
Views: 4746

VUSLICE

Hi guys, I have created excel input templates referencing a vuslice to bring me the data. It appears though that I can only use the code once. The first time, my view is returned, but on any attempts thereafter I get a "FALSE" in the selected columns. Does anyone have a solution to this. T...