Search found 9 matches

by jshurak
Tue Nov 02, 2010 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Finding Zeros?
Replies: 1
Views: 2067

Finding Zeros?

I'm trying to create a report that finds exeptions...where a specific element may have a value in one cube and no value in a different cube. An example would be a gross sales exception, where we may have a sales cube and a price cube. One specific product has sales figures but no price. Is there a w...
by jshurak
Thu Mar 25, 2010 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web and numeric values
Replies: 1
Views: 2078

Re: TM1 Web and numeric values

This is resolved. The issue was data validation in excel. Even though the data entered was acceptable according to the validation, tm1 web does not like this for some reason.
by jshurak
Wed Mar 24, 2010 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web and numeric values
Replies: 1
Views: 2078

TM1 Web and numeric values

I'm having an issue trying to enter values into a websheet. The template functions perfectly fine in excel, however when I open the template on TM1 Web and try to enter a value I receive a 'Please Enter a Numeric Value' error. I've tried resetting IIS,Excel Services and the service itself, but notin...
by jshurak
Thu Feb 18, 2010 1:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: integrated login not working with Kerberos
Replies: 3
Views: 3565

Re: integrated login not working with Kerberos

Michael, thanks for the reponse. Yes TM1 is running under a domain account
by jshurak
Wed Feb 17, 2010 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: integrated login not working with Kerberos
Replies: 3
Views: 3565

integrated login not working with Kerberos

I have a server up and running....integrated login in perspectives/architect works with the NTML security package. Works great. When I try to use integrated login through perspectives/architect using the Kerberos security, I receive a 'Server Principal name (SPN) or the security context of the desti...
by jshurak
Tue Jul 21, 2009 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI interactivity with SQL Server
Replies: 2
Views: 2935

TI interactivity with SQL Server

I have a T SQL query that creates a temp table and references it later in a join statement. Does anyone have experience running anything like this in TI? The query fails when run in TI. Thanks
by jshurak
Mon Sep 08, 2008 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1sd error
Replies: 1
Views: 4629

tm1sd error

I have a client that is running into some errors while trying to install an instance as a service. The client is running from the command prompt and receiving the following reply upon execution: StartServiceCtrlDispatcher being called. This may take several seconds. Please wait. The syntax appears c...
by jshurak
Fri Aug 29, 2008 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting an average instead of Consolidation
Replies: 9
Views: 26251

Re: Getting an average instead of Consolidation

Thanks. I'll give those a try and get some more info when I get into the office.
by jshurak
Thu Aug 28, 2008 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting an average instead of Consolidation
Replies: 9
Views: 26251

Getting an average instead of Consolidation

Hi everyone, I've got a consolidation that I need to be an average. I should say, we are pulling an average in a SQL statement from our source and TM1 is automatically summing it up. I need to be able to maintain the original figure pulled. I'm new to this and had a day long Rules training class, bu...