Search found 7 matches

by shane.james
Mon Jun 21, 2021 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: #Value on PAfe but not Tm1Web/PAW or perspectives
Replies: 9
Views: 6126

Re: #Value on PAfe but not Tm1Web/PAW or perspectives

Yes, we have tried on multiple machines and different logins. We know the sheet, links and members work 100% because when the report is opened in TM1web or PAW, it is perfect. It is only in PAfE that the #Values appear. If you select an individual cell it evaluates, but the moment you refresh the sh...
by shane.james
Mon Jun 21, 2021 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: #Value on PAfe but not Tm1Web/PAW or perspectives
Replies: 9
Views: 6126

Re: #Value on PAfe but not Tm1Web/PAW or perspectives

Thanks. All addins are there, other reports open with no problem. The other reports were built originally in Perspectives.

The issue seems to be with this new report the client has tried to create. I've tried all the little "tricks" that I can think of, but no luck
by shane.james
Mon Jun 21, 2021 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: #Value on PAfe but not Tm1Web/PAW or perspectives
Replies: 9
Views: 6126

Re: #Value on PAfe but not Tm1Web/PAW or perspectives

Thanks for the reply.

Sadly 1 and 2 didn't change anything.

I tried using just the Principal name. It seemed to initially look like it was working. But the moment I refreshed the workbook it all went back to #Value.

IBM helpdesk don't even seem to know what is going on
by shane.james
Mon Jun 21, 2021 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: #Value on PAfe but not Tm1Web/PAW or perspectives
Replies: 9
Views: 6126

#Value on PAfe but not Tm1Web/PAW or perspectives

Hi All Client is experiencing a weird scenario. He is getting #Value in all his cells on a report. However when he opens the same report in Tm1web or PAW, it works perfectly. I did the usual checks on the report to see if there was and DBRW referencing other DBRW etc, but it is a actually a very sim...
by shane.james
Wed Jun 09, 2021 4:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 5686

Re: Rule set value to zero

Awesome. Thanks guys. Definitely confirmed my thinking. Will need to play around with the feeders in these models as the zero cells were fed
by shane.james
Tue Jun 08, 2021 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW currency formatting
Replies: 0
Views: 13624

PAW currency formatting

Hi I have a situation where I have used the PA currency formatting for some of my measures. But when displayed in a view in PAW. I have one user who sees the values in $ and all others in £. The user claims that all their other setting when viewing currency in excel (for example) are in £. She only ...
by shane.james
Tue Jun 08, 2021 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 5686

Rule set value to zero

Hi All Needing some clarity here. I have had to take over some projects and on checking the rules I have seen on numerous occasions where there is a rule to set a value to zero (usually to ensure no one can capture a value in the cell). Now my understanding is that if that cell is not fed, then ther...