Search found 13 matches

by 20 Ton Squirrel
Tue Nov 17, 2020 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel VBA, PAFX: make a cell static
Replies: 4
Views: 605

Re: Excel VBA, PAFX: make a cell static

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...
by 20 Ton Squirrel
Mon Nov 09, 2020 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 663

Re: Annotation Cube: Loading new records

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. :oops:
by 20 Ton Squirrel
Sun Nov 08, 2020 10:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 663

Re: Annotation Cube: Loading new records

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....
by 20 Ton Squirrel
Fri Nov 06, 2020 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 663

Re: Annotation Cube: Loading new records

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...
by 20 Ton Squirrel
Fri Nov 06, 2020 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 663

Annotation Cube: Loading new records

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...
by 20 Ton Squirrel
Fri Sep 11, 2020 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading data with PAW/PAX
Replies: 2
Views: 319

Re: Uploading data with PAW/PAX

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 ...
by 20 Ton Squirrel
Wed Sep 09, 2020 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading data with PAW/PAX
Replies: 2
Views: 319

Uploading data with PAW/PAX

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...
by 20 Ton Squirrel
Fri Aug 21, 2020 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Linking Views in PAW
Replies: 2
Views: 763

Re: Linking Views in PAW

BRILLIANT. Thank you!
by 20 Ton Squirrel
Fri Aug 21, 2020 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Linking Views in PAW
Replies: 2
Views: 763

Linking Views in PAW

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...
by 20 Ton Squirrel
Mon Aug 17, 2020 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for a "widget" dimension
Replies: 7
Views: 587

Re: Best practice for a "widget" dimension

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 ...
by 20 Ton Squirrel
Mon Aug 17, 2020 8:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for a "widget" dimension
Replies: 7
Views: 587

Re: Best practice for a "widget" dimension

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...
by 20 Ton Squirrel
Mon Aug 17, 2020 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for a "widget" dimension
Replies: 7
Views: 587

Re: Best practice for a "widget" dimension

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...
by 20 Ton Squirrel
Mon Aug 17, 2020 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for a "widget" dimension
Replies: 7
Views: 587

Best practice for a "widget" dimension

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...