Page 1 of 1
Macro Function to generate Active form
Posted: Wed Jun 06, 2012 1:46 pm
by olap_knk
Hi guys,
Do we have any TM1 function like 'VUSLICE' (creates a slice worksheet) to get an active form worksheet ?
Seeking suggestion on how to get an active form created at worksheet using macros ?
Thanks,
Re: Macro Function to generate Active form
Posted: Thu Jun 07, 2012 3:23 am
by rmackenzie
olap_knk wrote:Do we have any TM1 function like 'VUSLICE' (creates a slice worksheet) to get an active form worksheet ?
I don't believe there is.
olap_knk wrote:Seeking suggestion on how to get an active form created at worksheet using macros ?
You can hand-craft an active form by setting up the named ranges and formulas in the same way that TM1 creates them for you when you do a active form slice. I suppose you could write a macro to automate this, with the advantage that you could automatically define a formatting system other than the built-in one which is a bit unappealing for some peoples tastes. Just check out all the things on a test active form.
(note to Mods - this post is in the wrong forum) -- moved to TM1 Forum