Search found 152 matches

by ScottW
Wed Jul 26, 2017 8:22 pm
Forum: Enhancements
Topic: RFE 108021: extend scope of temporary objects beyond creating process
Replies: 1
Views: 13329

RFE 108021: extend scope of temporary objects beyond creating process

For anyone using bedrock or any other TurboIntegrator function library the current implementation of temporary subsets & views renders them for all intents and purposes completely useless as the temp object is only available within the scope of the process that created it and can't be accessed b...
by ScottW
Wed Jun 09, 2010 3:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Complex SQL affect how long TI takes to open?
Replies: 4
Views: 3844

Re: Complex SQL affect how long TI takes to open?

Does the complexity of a SQL statement affect how long a TI process takes to open? Is there some processing/validation that takes place during the initial opening of a TI process - i.e. does it validate the SQL or reparse the variables? For one of my TI processes, the initial Data Source window tak...
by ScottW
Fri Apr 23, 2010 12:07 pm
Forum: Enhancements
Topic: List of where Dims, Views in subset are applied
Replies: 2
Views: 5691

Re: List of where Dims, Views in subset are applied

Yes absolutely. That's why we built such a tool.

TM1 Documenter
by ScottW
Fri Feb 19, 2010 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transferring between services
Replies: 8
Views: 5436

Re: Transferring between services

Yes this has been done and yes there is a 3rd party commercial application that will do this for you
http://www.cubewise.com/vizier-91.php

Currently promotion of dimensions, subsets, attributes, processes and chores is supported.
Cube views and application entries in development.
by ScottW
Thu Nov 26, 2009 11:30 pm
Forum: OLAP Jobs
Topic: Cubewise is seeking consultants in Melbourne
Replies: 0
Views: 2475

Cubewise is seeking consultants in Melbourne

Cubewise is the IBM Financial Performance Management (TM1) Asia Pacific partner of the year the past 2 years running. Our consultants are not just Cognos and TM1 experts but also business savvy, typically with accounting qualifications and/or operational experience. We build business solutions that ...
by ScottW
Wed Jul 01, 2009 5:12 am
Forum: Commercial and Events
Topic: New TI Editor
Replies: 28
Views: 1155861

Vizier TI Editor and TM1 administration tools

Just confirming that this product is no longer branded "Extend" but is now known as Vizier for TM1 Developers and Administrators . Vizier is now also much more than just a TI editor and also includes an SQL query builder, promotion tool, cube optimizer, user and server monitor and chore re...
by ScottW
Wed Mar 11, 2009 10:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Drill - Formating
Replies: 6
Views: 5637

Re: ODBC Drill - Formating

Also where is the drill being performed? If it is on the web then the formatting has to come from the source. If you are drilling in Excel then there are other VBA driven options. If you have some code to take over the New Workbook event you can check to see if it is the result of a drill and then a...
by ScottW
Wed Mar 11, 2009 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel / Websheet cell dependencies
Replies: 5
Views: 5769

Re: Excel / Websheet cell dependencies

Hi Martin, I'm surprised there haven't been any responses to your question, it sounds like an interesting problem. It might be because it is a little difficult to figure out what exactly you are doing with your report. For a start TM1 web is not optimised for large websheets. A better design approac...
by ScottW
Wed Mar 11, 2009 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ability to link or access to other BI tools from TM1
Replies: 4
Views: 3934

Re: Ability to link or access to other BI tools from TM1

Not sure if you are talking about browsing other data sources with TM1 (which seems to be implied by your question) or browsing TM1 from other front ends (which seems to be suggested by the other responses.) The attached document from Cognos might be useful although most of it is quite out of date b...
by ScottW
Tue Mar 10, 2009 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Realistically Using Large Dimensions
Replies: 7
Views: 5815

Re: Realistically Using Large Dimensions

