Tm1 pax DBRW() function

Post Reply
kavitha2002
Posts: 73
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Tm1 pax DBRW() function

Post by kavitha2002 » Tue Oct 09, 2018 6:24 am

Hello Everyone,

I have used DBRW() in Active reports in Tm1 perspectives that gives "" when data not available for particular cell.

But same DBRW() in tm1 pax 2.0.5 version gives #Value!

Report looks bad when data not available.

Any suggestion on this. Thanks.

lotsaram
MVP
Posts: 3126
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Tm1 pax DBRW() function

Post by lotsaram » Tue Oct 09, 2018 6:28 am

PAX is more strict than Perspectives in terms of error value vs. blank for not existing cell intersections.
You can use conditional formatting to make the font the same colour as the cell background.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

kavitha2002
Posts: 73
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: Tm1 pax DBRW() function

Post by kavitha2002 » Tue Oct 09, 2018 11:32 am

I will try with conditional formatting. Thanks

kavitha2002
Posts: 73
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: Tm1 pax DBRW() function

Post by kavitha2002 » Fri Oct 12, 2018 7:36 am

I tried conditional formatting in excel, but in some reports problem is active reports formatting is already applied.

Say for example, White text for green background, black text white background, its dynamic based on the columns and rows changes in cube. In such a case, how to format the #VALUE! as always white. Is it possible with the conditional formatting to set "" empty string for #VAlUE, so that my problem will be solved. I hope its not possible.

Kindly get back.

User avatar
tomok
MVP
Posts: 2483
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Tm1 pax DBRW() function

Post by tomok » Fri Oct 12, 2018 11:27 am

kavitha2002 wrote:
Fri Oct 12, 2018 7:36 am
Is it possible with the conditional formatting to set "" empty string for #VAlUE, so that my problem will be solved. I hope its not possible.
Ever hear of the ISERROR function??????
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

bgregs
Posts: 24
Joined: Wed Sep 12, 2018 11:19 am
OLAP Product: TM1 / Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Tm1 pax DBRW() function

Post by bgregs » Fri Oct 12, 2018 11:45 am

+1 to tomok. Never had a desire to do this, but could you not use the infamous ";;;" and apply that to the conditional formatting as well? That would effectively make everything blank in the cell, although it would technically still be there.

Post Reply