Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  PAW security - Lock consolidated members if empty

    Posted Tue November 07, 2023 05:47 AM
    Edited by Asgeir Thorgeirsson Tue November 07, 2023 05:49 AM

    Hi all!

    I want to prevent the user from adding data to an empty consolidated member. 

    The consolidated member should only be open for input if there is some data at lover levels to direct the spreading. 

    In other words, I want to prevent the system from evenly spreading tiny fractional data to every leave node.  

    Is this possible?

    Thanks, Asgeir



    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------



  • 2.  RE: PAW security - Lock consolidated members if empty

    Posted Tue November 07, 2023 12:42 PM

    Hello,

    You could use cellsecurity based on rules > If the value is different from 0 and level > 0 then read. Does that answer your question?

    Best regards,



    ------------------------------
    DESCHARD Cécile
    ------------------------------

    Original Message


  • 3.  RE: PAW security - Lock consolidated members if empty

    Posted Tue November 07, 2023 03:18 PM

    Thank you @DESCHARD Cécile, I am testing this approach. 

    My cube has nine dimensions, some with hundreds of members and a consolidated tree structure. Most dimensions are spares. 

    If I use this approach, I guess I will first set the write access to all levels and then read or write access to the consolidated members.  

    Is this an applicable approach in relation to performance?

    Thanks, 



    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------

    Original Message


  • 4.  RE: PAW security - Lock consolidated members if empty

    Posted Wed November 08, 2023 04:22 AM

    Sure it depends on your model.

    • If data entry on this dimension is only used for that purpose, you could also secure the dimension based on parameters
    • if the data at leaf level is imported or not changing too much, you could do it via process also

    It is hard to answer not knowing the functionnal need but here are some ideas...



    ------------------------------
    DESCHARD Cécile
    ------------------------------

    Original Message


  • 5.  RE: PAW security - Lock consolidated members if empty

    Posted Wed November 08, 2023 03:22 AM

    Hi Asgeir

    You can use the server configuration parameter ProportionalSpreadToZeroCells which is set in the tm1 config file.

    Only minor drawback might be that this applies the whole model.

    Kind regards,

    Jesper



    ------------------------------
    Jesper Poulsen
    ------------------------------

    Original Message


  • 6.  RE: PAW security - Lock consolidated members if empty

    Posted Wed November 08, 2023 09:24 AM

    Hi Asgeir,

    You can acheive that by setting ProportionSpreadToZeroCells=F in the tm1s.cfg parameters.

    That will prevent data spreading in zero consolidated cells.

    ProportionSpreadToZeroCells - IBM Documentation

    Best regards.



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

    Original Message


  • 7.  RE: PAW security - Lock consolidated members if empty

    Posted Wed November 08, 2023 09:31 AM

    Assuming you do not want to use the TM1s.cfg parameter which applies to the entire model, you could also look at the security overlays

    You can create a cut down cube with only the relevant dimensions needed to see if you should block or unblock a cell.

    This also removes the necessity to change cell security or impact other areas. 



    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------

    Original Message


Related Content