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 values as numeric values and then format the cube display. In Excel I have set the format to dd/mm/yyyy. I've done some digging and it sounds like I can't do anything about it. Could somebody confirm if this is the case?
Excel view:
Web view:
Thanks,
Jim.
Web Form Date Format
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Web Form Date Format
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Web Form Date Format
You just need to use the excel formatting to indicate what to do for zero value so "dd-mm-yy;;" will display as blank for minus and zero.
Problem is when you enter a date from blank; the web format can be annoying and require it in a very specific format dependent on region (more specific than changing from one date to another) but user training should get you there.
Problem is when you enter a date from blank; the web format can be annoying and require it in a very specific format dependent on region (more specific than changing from one date to another) but user training should get you there.
Declan Rodger
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
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:
Do you think something like mm/dd/yyyy;-; will work?
Jim.
Do you think something like mm/dd/yyyy;-; will work?
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Web Form Date Format
Nailed it using the following format: mm/dd/yyyy;;""
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
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?
I think to be fair what I specifically tend to use is dashes instead of blanks, so without logging in I believe we use "dd-mm-yyyy;;-" and that will be in a server that has UK date formatting.
Maybe it needs to be the same format as your regional settings?
I think to be fair what I specifically tend to use is dashes instead of blanks, so without logging in I believe we use "dd-mm-yyyy;;-" and that will be in a server that has UK date formatting.
Declan Rodger
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Web Form Date Format
Quite possibly. Also we're not on the latest version of Excel either. That may have something to do with it?declanr wrote: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?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Web Form Date Format
Excel should be fine; this is something I first started implementing a while ago... think the express customer is still using excel 2007 or 2010 due to the whole awful process of installing CX back then meaning it had a hissy fit if it didn't detect what it deemed to be the correct version of excel despite it working perfectly with newer versions if you hacked it in.
Declan Rodger