Search found 16 matches

by alexhancock
Tue Nov 26, 2013 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone using TM1Web 10.2 yet?
Replies: 14
Views: 11876

Re: Anyone using TM1Web 10.2 yet?

It was mentioned in another post, but you can upgrade the server components and use the 10.1 .NET web. IBM released some notes that this is supported (google is failing me at the moment). This should allow you to leverage the Multi Threaded Queries and other enhancements while not getting the Java ...
by alexhancock
Fri Nov 22, 2013 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone using TM1Web 10.2 yet?
Replies: 14
Views: 11876

Re: Anyone using TM1Web 10.2 yet?

Thanks for the responses - especially about the caching, I'll raise with IBM as well.

I have come across some other bugs, so yes - very much a version 1 product which is a shame as some of the other features in 10.2 make this upgrade almost indispensible for us.
by alexhancock
Thu Nov 21, 2013 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone using TM1Web 10.2 yet?
Replies: 14
Views: 11876

Anyone using TM1Web 10.2 yet?

I've found that it can be much slower than 10.1, particularly when scrolling around large spreadsheets - the scrolling seems to gum up for seconds at a time.

Anyone else found this?
by alexhancock
Fri Nov 30, 2012 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Websheet Hyperlinks
Replies: 0
Views: 2230

Dynamic Websheet Hyperlinks

Hello, I am using TM1 10.1 creating a TM1 Application Web application which uses websheets to display information. We would like to link through from a websheet to a Cognos report - this can be achieved by simply inserting the hyperlink in Excel. However, the reports are prompted and all the prompt ...
by alexhancock
Wed Aug 08, 2012 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Websheet security
Replies: 2
Views: 2824

Re: TM1 Websheet security

Great thanks! It's just because I hadn't modified any existing security that It didn't exist.

Cheers,

Alex
by alexhancock
Wed Aug 08, 2012 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Websheet security
Replies: 2
Views: 2824

TM1 Websheet security

Hello, I'm trying to restrict websheets to certain users only. Currently I can see that you can only allocate 'None' or 'Read' only to the Cognos\Everyone group, all other security groups are greyed out. This looks like it should be controlled by a cube - and I can see the }ApplicationEntries dimens...
by alexhancock
Tue Apr 10, 2012 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ordering a dimension using Aliases
Replies: 8
Views: 13887

Re: Ordering a dimension using Aliases

Thanks very much guys, I wasn't even aware that such a function existed - could be extremely useful in the future.
by alexhancock
Fri Mar 23, 2012 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ordering a dimension using Aliases
Replies: 8
Views: 13887

Ordering a dimension using Aliases

Hello, We would like to order a dimension (not a Subset) by Hierarchy using Aliases rather than element names (the element names have to be codes whereas everyone needs to see the English name of the code). We need the dimension ordered as users often navigate through various levels, expanding conso...
by alexhancock
Fri Mar 23, 2012 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UK TM1 User Group
Replies: 15
Views: 11335

Re: UK TM1 User Group

I'll put it in the diary - thanks for taking this on Paul.
by alexhancock
Mon Mar 19, 2012 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UK TM1 User Group
Replies: 15
Views: 11335

Re: UK TM1 User Group

Looks good - it's a fantastic pub on nice days.

Frequency - Every 2-months or Quarterly?
Day of week - Thursday could be good?

It would be well worth talking to the wellington/sydney groups to find out what works well for them. Also could consider getting recruiters/ibm invited.

Cheers,

Alex
by alexhancock
Fri Mar 16, 2012 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UK TM1 User Group
Replies: 15
Views: 11335

Re: UK TM1 User Group

I'd also be very interested - would be great to share war stories and ideas. Anywhere near Bank tube would be great (good connections to the City, Canary Wharf, Central line, Waterloo etc.) What about the Crosse Keys? http://www.jdwetherspoon.co.uk/home/pubs/the-crosse-keys Any particular days that ...
by alexhancock
Tue Nov 08, 2011 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation of n-level (leaf) elements
Replies: 6
Views: 5822

Re: Consolidation of n-level (leaf) elements

You want B to show D + E and C to show E + F but you want A to be D + E + F ? Is that right? Paulsimon - Your summary above is correct, and it is an interesting use case. We are classifying items and wish to record measures against them. However the classification of the items is fuzzy, such that D...
by alexhancock
Fri Nov 04, 2011 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation of n-level (leaf) elements
Replies: 6
Views: 5822

Re: Consolidation of n-level (leaf) elements

Is the problem that each leaf item must contribute only once to the top level, regardless of there being potentially multiple parentage paths between it and the top? Exactly. This is where an element could exist under multiple parents, but ultimately be counted only once at levels above. As you say...
by alexhancock
Fri Nov 04, 2011 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation of n-level (leaf) elements
Replies: 6
Views: 5822

Consolidation of n-level (leaf) elements

Hello, I was just wondering whether there is an easy way of consolidating only n-level elements within a hierarchy. I.e. a Member at the top level (e.g. level 4) should consolidate only the leaves at level 0 (because of rules or other issues [e.g. multiple parenting] at the intermediate consolidatio...
by alexhancock
Fri Oct 21, 2011 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enterprise Timesheets in TM1
Replies: 3
Views: 3196

Re: Enterprise Timesheets in TM1

We have been using TM1 for project timesheets for 12 years. Works very well, record hours worked, billed by project\consultant on a daily basis. Excellent both for operational reports, billing and management information. Data capture either direct or via spreadsheet template. The architecture does ...
by alexhancock
Wed Oct 19, 2011 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enterprise Timesheets in TM1
Replies: 3
Views: 3196

Enterprise Timesheets in TM1

Hello, My company is currently considering options for project-based timesheets. Given the capabilities of TM1 and TM1 Contributor, I was wondering whether a developing a timesheet application that leveraged our existing TM1 investment was feasible/desirable. Has anybody got any experience of develo...