TM1 Forum

hi,

Is it possible to export cube data to ms worksheet through a ti process?if so please give me advice over that(i didnt find any suitable ti functions regarding that)

Thanks and regards,
angel

angel1234 wrote: Is it possible to export cube data to ms worksheet through a ti process?if so please give me advice over that(i didnt find any suitable ti functions regarding that)

The short answer is no. TI can only output to a text file. Depending on what you need to do, your options are to use an Active Form (assuming a version which supports them) or use VBA code to pull down some of the data.

Hi Angel,

There's possibly another take on this, it depends what you're trying to do.

Obviously if you export with ASCIIOutput to a CSV then it will open pretty nicely in Excel. But that would be partly missing the point as with TM1 there is no need to export to Excel as the user can connect "natively" to TM1 from within Excel via formulas. Creating a slice, snapshot or active form could all be thought as "exporting to Excel" but really only the snapshot is a true export. With any Excel document using DBRW formulas the user is really browsing TM1 data just with Excel as the UI.

There are also other ways of browsing live TM1 data in Excel that don't require coding:
- the InSpreadsheet browser (many people are not a fan but I think it has its uses)
- In an Excel pivot table connected to TM1 via the OLE DB provider (note only up to XL 2003, will not work with XL 2007 or 2010 pivot tables)

You can also connect via OLE DB with VBA to pull in a cube view array, but this requires lots (and lots) of coding - now the same result can be achieved with active forms with just a few mouse clicks and no coding.

I hope that was helpful. If not you might want to provide more information what your actual requirements are.

lotsaram wrote:Obviously if you export with ASCIIOutput to a CSV then it will open pretty nicely in Excel.

Provided that none of your elements are in numeric or date format, in which case Excel will pretty nicely "help" you by converting them. Which is why I always save with the extension .cma rather than .csv to confuse Excel and force it to launch the text import wizard.

lotsaram wrote:- the InSpreadsheet browser (many people are not a fan but I think it has its uses)

I deliberately omitted the ISB from my reply given Cognos' previous statement that 9.4 would be the last version that it would be supported in. I was therefore a tad surprised to find it in 9.5. Rather less surprised to find, after such an unequivocal statement in the 9.4 release notes, that the statement wasn't modified, corrected or explained in the 9.5 release notes. However that lack of surprise is more in the form of an eye roll.

I'm waiting to hear back on a support request asking "are you or aren't you going to kill it".

hi,

Thanks for the immediate comments.I just wanted to know the entire cube data can be exported to an excel, i am not speaking about slice it can be done thorugh perspectives of ms excel. Any way confusion is over


Thanks and regards
angel