Data Input ON dbrw formula

Post Reply
dharav9
Posts: 72
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Data Input ON dbrw formula

Post by dharav9 »

Hi, All

one of our user created a template for the capital expenditure input. Basically, it contains the DBRW formula. When user tries to pass the value on it then DBRW formula overwrites the formula.

Cell is leaf level and writable cell. Pax version is 38. In viewer, user able to input the value for the same cell.

If anyone has/had found the similar issue then please share your findings.

Thank You
Dharav
Wim Gielis
MVP
Posts: 3103
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: Data Input ON dbrw formula

Post by Wim Gielis »

dharav9 wrote: Wed Feb 20, 2019 3:44 pmBasically, it contains the DBRW formula. When user tries to pass the value on it then DBRW formula overwrites the formula.
I don’t follow you I’m afraid. So a DBRW formula overwrites another DBRW formula ?
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
dharav9
Posts: 72
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Re: Data Input ON dbrw formula

Post by dharav9 »

Hi, Wim

It has been corrected in 11.06. This behavior we notified in version 11.04.

Issue:

Suppose you have cell A with DBRW formula at leaf level interaction. If we type 500 on it then it should send 500 (value) in the TM1 cube.
In 11.04, when i type 500 on Cell A then it overwrites to DBRW formula. When you click on cell then you see 500 (do not see DBRW formula)
In 11.06, it works correctly. When i type 500 on Cell A then that cell receives value 500 and also hold DBRW formula.

Please feel free if you require further explanation.

Thank You
Dharav
Wim Gielis
MVP
Posts: 3103
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: Data Input ON dbrw formula

Post by Wim Gielis »

Thanks for the update. I hadn't noticed this bug in 2.0.4 but glad to see it's solved in 2.0.6 (the one I'm using now on my personal laptop until 2.0.7 will be launched).
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
Post Reply