Search found 147 matches

by Christopher Kernahan
Thu May 01, 2014 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Incompatibility with Excel 2013 and TM1 10.2
Replies: 10
Views: 8863

Re: Incompatibility with Excel 2013 and TM1 10.2

We have been able to reproduce this bug in the following way. Excel 2010, TM1 10.2. 1. Open perspectives and log into TM1 2. Open a cube view 3. Export the view to Excel 4. Export the view Excel again (to prove that it is not a matter of how many times you export the view) 5. Close the blank workboo...
by Christopher Kernahan
Mon Apr 28, 2014 11:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Incompatibility with Excel 2013 and TM1 10.2
Replies: 10
Views: 8863

Re: Incompatibility with Excel 2013 and TM1 10.2

We started to move some of our users from 9.4 to 10.2. The new users are on Windows 7 PC with Excel 2013. One user reported that he cannot do another slice in 10.2 after he has done one. He gets an error message staying that "An Excel dialog box is open. Please close it first". We are experiencing ...
by Christopher Kernahan
Tue Mar 25, 2014 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Play Beep when process completes
Replies: 7
Views: 3226

Re: Play Beep when process completes

Takes me back to my teletype days
Come along Sir, the nice men here are going to take you home. There there, don't forget your slippers.
by Christopher Kernahan
Mon Mar 24, 2014 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Play Beep when process completes
Replies: 7
Views: 3226

Re: Play Beep when process completes

Errr....
TIs run on the server.
Developing on my local machine, I should have said.
by Christopher Kernahan
Mon Mar 24, 2014 12:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Play Beep when process completes
Replies: 7
Views: 3226

Play Beep when process completes

[Admins - probably belongs in "potentially, maybe, sort of" useful code forum] I've been developing with a lot of long running TIs and trying to multitask in between, so in order to alert me when a process has finished with a sound, I put this in the Epilog. #========================================...
by Christopher Kernahan
Fri Feb 28, 2014 4:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Admin Server Stopped
Replies: 3
Views: 1588

Re: TM1 Admin Server Stopped

Do you have any errors messages, log file outputs, or further information of any kind? That would be helpful.

You might start with checking the application error messages in Event Viewer when you try and start the Admin Server.
by Christopher Kernahan
Fri Oct 11, 2013 3:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue using SUBNM in Excel
Replies: 4
Views: 3471

Re: Issue using SUBNM in Excel

Hi Guillaume, 1. Is the name of your dimension "CUBE"? If not, this should be a Dimension name. 2. There are semicolons in your formula. Unless this is an internationalisation thing, shouldn't they be commas? 3. If you manually type in the name of the element in the parameter, does the formula updat...
by Christopher Kernahan
Fri Aug 23, 2013 12:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1
Replies: 5
Views: 1940

Re: Cognos TM1

Please. Read. The. Manual.
by Christopher Kernahan
Thu Aug 22, 2013 1:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 11855

Re: How to Use DBSW

Walt,

I've loaded a value using a DBSW that relies on a DBRW formula on a separate sheet. It requires that the sheets are not refreshed together.

- Shift + F9 the DBRW sheet, THEN,
- Shift + F9 the DBSW sheet.

So I'm curious as to why this doesn't work for you?
DBSW.png
DBSW.png (16.83 KiB) Viewed 11394 times
by Christopher Kernahan
Tue Aug 20, 2013 12:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In a global context, how does TM1 compare to...
Replies: 13
Views: 4630

Re: In a global context, how does TM1 compare to...

TM1 is certainly mature enough to be considered for international deployment, and in fact is currently in use as the budgeting, planning, and reporting tool at one of the world's largest banks (300K+ employees), as well as in place at international pharmaceutical and investment banking firms. With I...
by Christopher Kernahan
Fri Aug 16, 2013 2:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 11855

Re: How to Use DBSW

If I'm not missing something, can you not;

- put the DBRWs and DBSWs on separate tabs,
- replace the DBRW references in the DBSW formula with Excel references to the DBRWs on the separate tab,
- refresh the DBRW tab,
- and then refresh the DBSW tab to load the data?
by Christopher Kernahan
Wed Aug 07, 2013 2:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Planning & Web Server
Replies: 5
Views: 2542

Re: TM1 Planning & Web Server

Hi nmiller,

It would be good to share what you've learned, for future generations of Earth.
wisdom_of_the_ancients.png
wisdom_of_the_ancients.png (27.27 KiB) Viewed 2266 times
Source: http://xkcd.com/979/
by Christopher Kernahan
Tue Jul 23, 2013 8:04 am
Forum: Enhancements
Topic: Server Explorer Shortcut
Replies: 4
Views: 4967

Re: Server Explorer Shortcut

As a followup to these posts, there is a way to obtain a much shorter shortcut to the Server Explorer. In recent versions of Excel (I'm using 2010 but I think this would work in 2003 as well) you can add buttons to the Quick Access toolbar (right-click > Add to Quick Access Toolbar). Once they've be...
by Christopher Kernahan
Fri May 24, 2013 6:04 am
Forum: Commercial and Events
Topic: Shocking news for TM1 Administrators!
Replies: 14
Views: 9083

Re: Complimentary TM1 Application & Server Monitoring Servic

This is really great - is that a Bootstrap theme? Looking forward to seeing how you evolve the monitoring - are you thinking of extending it into more of an analytical tool?
by Christopher Kernahan
Fri May 24, 2013 6:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube published in Cognos. Delay in updating?
Replies: 3
Views: 1696

Re: TM1 cube published in Cognos. Delay in updating?

This is something I've seen some problems with, and I don't have all the answers on how it is working. I believe officially the position is that any change to the cube structure (attributes included) requires a package republish. Here is a hierarchy of other steps that I follow if I need to see the ...
by Christopher Kernahan
Thu May 16, 2013 2:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No Values in Cube after Successfull TI Process
Replies: 13
Views: 4315

Re: No Values in Cube after Successfull TI Process

Secondly, I scheduled all four processes in different time periods so when one process finishes loading data then after few minutes other process starts loading. I'm glad this is working for you now, but I think you should refer back to what others had written and finish the job - relying on simply...
by Christopher Kernahan
Mon May 13, 2013 12:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FAP questions and observations
Replies: 2
Views: 1231

Re: FAP questions and observations

Hi vladkon, If you are in Architect/Perspectives, select View > Display Control Objects. This will reveal a large number of objects, including cubes, dimensions, and processes, that are prefixed with '}' - this indicates that they are system objects Once they are exposed you can view them as you wou...
by Christopher Kernahan
Fri May 10, 2013 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Natural Consolidation to calculate %
Replies: 10
Views: 3646

Re: Natural Consolidation to calculate %

Hi conray,

You'll have to use Rule Calculations for that.
by Christopher Kernahan
Tue Mar 12, 2013 3:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indexing Dimix Dimnm Alias Attributes
Replies: 2
Views: 1234

Re: Indexing Dimix Dimnm Alias Attributes

A couple of questions;

- why are you restarting the service nightly?
- why are you relying on indexes?
- before the service restarts do you run a SaveDataAll?
by Christopher Kernahan
Wed Feb 06, 2013 10:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exposing TM1 cube views and subsets in Cognos Report Studio
Replies: 1
Views: 1081

Re: Exposing TM1 cube views and subsets in Cognos Report Stu

Hi,

As I understand the tools, currently views and subsets are not available in Cognos Report Studio.

A common approach is to build a specific TM1 cube for reporting from Cognos - structure your dimensions with the consolidations and subsets that are required specifically for <i>reporting</i>.