TM1 Perspective Vs Pax

Post Reply
kavitha2002
Regular Participant
Posts: 150
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

TM1 Perspective Vs Pax

Post by kavitha2002 » Mon Nov 26, 2018 2:06 pm

Hello,

I am running the excel which has some worksheet function to pull data from TM1 and generate the report. I am performing this via vb.net code,excel sheets are protected with password, the problem is tm1 perspective working fine without prompting password, but for tm1 pax login is prompted for excel sheets.

Any idea. Why??

Paul Segal
Community Contributor
Posts: 259
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TM1 Perspective Vs Pax

Post by Paul Segal » Fri Nov 30, 2018 9:57 am

This is a bug. IBM said it had been fixed in PAX 11.0.33, but it's still there in 11.0.38. I've just (re)raised the defect with IBM.
Paul

Paul Segal
Community Contributor
Posts: 259
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TM1 Perspective Vs Pax

Post by Paul Segal » Fri Nov 30, 2018 11:33 am

So an update from support/development:
Excel prevents the dropdown from rendering on a protected sheet. This has been the behavior for past releases as well except before the fix for Defect 80174 (it is PI96773), it would prompt on selection. Once a password has been entered, the dropdowns will start rendering again. For an unlocked cell, you can edit the SUBNM formula directly or do it through the set editor after entering the unlock password. One caveat is that if the sheet is protected with no password then the dropdowns will render without a problem. This is because our protection preserver has a case where it tries to unlock with String.Empty. which succeeds when no password is set. Below are some cases to define these new behaviors.

Protected with Password
1.) Unlocked cell on protected sheet- No drop down shows, opening the set editor is allowed after entering password, and editing the formula is allowed.
2.) Unlocked cell after entering password- drop down shows, no need to enter password again through set editor, editing formula is allowed.
3.) Locked cell- No drop down shows, can't edit formula, can't open set editor.
4.) Locked cell after entering password- no dropdown shows, set editor can be opened but changes are not applied on apply and close (no message), cannot change formulas. Sheet must be unprotected through the Review tab first.

Protected without a Password
1.) Unlocked cell on protected sheet- Drop down shows, opening the set editor is allowed, and editing the formula is allowed.
2.) Locked cell- no dropdown shows, set editor can be opened but changes are not applied on apply and close (no message), cannot change formulas
I struggle to understand the logic here. If I have a protected sheet with an unprotected cell then by design I want the user to be able to access the unprotected cell, including using the set editor and dropdown if it contains a SUBNM formula. Why would I want them to put a password in if I've explicitly unprotected the cell? Am I missing something?
Paul

Paul Segal
Community Contributor
Posts: 259
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TM1 Perspective Vs Pax

Post by Paul Segal » Fri Nov 30, 2018 11:54 am

So, apparently this is expected behavior and there's no plan to change it. I'd rather have the Perspectives behavior and no drop-down myself. I'm going to raise an RFE. *sigh*
Paul

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

Re: TM1 Perspective Vs Pax

Post by Steve Rowe » Fri Nov 30, 2018 3:11 pm

Hi Paul,

Feel your pain on this one, behaviour on a unlocked cell irrespective of a password being set should be the same, i.e. "everything" works, can't see any justification for it being otherwise.

Arbitrary flipping of defects into RFE is pretty rage inducing.....it would be interesting to know what the internal policy is wrt to this process. We would then have something to base our arguments on.

One thing I have learnt when raising an issue is to never propose a solution as it appears to be short road to an RFE.

If it was me I would reopen the case and fight my corner.

kavitha2002
Regular Participant
Posts: 150
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: TM1 Perspective Vs Pax

Post by kavitha2002 » Thu Dec 06, 2018 8:50 am

Hello @Paul,

Thanks for detailed info.

Mark RMBC
Regular Participant
Posts: 194
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: TM1 Perspective Vs Pax

Post by Mark RMBC » Tue Jun 11, 2019 11:23 am

Hi,

I have a few questions re PAX and Perspectives:

Does anyone know if IBM planning to ditch/not support perspectives in the near future?

Are the following still relevant in PAX?:

"Dynamic Reports are supported in Planning Analytics for Microsoft Excel, except for cell and password protection"
Does this mean if you protect a worksheet and then deselect locked they will still be protected?

"User defined consolidations are not available. This includes the usage of DBRW worksheet functions that use subset names as a dimension element reference"
This seems quite a limitation? Am I missing something?

"The Undo capability to revert data entry changes is currently not implemented in Planning Analytics for Microsoft Excel"

Do the above apply to the web?

cheers, Mark

tomok
MVP
Posts: 2599
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 Perspective Vs Pax

Post by tomok » Tue Jun 11, 2019 12:27 pm

Mark RMBC wrote:
Tue Jun 11, 2019 11:23 am
Does anyone know if IBM planning to ditch/not support perspectives in the near future?
Your guess is as good as mine but let me point out that Perspectives is based on the legacy API and PAX is based on the REST API/MDX, AKA, the future direction. How long do you think they will continue to support a dying API?
Mark RMBC wrote:
Tue Jun 11, 2019 11:23 am
"User defined consolidations are not available. This includes the usage of DBRW worksheet functions that use subset names as a dimension element reference"
This seems quite a limitation? Am I missing something?
User-defined consolidations requires the legacy API, which PAX does not use. So does the using a subset name in a DBRW. I don't see those ever coming back.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
jim wood
Site Admin
Posts: 3726
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: TM1 Perspective Vs Pax

Post by jim wood » Tue Jun 11, 2019 1:05 pm

Mark RMBC wrote:
Tue Jun 11, 2019 11:23 am
Does anyone know if IBM planning to ditch/not support perspectives in the near future?
I've heard many different rumors / pointers on this one. I would say however I believe that their long term goal is to get rid of perspectives. They tried with Performance Modeler but we all know how well that went? The way they are going with Cafe would give you every indication. If they added a rules editor and a TI editor to cafe, why would you need perspectives? The only question for me is when,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

David Usherwood
Site Admin
Posts: 1369
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Perspective Vs Pax

Post by David Usherwood » Tue Jun 11, 2019 2:41 pm

From what I can see the aim is for PAW to take on the developer admin tasks and PAX to be purely Excel reporting and budgeting. Even on these there is a way to go since PAX does not support the new named hierarchies in Dynamic (or Static) Reports so the best way to generate decent interactive reporting is still not ready for the new features :roll:

lotsaram
MVP
Posts: 3290
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 Perspective Vs Pax

Post by lotsaram » Tue Jun 11, 2019 4:25 pm

Rule & TI editor is not coming to PAX. The home of all developer & administrator functionality will be in PAW.
Mark RMBC wrote:
Tue Jun 11, 2019 11:23 am
"The Undo capability to revert data entry changes is currently not implemented in Planning Analytics for Microsoft Excel"

Do the above apply to the web?
PAX (as Perspectives) is just the authoring tool for TM1 Websheets. Once the sheet is being consumed in TM1Web the (current) restrictions of PAX regarding cell commentary, spreading and data undo don't apply.

Regarding user defined consolidations: my personal opinion is "no big loss". I should qualify that as it is a very useful and essential feature for many users. But I have never been a fan of how it was implemented with subset within subset and subsets as pseudo-elements. Now that alternate hierarchies are available there's a much better way to implement. (But maybe IBM will do something different). No matter, providing that they do actually provide a different (and better) alternative to the current UDC implementation that's fine by me.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply