New Applix Recommended Practices

2 new articles worth reading here:

http://www.applix.com/rp/Using_and_Managing_TM1_Attributes.htm

http://www.applix.com/rp/Documenting_Dimension_Usage_by_Cube.htm

TM1 Open Source Tool Kit

Over the quiet Christmas period I am going to do play around with developing a workbook full of useful vba code for anyone to use. I aim for this to be an open source collaboration that anyone can contribute to.

I will be including hopefully:

• Examples of working with the TM1 API
• Treeviews of TM1 data
• Select a TM1 view and see the equivilant MDX statement
• Select a view and export as xml
• Dynamic form for text entry
• Example MDX reporting
• Robert Gardiner's TM1 kill module
• Anything else that people would like to include

Send me an email if anyone would like to help with the first version

vba progress bars

If you have a vba report that takes a bit of time to work out the results then you should display progress to the user so that they know the report is working and hasn't crashed.

Andy Pope's website has some fantatic progress bars that you can download and use in your applications:

http://www.andypope.info/vba/pmeter.htm

Version 8 and 9 updates

TM1 9.0 SP2 U4 and TM1 8.4.5 U1 have been released and are available on the Applix website.

Olapobjects Newsletter

Olapobjects have a new newsletter out available on their website.
Check it out here:

http://www.olapobjects.com/Documents/Newsletters/OONewsletter-Nov2006.htm