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.
Tm1 pax DBRW() function
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
-
- MVP
- Posts: 3654
- 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
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.
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.
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
Re: Tm1 pax DBRW() function
I will try with conditional formatting. Thanks
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
Re: Tm1 pax DBRW() function
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.
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.
-
- MVP
- Posts: 2832
- 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
Ever hear of the ISERROR function??????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.
-
- Posts: 77
- Joined: Wed Sep 12, 2018 11:19 am
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: Tm1 pax DBRW() function
+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.