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,
Automatic commit of data entry in TM1 Web sheets via PAW
- Steve Rowe
- Site Admin
- Posts: 2410
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Automatic commit of data entry in TM1 Web sheets via PAW
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Automatic commit of data entry in TM1 Web sheets via PAW
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).
Not in a position to get the exact name or test but HTH (or someone else can).
- Steve Rowe
- Site Admin
- Posts: 2410
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Automatic commit of data entry in TM1 Web sheets via PAW
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
www.infocat.co.uk
-
- 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: Automatic commit of data entry in TM1 Web sheets via PAW
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...
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
- Steve Rowe
- Site Admin
- Posts: 2410
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Automatic commit of data entry in TM1 Web sheets via PAW
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
www.infocat.co.uk