DBRW in Excel

[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

[lotsaram]

Nope. PAX utilizes MDX & Rest API which don't presently have any concept of using subsets as pseudo-consolidations.

[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