Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Design Mode

    Posted 09/08/20 12:25 AM
    Hi, I am trying to test the design mode in Custom Report or Dynamic Report. But neither of them work as to the descriptions from the document.
    Whenever I copy and past any static value into cells with DBRW formulas inside it already in the reports, it always replace it with those static values. It didn't preserve any DBRW formulas at all regardless of the design mode was turned on or off.

    Preserve or clear DBRW formulas when you are pasting values into cells

    When Design Mode is on, you can copy and paste values into cells and clear any DBRW formulas in those cells.

    When Design Mode is off, you can preserve the DBRW formulas when you are copying and pasting into cells that contain DBRW formulas.


    Do I miss anything here? I am using PAfE 55 on PAL2.0.9.1 with PAW 46. Thanks.

    ------------------------------
    mvp morgan
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Design Mode

    Posted 09/08/20 05:56 AM

     

    Design Mode is a handy tool that can be used to enable or disable the refreshing of an Exploration View upon every change. You can now also use Design Mode to preserve or clear DBRW formulas when you are copying and pasting values into cells.  

    https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/c_pax_new_features_2_0_50.html

     

    Here is information on refreshing - https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/t_ug_cxr_refreshingdataincafeworkbooks.html

     

    One area that you can try as part of managing calculation is using constrain calculations

    https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_pax_constrainedcalculations.html

    Does this help?

    ------------------------------
    paul YOUNG
    ------------------------------



  • 3.  RE: Design Mode

    Posted 09/08/20 06:02 AM
    It would help if we could turn on/off constrained calculations as an option, rather than in an obscure .json file...

    ------------------------------
    Paul Segal
    ------------------------------

    Original Message


  • 4.  RE: Design Mode

    Posted 09/08/20 07:58 AM
    Hi Paul,  I would log an enhancement request for constrain calculation.

    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 5.  RE: Design Mode

    Posted 09/08/20 09:20 PM
    Thanks, Paul. After several testing, I just realized this function doesn't work with just only one cell's copying and pasting. If more than one cells, it works as expected. :)

    ------------------------------
    mvp morgan
    ------------------------------

    Original Message


Related Content