DBRW in Excel

Post Reply
Neelutm1
Posts: 17
Joined: Tue Nov 13, 2018 3:16 am
OLAP Product: COGNOS TM1
Version: 10.2.2
Excel Version: 2010

DBRW in Excel

Post by Neelutm1 » Thu Mar 12, 2020 5:25 am

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
MVP
Posts: 3359
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: DBRW in Excel

Post by lotsaram » Thu Mar 12, 2020 9:18 am

Nope. PAX utilizes MDX & Rest API which don't presently have any concept of using subsets as pseudo-consolidations.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Mark RMBC
Regular Participant
Posts: 218
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: DBRW in Excel

Post by Mark RMBC » Thu Mar 12, 2020 11:37 am

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

Post Reply