PA Workspace - what can it do?

ultrakocka
Posts: 12
Joined: Thu Dec 07, 2017 11:17 am
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: 2016

PA Workspace - what can it do?

Post by ultrakocka »

Hello,

we're starting a new project and it's been decided to do it only in PAW. My problem is I just don't see it happening as it just doesn't have many features needed to make a functional application. I've been reading through other older topics and PA Workspace documentation and just wanted to confirm that I'm right on this (PA Workspace 2.0.57).

1) It's not possible to show custom error messages after running process with active button.
2) It's not possible to directly pass a selected cell/element in dimension to a process as parameter.

Thanks!
Simon
User avatar
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: PA Workspace - what can it do?

Post by Steve Rowe »

Hi Simon,

Not natively no but it's easy to build your own solution for both these issues.

If you have a cube that is dimensioned by }Users and a Measure dimension containing all the references for interaction with the front end then.

For 1 you can set-up picklists in this cube that are driven by the dimension / subset of interest.
The view of the front end cube can be limited to the user viewing it using an MDX subset.
Then in the TI you can determine the user calling the TI and read the value from your front end cube.

For 2 you can write the message back to the cell in the front end cube and display this in PAW.

I find this approach much easier than setting up TIs with loads of parameters, it's much easier to write the script to read the "parameters" and then assign these values to a global variable, its much more flexible.

Should be possible in both TM1Web and PAW and don't forget web sheets can be published through PAW too.
Technical Director
www.infocat.co.uk
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: PA Workspace - what can it do?

Post by MarenC »

Hi,

Unless I am missing something I would have to slightly disagree with Steve here.

Yes you can set up cubes etc, but there are times when you want to pass parameters to processes.

For example we have an employee move process and when the user navigates to the Move process tab it ask=s them to provide the
employee parameter. This is so we can run some pre-processes and add the employee as an attribute to the client.

Having another cube to handle all this is just messy for the end user.

Not having the ability to pass parameters from cell references is a limitation of workspace and hampers a fully integrated planning solution as
far as I am concerned. It is also annoying that you can't pass title elements when navigating etc.

I admit you can still use websheets for some of these issues but I think workspace needs more improvement in these areas rather than any new fancy front end dashboarding that the sales guys just love!

Maren
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: PA Workspace - what can it do?

Post by Elessar »

Hi,

The button parameters synchronization was well discussed here

To be short, there are 2(3) options now:
  1. Use tiny websheet only with active button in it. Active button takes parameters from SUBNMs, who are hidden and can be synchronized with PAW filters.
  2. Picklists and view with MDX pointing on them
  3. Wait :). Here IBM says that "This one of the highest priority items in our feature backlog. We are working to bring it forward"
Last edited by Elessar on Thu Nov 19, 2020 1:47 pm, edited 1 time in total.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
User avatar
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: PA Workspace - what can it do?

Post by gtonkin »

ultrakocka wrote: Thu Nov 19, 2020 11:49 am ...
1) It's not possible to show custom error messages after running process with active button.
...
For 1) above, I write various values to a process log cube. You can add the cube view to your canvass, right click on the cell containing the message then add that to the canvass by clicking "Add to sheet".

There are obviously nuances and limitations - cell is now a static reference like using a DBRW with hard-coded values for each dimension but depends on your cube design.

Check out the Ideas site to see what people are asking for and vote to get functionality we are all looking for included:
References of Cells added to sheets to be maintainable
PAW Action Button ability to get parameters from selectors
PAW Synchronise Action Button parameters with Sheet Selections
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: PA Workspace - what can it do?

Post by luizg2019 »

ultrakocka wrote: Thu Nov 19, 2020 11:49 am 1) It's not possible to show custom error messages after running process with active button.
Since PAW 2.0.49 is possible to display custom error messages after executing a process via button.

Image
User avatar
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: PA Workspace - what can it do?

Post by Steve Rowe »

Hi,
Good shout on the error message luzig2019, hadn't picked this up.

On the "passing parameters" piece. I'm not going to pretend that what we have now is perfect but working with the tools we do have I would argue that we can get to 95% of where we need to be, which is normally good enough.

I'd also argue that, for the developer, taking the approach of using picklists and global variables instead of parameters has significant advantages.
  • Action buttons are much more stable since they don't have parameter references. If I need to add a parameter to a TI I don't need to update all the action buttons that reference that TI. It is also much easier to set the action buttons up in the first place.
  • There is a permanent record at the user level of what the TI was called with, the last run will show in the pick list cube and if you have logging on you'll see the history in the transaction log. This is very very useful when it comes to tracking of issues and audit trail.
  • Setting parameters up in a TI is a manual process, if I have the same parameter being used and passed down a chain of TIs then this is a PITA to set-up. With the picklist / global vars approach this isn't required and the script can be copied and pasted between TIs leading to development time savings, quality of life improvements and reduction of opportunity for error.
  • Picklists have error checking built in versus allowing manual entry of element names or other object references. This saves time on the scripting side as we don't need error checking in each TI.
  • Consistency of variable names becomes much easier to achieve / enforce with the use of Global Variables. It becomes somewhat like working with VBA with Option Explicit turned on, normally considered to be a good thing.
For example in the master TI for a call sequence I would have

StringGlobalVariable('sMonthToLoad');
sMonthToLoad=CellGetS('Front End Cube' , TM1User , 'Month To Load');

In all the downstream TIs where I need the month I put, IMO much easier than working with parameters.

StringGlobalVariable('sMonthToLoad');

