TM1 web report is not allowing to enter the negative number. while we/user tried entering the negative numbers in TM1 Web for certain intersection then it is popup the error. the error is "incorrect dollars for the resource type". but if I go to cube viewer in the same combination then input number then I am able to enter the data. Any suggestions pls why I am getting the error?
we are using PA Local 2.0.3 version.
TM1 Web negative number didnot allowed
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
-
- MVP
- Posts: 3663
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 Web negative number didnot allowed
What number format is being used for the display and for the input?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- PowerDim
- Posts: 13
- Joined: Thu Aug 07, 2014 12:44 pm
- OLAP Product: TM1
- Version: PAL 2x
- Excel Version: Excel 2019
- Location: Earth
Re: TM1 Web negative number didnot allowed
Is the report made on the basis of a websheet (on Excel by TM1 Perspectives) or a simple view?
If it is a websheet, then it looks like a format problem on the Excel side.
If a view, then this is a strange situation. Maybe clean broweser's cache?
If it is a websheet, then it looks like a format problem on the Excel side.
If a view, then this is a strange situation. Maybe clean broweser's cache?
Best regards,
Dmitry
Dmitry
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: TM1 Web negative number didnot allowed
HI lotsaram, There is no number format set it in the measure
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: TM1 Web negative number didnot allowed
Hi PowerDim, it is an active form report developed using perspectives. and published to the TM1 web. Excel format how to check that?
note: I am able to enter the negative number in the tm1 view but in the same combination in the tm1 web report I am not able to enter throwing an error.
note: I am able to enter the negative number in the tm1 view but in the same combination in the tm1 web report I am not able to enter throwing an error.
- PowerDim
- Posts: 13
- Joined: Thu Aug 07, 2014 12:44 pm
- OLAP Product: TM1
- Version: PAL 2x
- Excel Version: Excel 2019
- Location: Earth
Re: TM1 Web negative number didnot allowed
You need to check a format cell in a hidden area in your active form for the row you want to write values to.
Check the link for finding hidden area:
https://www.ibm.com/docs/en/planning-an ... nge_N80346
Check the link for finding hidden area:
https://www.ibm.com/docs/en/planning-an ... nge_N80346
Best regards,
Dmitry
Dmitry
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: TM1 Web negative number didnot allowed
Hi PowerDim, I have checked the format of the report. it is set to N for granular level elements (input elements). but the interesting part is I am able to input the negative numbers in the cube viewer but not able to input in the web. Any other thoughts pls?
-
- Regular Participant
- Posts: 198
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: TM1 Web negative number didnot allowed
How old is the report, has it just been created? If not try creating a new spreadsheet with a basic active form and uploading, is the result the same? Or better still have one dbrw formula pointing and see if that works.
Either way it should point you in the right direction to fixing the problem.
Also do all users experience the same issue and do the symptoms occur over different types of browsers?
I'm wondering if there's a data validation set within the format area of the active form (for n if that's what the row is using) that rejects it if the value is negative. It doesn't look like a typical error message but custom made.
Either way it should point you in the right direction to fixing the problem.
Also do all users experience the same issue and do the symptoms occur over different types of browsers?
I'm wondering if there's a data validation set within the format area of the active form (for n if that's what the row is using) that rejects it if the value is negative. It doesn't look like a typical error message but custom made.