Automatic commit of data entry in TM1 Web sheets via PAW

Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2161
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Automatic commit of data entry in TM1 Web sheets via PAW

Post by Steve Rowe » Mon Mar 29, 2021 10:58 am

Hi,
I've had a good old hunt around in the various cfgs and so forth but can't find an option for what I want to do.

So, is there a way of configuring TM1 web sheets access through PAW (from Pafe) so that cell values are committed to the DB on entry and the sheet refreshed, i.e. automatic calculation?

I though that I'd managed this before but I don't seem to be able to recreate.

Cheers,
Technical Director
www.infocat.co.uk

User avatar
gtonkin
MVP
Posts: 900
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.9.4; PAoC 2.0.9.3
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Automatic commit of data entry in TM1 Web sheets via PAW

Post by gtonkin » Mon Mar 29, 2021 3:49 pm

Going for a wild swing here as I have not seen anything either but what comes to mind is the option to Commit immediately in the Manage Features on PAW. Possibly only for the cube viewer but cannot recall exactly.
Not in a position to get the exact name or test but HTH (or someone else can).

User avatar
Steve Rowe
Site Admin
Posts: 2161
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Automatic commit of data entry in TM1 Web sheets via PAW

Post by Steve Rowe » Tue Mar 30, 2021 8:37 am

Thanks, I'm on prem (if that matters) and I don't see this (or any) option in the manage features space for the various releases I have available to me right now..
Technical Director
www.infocat.co.uk

declanr
MVP
Posts: 1706
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: Automatic commit of data entry in TM1 Web sheets via PAW

Post by declanr » Tue Mar 30, 2021 9:42 am

I don't use websheets much nowadays but in a previous build (before PAW even existed) I remember adding a cheat method on particular websheets.
If users were entering data to "Revenue" as a measure element I would add a consolidation called "Revenue_Input" that only contained "Revenue" as a child, the users then worked in "Revenue_Input" (without realising it) in the websheet and the default behaviour for entering data at a consolidation forced a recalc.

Not the prettiest solution when you know what is going on but the whole point of a websheet is that users have no idea what is going on and it got the job done.

I definitely expect there is a better way to achieve this but when all else fails...
Declan Rodger

User avatar
Steve Rowe
Site Admin
Posts: 2161
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Automatic commit of data entry in TM1 Web sheets via PAW

Post by Steve Rowe » Tue Mar 30, 2021 11:37 am

Thanks Declan, interesting approach though not really practical in my situation, you'd think we could just flip a switch somewhere.....
Technical Director
www.infocat.co.uk

Post Reply