DBRW vs DBR in PAx

Post Reply
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

DBRW vs DBR in PAx

Post by iansdigby »

Hi all,

In the documentation for Planning Analytics for Excel, IBM states:
" the DBR function is equivalent to the DBRW function".
It goes on to say that both are optimised for network traffic.
As regards the VIEW function: "VIEW is primarily used for compatibility with TM1® TM1 Perspectives worksheets"

Does this mean that when building new stuff in PAx, the DBRW() + VIEW() construct is now redundant and that the same effect is achieved with simple DBR()?

Thanks for all wisdom/comments.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
jim wood
Site Admin
Posts: 3952
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: DBRW vs DBR in PAx

Post by jim wood »

Not sure about PAX but I've always found the excel timing of both to be different. It'd be interesting to see if that has changed,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
gtonkin
MVP
Posts: 1202
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: DBRW vs DBR in PAx

Post by gtonkin »

Guessing that DBR and DBRW would be the same now as PAfE should be leveraging the REST API and no need for two functions.
Not sure on the VIEW function and how stargates would be triggered though.
Post Reply