TM1 Web and STET

Post Reply
ylr
Posts: 6
Joined: Fri May 07, 2010 12:58 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

TM1 Web and STET

Post by ylr »

Hello,

I have a rule that calculates value for actual period and lets user input value in forcast period. Rule uses IF to compare act/progn periods and STET to make forecast writable.

The problem is, that in TM1 Web forecast cells are gray. Architect shows rows normally, user can input forecast values.

What should I do about that, or is it bug?

y.
TM1 9.5.2 FP3
whitej_d
Community Contributor
Posts: 103
Joined: Mon Sep 05, 2011 11:04 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: TM1 Web and STET

Post by whitej_d »

Double check the configuration of your view. TM1web should show the same as architect. ie White cells for leaf level writable and grey for consolidated/rule calculated cells.

Are you using the same named view, and are you logging on to architect and TM1web as the same user, as security can also cause cells to become unwritable.

There is a configuration option to disable writeback in web, you may want to check it's not enabled.
ylr
Posts: 6
Joined: Fri May 07, 2010 12:58 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: TM1 Web and STET

Post by ylr »

Same view, same user, so it should look similar, but it doesnt.

Could you specify the location of writeback option for web?
whitej_d
Community Contributor
Posts: 103
Joined: Mon Sep 05, 2011 11:04 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: TM1 Web and STET

Post by whitej_d »

Sorry, I think I may have got my wires a bit crossed. You can disable writeback for websheets using the application properties. I think you can't actually disable writeback for TM1web views. I thought there was a parameter for this somewhere, but I can't find it anywhere. I'd be interested if anyone knows of one?
User avatar
jim wood
Site Admin
Posts: 3961
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: TM1 Web and STET

Post by jim wood »

There are known issues with STET and EV. I'm not sure TM1 Web. I would do a search on here just to check to see if somebody else has encountered this.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
ylr
Posts: 6
Joined: Fri May 07, 2010 12:58 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: TM1 Web and STET

Post by ylr »

Sample of views, tm1web vs architect:

Image
lpahnke
Posts: 18
Joined: Thu Jun 14, 2012 9:55 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: TM1 Web and STET

Post by lpahnke »

I may be off base here, but we encountered what I think is the same problem, when we tried installing FP3 for 9.5.2, which is the version you're on. Basically in most cubes you couldn't enter numeric data in TM1 Web, but Architect worked fine. IBM has confirmed it's a defect - I've posted more information here: http://www.tm1forum.com/viewtopic.php?f ... 528#p38528
Post Reply