Search found 2093 matches

by jim wood
Fri Jul 21, 2017 1:00 pm
Forum: General
Topic: Upcoming server migration
Replies: 5
Views: 570

Re: Upcoming server migration

Martin Ryan wrote:
Wed Jul 19, 2017 9:38 am
I just had another crack at the emails, but I keep coming up against brick walls. I won't be able to get to it tomorrow either so hopefully will get to it over the weekend.
Martin,

Is it a port issue?

Jim.
by jim wood
Wed Jun 28, 2017 3:46 pm
Forum: Cognos TM1
Topic: Perspectives - Values Disappearing After Recalc
Replies: 3
Views: 147

Re: Perspectives - Values Disappearing After Recalc

Have you added any additional calculations? For example you may have added Excel calcs that derive an element used in the DB statements. If you have it may be down to calculation order. Try changing a DBRW in to a DBR. If it's not this you'll to provide more information regarding the sheet. It doesn...
by jim wood
Wed Jun 28, 2017 11:49 am
Forum: Cognos TM1
Topic: Tm1 Perspective 10.1
Replies: 4
Views: 195

Re: Tm1 Perspective 10.1

I think this is the post that Tomok mean't for you to look at:

http://www.tm1forum.com/viewtopic.php?t=78

Funnily enough it doesn't come up first if you use his suggested statement but it does come up 3rd,

Jim.
by jim wood
Thu Jun 22, 2017 6:32 pm
Forum: Cognos TM1
Topic: Web Form Date Format
Replies: 6
Views: 380

Re: Web Form Date Format

That's interesting; it's something I have used a lot - we have 1 customer still using it in a lot of web forms for cognos express 10.1. Maybe it needs to be the same format as your regional settings? Quite possibly. Also we're not on the latest version of Excel either. That may have something to do...
by jim wood
Thu Jun 22, 2017 5:43 pm
Forum: Cognos TM1
Topic: Web Form Date Format
Replies: 6
Views: 380

Re: Web Form Date Format

Nailed it using the following format: mm/dd/yyyy;;""

Jim.
by jim wood
Thu Jun 22, 2017 5:22 pm
Forum: Cognos TM1
Topic: Web Form Date Format
Replies: 6
Views: 380

Re: Web Form Date Format

Thanks for getting back to me so quickly Declan. I tried to move to custom and went for dd/mm/yyyy;; and this what I got:
TM1 Web Dates2.PNG
TM1 Web Dates2.PNG (2.64 KiB) Viewed 365 times
Do you think something like mm/dd/yyyy;-; will work?

Jim.
by jim wood
Thu Jun 22, 2017 3:36 pm
Forum: Cognos TM1
Topic: Web Form Date Format
Replies: 6
Views: 380

Web Form Date Format

Guys, I'm currently working with 10.1.1. I've created a web sheet where users will update project stage dates. Within Excel when a date is missing it shows as blank but when published in TM1 Web it displays a date that corresponds to the date value of 0. To give you more background we store the date...
by jim wood
Thu Jun 01, 2017 11:55 am
Forum: Cognos TM1
Topic: http://localhost:9510/pmpsvc/initialize.jsp - Unable to see servers
Replies: 7
Views: 424

Re: http://localhost:9510/pmpsvc/initialize.jsp - Unable to see servers

I can't find the post, but if memory serves it was to do with the service start order and cryptography generation straight after install. It goes like this: 1) Open cognos config 2) Start admin server 3) Start web app server 4) Add / start services 5) Make sure you save and generate all cryptography...
by jim wood
Wed May 31, 2017 12:41 pm
Forum: Cognos TM1
Topic: http://localhost:9510/pmpsvc/initialize.jsp - Unable to see servers
Replies: 7
Views: 424

Re: http://localhost:9510/pmpsvc/initialize.jsp - Unable to see servers

I posted about something similar a long while ago. It was something to do with the order of events when first opening the Admin Console. I re-installed, following the chain of events and bingo. I'll see if I can find the post......
by jim wood
Tue May 30, 2017 10:04 pm
Forum: Cognos TM1
Topic: Missing Data showing as Blank in EXCEL. How to Default to "0"
Replies: 8
Views: 323

Re: Missing Data showing as Blank in EXCEL. How to Default to "0"

