But the more general case is where you may have a good reason to put some other Excel logic around your DBRW() rather than building the calculation into a rule or something.
I just tried this with a newer version of PAW than I was referencing in my earlier post and it works fine in PAfE, but generates no rows in PAW. However (good news) with a more recent version of PAW there was no problem adding a column with a "clean" DBRW and then hiding it, which is a fine solution.
In the ancient (2+ years old) version I tried this with before column-hiding was not an option so I had to resort to "white on white" formatting to make it work.
Anyway - it's been a good conversation, and a great example of how TM1 still provides many ways to making things work!
Original Message:
Sent: Fri April 05, 2024 03:43 PM
From: George Tonkin
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Coming in a bit late here and it is Friday but is this not as simple changing the format of the cells to display in thousands in Excel i.e. #,##0.00,;-#,##0.00,
------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
Original Message:
Sent: Fri April 05, 2024 01:38 PM
From: Philippe CHAMPLEBOUX
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Hello,
Tested with Ibm support engineer.
Divide by 1000 is the explanation.
The support ask me to test https://tm1explorers.com/forums/topic/dbrw-not-working-in-tm1web.
I made an other thing :
have a column with a correct and simple dbrw() formula ..... and Excel Hide this column
have one or several column with "my" compound formula
It work fine for me on tm1web
In conclusion :
- Use excel format mask to show number divide by 1000
- Use an other indicator as suggest Luke ( very nice and elegant, I think also)
- Use a great and conform Column (Hide it in excel) .... it work for me
And, above all, don't expect IBM to correct anyth :-(
regards,
Philippe
------------------------------
Philippe CHAMPLEBOUX
Original Message:
Sent: Fri April 05, 2024 07:51 AM
From: Philippe CHAMPLEBOUX
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Ann-Grete
I find an old (very old) IBM documentation (03 February 2021) ... Compound DBRW formulas are not supported in TM1 Web (ibm.com)
Wich explain ..... we have no solution except Mine or Luc' solution.
I come back as soon I have talk with ibm support engineer
Regards,
Philippe
------------------------------
Philippe CHAMPLEBOUX
Original Message:
Sent: Wed April 03, 2024 08:02 AM
From: Ann-Grete Tan
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Luc
That's a really nice and elegant solution for this specific situation - thank you for sharing it!
However I am afraid I refuse to accept that "keeping DBRW formulas pure" should be considered "best practice" :-)
Let's acknowledge instead that it is a LIMITATION. There is no reason Dynamic Reports should not be able to parse formulas on any TM1RPTROW line for DBRWs. But as long as there is an acceptable workaround (and in this case there are several) there are other things I would prioritize.
Thank you,
Ann-Grete
------------------------------
Ann-Grete Tan
agtan@tensorresearch.com
Original Message:
Sent: Wed April 03, 2024 03:06 AM
From: Luc Cusiel
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Hi Ann-Grete, as a best practice I would try to keep the DBRW formulas as plain as possible. You could move the calculation for the k-value to the corresponding measure dimension by leveraging the weight property:
Kind regards,
Luc
![](https://dw1.s81c.com//IMWUC/MessageImages/6eb7668cee3d40838a19b49539096a14.png)
------------------------------
Luc Cusiel
Original Message:
Sent: Tue April 02, 2024 04:39 PM
From: Ann-Grete Tan
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Phillipe:
I have run into exactly this situation with Dynamic Reports and PAW, and the only way I have been able to resolve it is to create an extra "invisible" column with the pure DBRW() formula in it to drive the zero suppression. Then I make the column narrow and format the text to be the same color as the background. Unfortunately HIDING the column in Excel does not work: once the column is hidden it becomes invisible to TM1RPTVIEW and all its related functions.
If you find a better solution, please let me know!
Best regards,
Ann-Grete
------------------------------
Ann-Grete Tan
agtan@tensorresearch.com
Original Message:
Sent: Thu March 28, 2024 12:34 PM
From: Philippe CHAMPLEBOUX
Subject: PAFE tmrrptview with BzeroSuppression is aleatory
Hi,
I use PAFE 2.0.94.7 and want to make a sample reporting :
I use tm1rptView with BZeroSuppression=1
When I use DBRW(.....) it work as wanted
When I use DBRW(.....) / 1000 no data !!
When I make other modifications, in a very random way, "BZeroSuppression" make that no line is carried over. (even if the have data)
I've tried deleting TM1RPTTITLE but, again, it's very random.
Once published, the behavior on this subject is not identical between PAFE and tm1Web.
I need some help to understand :
why BZeroSuppression supress all ligne, even with value
why PAFE and tm1Web are different
Which parameter I can use to securize the comportment.
Best Regards,
Philippe
------------------------------
Philippe CHAMPLEBOUX
------------------------------