Macro Function to generate Active form

[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,

[rmackenzie]

Do we have any TM1 function like 'VUSLICE' (creates a slice worksheet) to get an active form worksheet ?

I don't believe there is.

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