TM1 numeric elements always display as zero when not populated in the cube viewer and will display as zero when sliced in to Excel. What you do within Excel is something different. What I mentioned was String Elements. They display as blank when not populated with any data.
by jim wood
Tue May 30, 2017 9:36 pm
Forum: Cognos TM1
Topic: Missing Data showing as Blank in EXCEL. How to Default to "0"
Replies: 8
Views: 323

Re: Missing Data showing as Blank in EXCEL. How to Default to "0"

Looks like Excel formatting to me. If you notice the columns that display blanks are formatted differently than the others. Show me a a straight slice and I'll think otherwise.
by jim wood
Tue May 30, 2017 8:51 pm
Forum: Cognos TM1
Topic: Missing Data showing as Blank in EXCEL. How to Default to "0"
Replies: 8
Views: 323

Re: Missing Data showing as Blank in EXCEL. How to Default to "0"

In Excel you see a zero if the element type is numeric. It sounds like your trying to get string values to default to 0. Saying that I've really spent much time with PAX so it may behave differently,

Jim.
by jim wood
Wed May 24, 2017 4:28 pm
Forum: Cognos TM1
Topic: Perspectives workbooks when promoted to different version
Replies: 4
Views: 439

Re: Perspectives workbooks when promoted to different version

Trevor,

I've not seen this exact thing but I have seen formatting shifting, especially when not using the same version of Excel,

Jim.
by jim wood
Tue May 23, 2017 4:54 pm
Forum: Cognos TM1
Topic: Fix pack
Replies: 1
Views: 144

Re: Fix pack

IBM's version of a service pack:
https://en.wikipedia.org/wiki/Service_pack
by jim wood
Mon May 15, 2017 3:31 pm
Forum: OLAP Jobs
Topic: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank
Replies: 8
Views: 591

Re: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank

As I understand that the TM1 system was published by Applix Inc. and then Cognos acquired it and have rebranded the products, thus the systems were named Cognos TM1 and then IBM acquired Cognos....so logically it is IBM Cognos TM1? TM1 is still TM1...isn't it? Even though it could be named Applix, ...
by jim wood
Mon May 15, 2017 12:41 pm
Forum: OLAP Jobs
Topic: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank
Replies: 8
Views: 591

Re: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank

vlad.stepanov wrote:
Paul Segal wrote:That last requirement might be a problem ;-)
So true.
Already had a candidate interviewing with the client and he was not keen on the Applix either.
What is the actual issue with the Applix? Why you(TM1 PROs) don't like it?
Because Applix doesn't exist and hasn't existed for a while.
by jim wood
Fri Apr 28, 2017 7:35 pm
Forum: Cognos TM1
Topic: Calculate Time taken for a TM1 server between start and be ready
Replies: 5
Views: 516

Re: Calculate Time taken for a TM1 server between start and be ready

You could start the service with a batch file that creates a file containing the current date and time. Then within Tom's chore that runs every miunte check to see if the file exists. If it does load the details then delete the file,

Jim.
by jim wood
Fri Apr 28, 2017 7:32 pm
Forum: Cognos TM1
Topic: Ascii Export Field Quote Char
Replies: 1
Views: 222

Ascii Export Field Quote Char

Guys, I've been having some export troubles for a while. Within a cube we have a free text field. As users do they've used and abused this field. We've got tabs, quotes, pipes you name it in there. Currently the export is tab delimited and the tabs within the fields is causing us a problem. We have ...
by jim wood
Mon Apr 24, 2017 2:52 pm
Forum: Cognos TM1
Topic: Things I can't do in Performance Modeler
Replies: 8
Views: 689

Re: Things I can't do in Performance Modeler

pandinus wrote:
PavoGa wrote:We actually do not allow our development team to use PM. Es ist verboten.
I take it you are not using TM1 Applications or any of the fancy metrics things then, right?
TM1 Applications are the only the use for PM. But that's miles away from using it for development.
by jim wood
Thu Apr 20, 2017 5:57 pm
Forum: Cognos TM1
Topic: Things I can't do in Performance Modeler
Replies: 8
Views: 689

Re: Things I can't do in Performance Modeler

I'm not sure how much traction you'll get with this one. Most people haven't upgraded to PAW yet and most developers avoid PM like the plague.