Hi Steve, Sorry if this is a bit late just haven't had time to post anything lately. The largest dims we have in production would be a couple of SKU dims used in sales cubes for some retail clients with somewhere between 100K - 200K elements. Once consolidations are accounted for probably around dou...
by ScottW
Thu Mar 05, 2009 10:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recommendations for 700 users and high volumes
Replies: 16
Views: 13238

Re: Recommendations for 700 users and high volumes

128 Gb RAM, ... what exactly are you planning on building? TM1 Workflow probably warrants it's own discussion, uptake has generally been pretty low so you might not get a whole lot of responses. In my opinion TM1 Workflow can be a very good tool, especially for a budget contributor model of this sco...
by ScottW
Thu Mar 05, 2009 10:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing Security with Rules
Replies: 9
Views: 7363

Re: Managing Security with Rules

If you have the view already open the new elements in the dynamic subset won't automatically come into the subsets on the row or column dimensions, this is normal. You have to refresh/rebuild/reopen the view for any new members of dynamic subsets to display.
by ScottW
Wed Mar 04, 2009 3:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recommendations for 700 users and high volumes
Replies: 16
Views: 13238

Re: Recommendations for 700 users and high volumes

Mike, Generally I would say 700 users is not a problem but it is really going to come down to the number of concurrent users writing data at any one time. If you went with a split out / distributed / regionalised model then any concurrency issues are likely to fade away but you will have rep and syn...
by ScottW
Tue Mar 03, 2009 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reordering Elements
Replies: 3
Views: 4290

Re: Reordering Elements

OK, I'm going to presume that your new elements are either orphans or are sitting under a "New Elements" hierarchy. In either case it is pretty easy to write either a TI or MDX to create a subset to scoop up these elements into a list for processing. Next create an attribute in the dimensi...
by ScottW
Tue Mar 03, 2009 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reordering Elements
Replies: 3
Views: 4290

Re: Reordering Elements

Do you mean just placing new elements under the correct parents or is the actual order of the elements under the parents important? If it's the former then this is easy with TI, if it's the later then not so. Unless you are dealing with a time dimension I would argue that index order is not importan...
by ScottW
Tue Mar 03, 2009 12:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subsets & Cube Locking
Replies: 3
Views: 4003

Re: Dynamic Subsets & Cube Locking

Hi Jon, That's an interesting one that it might be worthwhile getting some more detail on what exactly your upload spreadsheet is doing (i.e. how is the data being loaded, type over DBRW, DBSW, is any VBA involved ...), and what dynamic subsets are in use, and reporting to IBM. As long as the TI in ...
by ScottW
Tue Mar 03, 2009 12:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI can't open Data Source Files
Replies: 12
Views: 12103

Re: TI can't open Data Source Files

If you have checked out file permissions and file paths and everything seems to check out then a file lock is looking more likely as your cause. The file doesn't have to be open in another application to prevent TI being able to open it, the OS just needs to think that some other application has a l...
by ScottW
Thu Feb 26, 2009 10:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing Security with Rules
Replies: 9
Views: 7363

Re: Managing Security with Rules

Are there any documentation sources for using cube rules to manage security in TM1? ... Is there anyway to be able to collapse Groups so that setting user access is less like looking for a needle in a haystack? Rules are a great tool for maintaining security, the light coverage in the developers' a...
by ScottW
Wed Feb 25, 2009 4:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.4 - Perspectives/Client - Login Issue
Replies: 7
Views: 5976

Re: TM1 9.4 - Perspectives/Client - Login Issue

You didn't mention if this issue was with integrated login or standard login ...
by ScottW
Wed Feb 25, 2009 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.4 MR1 - memory leakage issue?
Replies: 15
Views: 10964

Re: 9.4 MR1 - memory leakage issue?

Hi Steve, A cell can still be fed only once. It's just that in a multi-threaded load each CPU is an independent process and doesn't know what the others are doing. The redundant multiple feeding still consumes memory but this goes straight to memory in garbage once the cube is finished loading. Mult...