TM1 Forum

Hi guys,

I work on a Consolidation project on TM1 and we jhave around 200 views. So, do we have chance to slice all the views from TM1 to Excel in a one time. Or the only solution is to slice the views one by one. Any idea?

King Regards..

Hello

I would go for an automated solution with VBA and the VUSLICE function.
Please have a look at that one, it's not heavy VBA programming.
Although I know it's VBA programming, without using the TM1 API, I don't know any other method to accomplish this task if you want to avoid manual work.

You're lucky. See: http://www.tm1forum.com/viewtopic.php?f=21&t=12222