Search found 24 matches

by bjones
Mon Jun 01, 2015 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Supress Zeroes on Active Form Columns
Replies: 3
Views: 3380

Re: Supress Zeroes on Active Form Columns

That's what i was suspecting. Thanks for your input guys
by bjones
Mon Jun 01, 2015 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Supress Zeroes on Active Form Columns
Replies: 3
Views: 3380

Supress Zeroes on Active Form Columns

I've been trying to figure this out but don't see what i'm missing... in explorer i can easily supress zeroes and it get rid of any rows or columns that have all zeroes. When i take the same view in Active form and try to supress zeroes it only supresses the row and the columns stay there full of ze...
by bjones
Mon Jan 26, 2015 9:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppress zeroes in TM1 application
Replies: 5
Views: 5209

Re: Suppress zeroes in TM1 application

It was a feeder problem but i also saw a difference between 10.1 and 10.2 where in 10.1 when you suppress 0 you have to recalculate whereas in 10.2 it is done automatically.
Hope that helps
by bjones
Fri Jan 16, 2015 5:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppress zeroes in TM1 application
Replies: 5
Views: 5209

Suppress zeroes in TM1 application

I have an approval application with a view that has values. When i supress zeros the whole view dissapears.
I checked all the cells are fed and when i supress zeroes on the same view in Architect only zeroes are suppressed. Did anyone face this before?
I'm 10.1.1 by the way
Thanks
by bjones
Mon Jan 12, 2015 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active from row format not carried over to TM1web
Replies: 4
Views: 3719

Re: Active from row format not carried over to TM1web

This is what i added at the end of the formula IF(ISNUMBER(FIND("%",B34)),"P", "N"))
P is the row configured for percentage
by bjones
Mon Jan 12, 2015 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active from row format not carried over to TM1web
Replies: 4
Views: 3719

Active from row format not carried over to TM1web

I have an active form with rows that have dollars and other that have percentage. In order to get this i added a new row in the formatting region on top and applied the formatting to the rest of the active form. Everything works fine in Perspectives after rebuilding the sheet. Once i upload it to tm...
by bjones
Thu Jan 08, 2015 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Function to list TM1 version
Replies: 7
Views: 11132

Re: Function to list TM1 version

Thanks for your help guys
by bjones
Mon Jan 05, 2015 10:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Function to list TM1 version
Replies: 7
Views: 11132

Re: Function to list TM1 version

Yeah, i was able to find the version from tm1sd.exe and a link on IBM that explains what every numbers means (versions, fix patches...) but just wanted to make sure that i wasn't missing something obvious. I guess at this point i'll just hard code it since the version doesn't change that often Thank...
by bjones
Mon Jan 05, 2015 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Function to list TM1 version
Replies: 7
Views: 11132

Function to list TM1 version

Is there a function that would return the TM1 versions used?
by bjones
Wed Aug 20, 2014 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contributor - Manage rights - automate
Replies: 4
Views: 4953

Re: Contributor - Manage rights - automate

Did you ever find out what the solution to the error is?
by bjones
Fri Aug 08, 2014 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cellgetn and asciioutput
Replies: 2
Views: 2642

Re: Cellgetn and asciioutput

Thanks Alan,

Just read through the guidelines.

You're right it was a string vs number issue. the value is actually a string is the other value i get cellgetS that was a numeric. just added numbertostring

Thanks a lot
by bjones
Fri Aug 08, 2014 7:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cellgetn and asciioutput
Replies: 2
Views: 2642

Cellgetn and asciioutput

Hello all, sort of new to ti processes and stuck. i'm trying to export a cube that has comments and match those same cell to their value which is stored in another cube. So far i have the following command but it is not working ASCIIOUTPUT('C:\...\fil.csv', V1, V2, V3, V4, V5, V6, value, cellgetS('P...
by bjones
Wed Jun 18, 2014 1:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: intermittent The file "portal/variables_plan.xml" could not
Replies: 0
Views: 2681

intermittent The file "portal/variables_plan.xml" could not

Everytime i access TM1 applications i get the following error : "The file "portal/variables_plan.xml" could not be opened." After refreshing a few times it works. I have tm1 and a distributed cognos installed. Authentication is done through BI and i checked both dispatchers as we...
by bjones
Wed Jun 18, 2014 1:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error when deploying application on Performance Modeler
Replies: 2
Views: 3047

Re: Error when deploying application on Performance Modeler

Thanks for the suggestion. It worked after i added the user to the sys admin group in cognos
by bjones
Mon Jun 16, 2014 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error when deploying application on Performance Modeler
Replies: 2
Views: 3047

Error when deploying application on Performance Modeler

I'm trying to deploy a new application that has one view on Performance Modeler but everytime i save it, and validate it and try to deploy it i get the following message:

"An error occured while creating Cognos Objects."

Anyone faced this before? This is a new environment with TM1 10.2.2
by bjones
Mon Jun 09, 2014 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and BI secuirty 10.2
Replies: 2
Views: 2658

TM1 and BI secuirty 10.2

I'm trying to use AD secuirty through BI. While following the IBM configuration file i added the ServerCAMURI, ClientCAMURI and other parameters to the tm1s.cfg file while changing the security mode to 1. after i login with admin and try to do add new client there is no pop up to connect to AD. it s...
by bjones
Wed Jun 04, 2014 7:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and BI security
Replies: 1
Views: 1976

TM1 and BI security

I implemented BI security with BI and it is working good. The problem is when a new user logs in they are automatically put in the group cognos\everyone and not their assigned grouped. did i miss a step in the AD configuration or do i have to do this manually which doesn't sound logic. any help woul...
by bjones
Wed May 28, 2014 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New Cognos TM1 install CAM-CRP-1057
Replies: 0
Views: 1956

New Cognos TM1 install CAM-CRP-1057

I just did a new install and it was working fine but the next day when i open IBM Cognos Configuration i get the following pop up error message: "CAM-CRP-1057 Unable to generate the machine specific symmetric key. reason: java.security.NoSuchProviderException: No such provider: IBMJCE" and...