TM1 Excel Slice

AliUgur · Post by **AliUgur** » Wed Dec 16, 2015 8:04 am

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

Wim Gielis · Post by **Wim Gielis** » Wed Dec 16, 2015 9:14 am

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.

Wim Gielis · Post by **Wim Gielis** » Thu Dec 17, 2015 8:39 am

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

TM1 Forum

TM1 Excel Slice

TM1 Excel Slice

Re: TM1 Excel Slice

Re: TM1 Excel Slice