Planning Analytics

 View Only
Expand all | Collapse all

PAFE tmrrptview with BzeroSuppression is aleatory

  • 1.  PAFE tmrrptview with BzeroSuppression is aleatory

    Posted 26 days ago
    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
    ------------------------------


  • 2.  RE: PAFE tmrrptview with BzeroSuppression is aleatory

    Posted 22 days ago

    It is hard to say much without really understanding the workload in detail, but I will say that Websheets and Perspectives both have some issues working when custom formulas are combined inline with other operations (compound formulas), PA for Excel works at function granularity, not formula, so it's behavior should most accurately model proper functional outcomes.  There is even more nuance with Dynamic Reports since PA for Excel will also run data-sensitive rowset outcomes in strict relation to the spatial geometry of the report. These characteristics are documented, albeit in summary, but it should absolutely be possible to get the outcome you're looking for from PA for Excel - may need to make some aspect of the report more explicit to achieve your goal.

    Best to engage with support where we can go over the specifics of your workload in depth.



    ------------------------------
    Ted Phillips
    IBM
    ------------------------------



  • 3.  RE: PAFE tmrrptview with BzeroSuppression is aleatory

    IBM Champion
    Posted 21 days ago

    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
    ------------------------------



  • 4.  RE: PAFE tmrrptview with BzeroSuppression is aleatory

    IBM Champion
    Posted 20 days ago
    Hi Ann-Grete,

    Did u try grouping the column instead as that normally works for me.






  • 5.  RE: PAFE tmrrptview with BzeroSuppression is aleatory

    IBM Champion
    Posted 20 days ago

    Amin:

    Thank you for your suggestion! 

    However if by "grouping" you mean using the "Group"/"Ungroup" functionality under the Excel Data menu - then in my case hiding the column using a Group behaves the same way as simply hiding the column, and does not solve the problem of driving the zero-suppress behavior of TM1RPTVIEW/TM1RPTROW when *all* your DBRW() formulas are components of another expression e.g. DBRW()/1000. I have found that I need to have an unhidden column with "clean" DBRW() formulas pointing at the appropriate TM1RPTTITLE combinations to get the behavior I want. Fortunately white-on-white formatting does the trick.

    Besides I am unfortunately stuck in an older version of PA and PAW at this particular client, and it is possible that the behavior is better in newer versions.

    Best regards,

    Ann-Grete



    ------------------------------
    Ann-Grete Tan
    agtan@tensorresearch.com
    ------------------------------



  • 6.  RE: PAFE tmrrptview with BzeroSuppression is aleatory