TM1 Forum

Hi, What I would do is build my export in a TI process: -Build your datasource view with "total year" element regarding Time dimension -In data, write two CellGetN formula to get July and August values -Write an asciioutput formula to export 3 fields: P&L account, July value, August va...

Thanks Andy, It works perfectly well with that instruction :) So far it works on my development server. I hope it will work fine as well on my production servers, because I tried a few months ago, and I thought the problem was with the format itself. It seemed to me that zipping and unzipping the fo...

Thanks for your answers, Alan Kirk, I already have the dimension's attributes cube because my dimension elements have two aliases. jstrygner, I can not copy the .vue file because the views are recreated through a TI process during the night process. In order to better explain the context, here are s...

Hello, I create some default views for users through TI processes. Do you know a TI function which would allow me to assign a format to a view, or to some elements? What I tried so far is to assign a format to some elements with attrputs function, like for instance: attrputs('b:#,##0CO|0|','UNIT',V2...

Hi swain69, We experience exactly the same. As Andy said, selecting any other ribbon is a good workaround. Nevertheless, I have maybe another solution. Which add-in do you use? Here, we are using tm1p.xla. On my computer, I replaced tm1p.xla with tm1pRibbonX.xlam add-in. It seems to solve the proble...

By the way, lotsaram, what do you mean by "run M_Clear" ?
Thanks
Catherine

The drill is assigned almost everywhere in the cube so this is not my problem.
I confirm that the only way I found to make the drill option re appear is to restart Excel. But this solution does not satisfy me. Or should I say it will not satisfy the users...

Hello, I've built a drill through process that works fine. This drill through is available from an Excel sheet, more precisely from an active from. But sometimes (I've not identified under which circumstances), the drill is no more available in the right clik menu. Any idea of what I could do? Thanks

Hi everybody, Has somebody already downloaded and tested FP3? We've just installed it on a test machine and it seems that we sometimes have troubles in the subset editor. In some cases, we can not zoom in and out via the "+" and "-" in the hierachy :x We'll go deeper in our tests...

Hi all, I work with TM1 9.4.1 FP2 and Excel 2007. Sometimes (I don't know when and why), TM1 toolbar in Excel looses icon labels and only icons remain in the toolbar :roll: As I used to work with Excel 2003 so far, I'm not very used to TM1 menu in Excel 2007. So when I have only the icons, I'm a lit...