So IMO parameters aren't the panacea that people imagine them to be, it is not 100% upside. They would be useful though, especially for simpler apps and in some circumstances would reduce the time to build. If anyone from IBM reads this, I'm not saying we don't need the functionality, I don't fancy waking up with a horses head in my bed!

Cheers,
Technical Director
www.infocat.co.uk
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: PA Workspace - what can it do?

Post by MarenC »

Hi Steve,

thanks for the further explanation. I would not like to accept or refute what you say without actually trying it!

But we would need error checking in each TI because the user might not update the cube and simply go ahead and run the process!?

Maren
User avatar
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: PA Workspace - what can it do?

Post by Steve Rowe »

But we would need error checking in each TI because the user might not update the cube and simply go ahead and run the process!?
Yeah that's a small wrinkle of TM1 picklists, is that a blank is allowed. Fairly easy to check for this single exception.

Interestingly when they were first implemented and for years afterwards a blank was not an allowed option in the picklist, they had to match exactly to the definition. "Everyone" used to moan loudly about this.

Eventually IBM added the possibility of selecting a blank reference (but crucially didn't allow the developer the option of including this or not in the definition of the picklist).

This weakened the quality of picklists for some use cases and strengthened it for others.

Just really illustrates that with most pieces of functionality few things are as clear cut as people imagine and we all have a tendency to think that our use case is the most special that absolutely most be supported and be a top priority for IBM (DBRH anyone???)
Technical Director
www.infocat.co.uk
ultrakocka
Posts: 12
Joined: Thu Dec 07, 2017 11:17 am
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: 2016

Re: PA Workspace - what can it do?

Post by ultrakocka »

Thanks all for valueable ideas!

- ItemReject indeed solves (somehow unexpectedly) the problem with custom messages which I had.

- Using "front-end" selection/picklist cube for passing parameters to process is .. well, why not, I can definitely imagine using it, but quite different way of doing things than I'm used to. We'll give it a try as it seems quite reasonable solution, just hope the overhead won't prove too large.

Best regards,
Simon
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: PA Workspace - what can it do?

Post by luizg2019 »

Steve Rowe wrote: Thu Nov 19, 2020 3:56 pm Hi,
Good shout on the error message luzig2019, hadn't picked this up.
It seems like barely anyone noticed this new feature :lol:
Should I make a topic about this on the "Useful code, tips and tricks" section?
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: PA Workspace - what can it do?

Post by Wim Gielis »

luizg2019 wrote: Wed Nov 25, 2020 2:49 pm Should I make a topic about this on the "Useful code, tips and tricks" section?
Sure, please do so 👍
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: PA Workspace - what can it do?

Post by Alan Kirk »

luizg2019 wrote: Wed Nov 25, 2020 2:49 pm
Steve Rowe wrote: Thu Nov 19, 2020 3:56 pm Hi,
Good shout on the error message luzig2019, hadn't picked this up.
It seems like barely anyone noticed this new feature :lol:
Should I make a topic about this on the "Useful code, tips and tricks" section?
I don't think you can; IIRC posting rights in that forum require at least MVP rank. But if you create one in the main forum one of the admins can move it for you.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Emixam
Posts: 139
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: PA Workspace - what can it do?

Post by Emixam »

I tried luizg2019 solution in PAW but apparently only users with ADMIN access can see the custom error message. Normal users (non-admin) only see "Process completed with messages". Am I missing something here ?
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: PA Workspace - what can it do?

Post by Mark RMBC »

Hi Emixam,

this is a bug that appeared around version 62 or so. Well the first bug was that it didn't return any message and then by fixing that they introduced the bug that only admin users see it.

I raised this on the IBM community forum and surprisingly got no response, see here:

https://community.ibm.com/community/use ... gestviewer

I also raised it with IBM support and got the following response:

"The issue has been reproduced in PAW 63 and I will log a defect investigation for it. I will keep you updated."

regards,

Mark
User avatar
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: PA Workspace - what can it do?

Post by gtonkin »

I have worked around this for now by having a check in Epilog to check if any errors were encountered in previous tabs e.g.
nErrorCount=PrologMinorErrorCount+MetadataMinorErrorCount+DataMinorErrorCount;

If we have errors, I then fire off an email process with the relevant log attached. Chances are that this will remain in place.
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: PA Workspace - what can it do?

Post by Mark RMBC »

Hi George,

I really hope it doesn't stay in place. If a user process errors I want an instant message on screen for the user to view, it is far from ideal if they have to open an email which has been sent to them!

My reading of IBM's response is that they regard it as a defect, and so do I!

regards, Mark
User avatar
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: PA Workspace - what can it do?

Post by gtonkin »

Mark RMBC wrote: Wed Jun 23, 2021 3:45 pm Hi George,

I really hope it doesn't stay in place. If a user process errors I want an instant message on screen for the user to view, it is far from ideal if they have to open an email which has been sent to them!

My reading of IBM's response is that they regard it as a defect, and so do I!

regards, Mark
100% Mark - needs to be immediately visible to the users with all the expected detail. I will keep the email as an additional item and possibly only notify the custodian in the future as there may be something they need to address. Also quicker than trying to locate the log in PAW later.

I have also had mixed results in errors message handling when processes are run from the database pane vs action buttons. Will be checking those results again too to ensure behaviour is the same.
Emixam
Posts: 139
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: PA Workspace - what can it do?

Post by Emixam »

Mark RMBC wrote: Wed Jun 23, 2021 3:45 pm My reading of IBM's response is that they regard it as a defect, and so do I!
Thanks for your answer Mark. So you already raised a ticket to IBM ?
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: PA Workspace - what can it do?

Post by Mark RMBC »

So you already raised a ticket to IBM ?
Yes!
Post Reply