TM1 Forum

This is a bit pedantic but I rather specialize in Excel VBA and would like to offer a suggestion for your code, Wim. Whenever you are writing values to the worksheet use the Value2 property. Sub test() With ActiveCell .Value2 = .Value2 End With End Sub The standard Value property "formats" the value...

Wow, thanks for all the fab advice everyone! I'll see about posting the full process separately, it is a bit lengthy and project-specific... hopefully not too horrifying to you veterans of TM1.

Aaaaaaaand with a bit FURTHER tinkering I have it all working just fine. I think. Unless someone comes up with a reason why not. Essentially, the ID appears to be a unique identifier for the annotation within that particular area. I see no other place that the ID is tracked within the TM1 structure....

A bit of experimenting showed I can, indeed, just insert a new annotation into the cube. I did this manually by pasting in a doctored string directly to the annotation cube. I just made up a 10-character string for this new annotation. It loads fine browsing comments within TM1 web. The question rem...

I need to transition comments from Excel worksheets to TM1. I wrote VBA to export comments to a CSV, replacing any linefeeds with \n. Now I'm stuck trying to add these comments to the annotation cube. I've seen code that describes how to edit pre-existing annotations but nothing about adding new one...

Thanks for the response, Steve! It is good to know that a process CAN do this sort of thing from Excel. I should've mentioned the other complication: the TM1 server is isolated from the company network. The folk in networking are stingy about security so only another developer and I have a login to ...

I have a script that generates a CSV file on a quarterly basis. This file needs to be uploaded and digested by TM1... hopefully by the end-user, not me. I want to develop the system and leave the analysts to do their work. I devised a TI process in PAW that uploaded the file to the server and digest...

BRILLIANT. Thank you!

Let's say I have two views of the same cube on a single sheet, one shows Shipments and the other shows Shipment Share. If I change the filter in one, I'd have to change the filter in the other also. Terribly inconvenient for a lazy analyst doing data entry. Is it possible to link the filters between...

WOO! After scouring around for a bit I found where the config file was and added the line. After a restart of the server I was able to create a new hierarchy in PAW! Now to start practicing and learning. Thanks very much for the guidance, Wim. I like your website, too. I'll be learning MDX and I'll ...

ALSO! Let's say I make the cube flat-ish by just having product, time period, and measure fields. For the product, how do you typically handle naming conventions for the element? I'm loading historical data in from relational database exports, ongoing production for the data will be manual inputs by...

Thank you both for the advice! I had not considered how the dimension count would detriment the user experience. Most of the end-users are techno-phobic and opposed to moving into TM1, I must be very cautious in my development for user acceptance. :) I'm on 11.7.00002.1 so it should be capable of hi...

Time for a question from an Absolute Rookie™! I want to build a cube for data entry on widgets. Each widget has specific properties, those properties are: display size (from 1" to 120"), resolution (x by y, probably 30 elements), technology (TFT, OLED, CRT, etc…), and category (tv, smartphone, mobil...