DBS should fail, hard!

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

DBS should fail, hard!

Post by Steve Rowe » Fri Jul 03, 2020 1:39 pm

Hi, if you agree with this RFE please take the time to vote.

https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-331

I bet I don't get 10 likes!

In Pafe when a user executes a DBS against a cell which is not writeable the formula returns the value of the cell. Not writeable means C level, read-only access, write access but locked.

This is counter productive, the job of the formula is to send data to TM1 and report success or failure.

There is now no difference in cell state between the formula successfully working or not. This means that in Pafe every DBS execution needs full reconciliation post send to test for success, this should not be required.

In the legacy clients sending to a non-writeable cell meant that the formula showed an error, a clear and obvious indication of a fault.

Imagine designing TI processes such that they always report success and suppress all error messages. Makes no sense, the same logic as to why a TI process has errors and so forth applies to DBS formula.

TIA for anyone taking the time to vote.

User avatar
gtonkin
MVP
Posts: 807
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: DBS should fail, hard!

Post by gtonkin » Fri Jul 03, 2020 1:59 pm

Sounds like it is borked.

Here's the link if anyone needs it:

+1

Wim Gielis
MVP
Posts: 2487
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: DBS should fail, hard!

Post by Wim Gielis » Sun Jul 05, 2020 9:58 am

Steve Rowe wrote:
Fri Jul 03, 2020 1:39 pm
I bet I don't get 10 likes!
Currently, you have 8 so 2 remaining.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Updating process line numbers with AutoHotKey

User avatar
Alan Kirk
Site Admin
Posts: 6163
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: DBS should fail, hard!

Post by Alan Kirk » Sun Jul 05, 2020 10:47 am

Wim Gielis wrote:
Sun Jul 05, 2020 9:58 am
Steve Rowe wrote:
Fri Jul 03, 2020 1:39 pm
I bet I don't get 10 likes!
Currently, you have 8 so 2 remaining.
I've already cast mine...
"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.

User avatar
Alan Kirk
Site Admin
Posts: 6163
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: DBS should fail, hard!

Post by Alan Kirk » Mon Jul 06, 2020 8:59 am

Alan Kirk wrote:
Sun Jul 05, 2020 10:47 am
Wim Gielis wrote:
Sun Jul 05, 2020 9:58 am
Steve Rowe wrote:
Fri Jul 03, 2020 1:39 pm
I bet I don't get 10 likes!
Currently, you have 8 so 2 remaining.
I've already cast mine...
14 and counting. When does our bet money arrive in our accounts?
"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.

Wim Gielis
MVP
Posts: 2487
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: DBS should fail, hard!

Post by Wim Gielis » Mon Jul 06, 2020 10:21 am

Alan Kirk wrote:
Mon Jul 06, 2020 8:59 am
14 and counting. When does our bet money arrive in our accounts?
When IBM have implemented it 😉
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Updating process line numbers with AutoHotKey

HighKeys
Posts: 97
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Re: DBS should fail, hard!

Post by HighKeys » Wed Jul 08, 2020 8:39 am

Wim Gielis wrote:
Mon Jul 06, 2020 10:21 am
Alan Kirk wrote:
Mon Jul 06, 2020 8:59 am
14 and counting. When does our bet money arrive in our accounts?
When IBM have implemented it 😉
So never :lol:

Post Reply