Page 1 of 1

DBRW in Excel

Posted: Thu Mar 12, 2020 5:25 am
by Neelutm1
HI Team,
Is it possible to use Subset reference in DBRW formulas in PAX?
users have Pre-existing reports which they want to see the values as total for all subset elements.
Any suggestion how this can be achieved in PAX.


Thanks in advance

Regards,
Neelima

Re: DBRW in Excel

Posted: Thu Mar 12, 2020 9:18 am
by lotsaram
Nope. PAX utilizes MDX & Rest API which don't presently have any concept of using subsets as pseudo-consolidations.

Re: DBRW in Excel

Posted: Thu Mar 12, 2020 11:37 am
by Mark RMBC
Hi,

FYI this was previously discussed here:

https://www.tm1forum.com/viewtopic.php? ... 380#p72795

Personally I nearly fell off my chair when I first heard about this!

regards,

Mark