Planning Analytics

 View Only
  • 1.  Ask Me Anything: Planning Analytics - June Edition

    Posted Thu March 31, 2022 02:23 PM
    Edited by System Fri January 20, 2023 04:38 PM
    Summary

    Modeling, budgeting, forecasting, reporting, multidimensional analysis-there's a lot you can do with IBM Planning Analytics. Chances are you're just scratching the surface.
     
    Join us live for our monthly "Ask me Anything" session, designed to answer all of your burning IBM Planning Analytics questions from product roadmap to upgrades, hosted by a member of our Product Management team. Each month we'll feature different members of the IBM Planning Analytics team from development, to quality assurance, to lab services.

    Please join us in this on-demand recording. Share your questions below and register to watch here.


    ------------------------------
    Michael McGeein
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Thu June 02, 2022 01:11 PM

    Hello

    We use the ProportionSpreadToZeroCells=F parameter to disable equal spread to the empty cells. We currently do this by directly editing the tm1s.cfg file. We have not seen this parameter available in database administration in PAW. If direct access to tm1s.cfg file will no longer be available in the Planning Analytics Engine new version, how can we configure this parameter?


    ------------------------------
    Jose Luis Senas
    Data Analyst
    Kimberly-Clark Mexico
    Mexico City
    ------------------------------



  • 3.  RE: Ask Me Anything: Planning Analytics - June Edition

    IBM Champion
    Posted Fri June 03, 2022 01:45 AM
    Edited by System Fri January 20, 2023 04:44 PM

    HI Jose,
    You can already manage this via the REST API and would need to do so in the future.

    I manage this through Excel calling the REST API via VBA but you could do this via TM1py using update_static_configuration or via Postman e.g.


    In TM1py, you could execute something like this:
    d = {
    "Modelling": {
    "Spreading": {
    "ProportionSpreadToZeroCells": False
    }
    }
    }
    response=tm1.server.update_static_configuration(d)

    ------------------------------
    George Tonkin
    ------------------------------



  • 4.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Wed June 08, 2022 03:48 PM
    Two questions related to one thing: Auto-complete (Intellisense) in TI process editor in the workbench quality of life improvements. 

    1. When using Tab to accept an auto-complete suggestion the cursor jumps to the end of the line instead of just to the end of the auto-completed word. The modeller then has to use the arrows or mouse to return to just after the auto-completed word. Can it be considered as a quality of life improvement to have the cursor only jump to the end of the auto-completed phrase? This happens when adding a function in an if statement and sometimes when filling in parameters to functions in a TI.
    2. Is context-aware auto-complete for typing a process name in an executeprocess() command a possible feature? Currently, when auto-complete is invoked it provides the complete list of processes and the modeller has to scroll through the list to find the relevant process.

    Thanks! 

    ------------------------------
    Donovan Andrews
    ------------------------------



    ------------------------------
    Donovan Andrews
    TM1/Planning Analytics Consultant
    Cortell CPM
    ------------------------------



  • 5.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Wed June 08, 2022 06:35 PM
    Hi,

    Couple of questions for the AMA:

    1. When will more detailed formatting options be available with the new cube viewer/exploration in PAW i.e. individual row and column formatting (not condition based) and attribute based formatting etc. Hoping to be able to produce presentable reports without using Excel or CA.
    2. Can there be (or is there already) a option to hide the "Target Selection" toggle in an PAW cube view- can be quite distracting when not required in view mode.
    Thanks

    Chris Sutton
    Melbourne - Australia

    ------------------------------
    Chris Sutton
    ------------------------------



  • 6.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Fri June 10, 2022 03:57 PM
    Edited by System Fri January 20, 2023 04:33 PM
    Hi Chris,
    There is no option to hide the "Target Selection" toggle yet, hovever the desigers are working on more flexible UI for it.
    There were more formatting options released in PA 2.0.76 for the cube viewer that are not based on the conditions, please check it here.
    Best Regards,

    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------



  • 7.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Thu June 09, 2022 02:51 PM

    Hi everyone,

    You can watch the on demand recording here, please share any of your questions below.



    ------------------------------
    Michael McGeein
    ------------------------------



  • 8.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Thu June 09, 2022 08:59 PM
    Hello,
    In PA Cloud non-production environment are the users counted along with the users accessing the prod environment?  For example we may need a contractor to develop something for us in non-prod, do we need to purchase a modeler license for him or can we just make him a modeler in non-prod, and remove his access upon completion of the work.

    ------------------------------
    Glen Banks
    ------------------------------



  • 9.  RE: Ask Me Anything: Planning Analytics - June Edition

    Posted Mon June 13, 2022 11:26 AM
    Hey Glen,
    Yes, you would need a license for a contractor working on a non-production environment. You have to invite to the primary environment and then after the user has accepted, you can add non-production environments.
    Kirk

    ------------------------------
    Kirk Stolworthy
    ------------------------------