Tag Archives: Wim Gielis

Guest Post: Solving a TM1 Performance Problem – Wim Gielis

One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) Month (12 months plus YTD consolidations) Scenario (actuals, budget rounds) Allocation phase (7 phases, populated … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis | 1 Comment

Guest Post: Sorting TM1 Text Output – Wim Gielis

First of all, thanks to Ben for inviting me to write this guest article. The case is as follows. Recently, the customer wanted an export from a cube view showing monthly revenue values per project. The user should open the exported file in Excel, modify and import back into TM1. Exporting data to a text file format like .CSV or .TXT is not an issue; an ASCIIOUTPUT() or TEXTOUTPUT() function … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis. Bookmark the permalink. | Tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis | 6 Comments