Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

Challenges in Creating Drill from Cube Cells in PAW

  • 1.  Challenges in Creating Drill from Cube Cells in PAW

    Posted Fri November 29, 2024 08:24 AM

    Creating drill-through from cube cells in PAW can be a tedious process. 
    Here's a summary of some current steps and limitations

    1. Drill Rule:

      • Requires a specific syntax to call drill processes using a comma-separated string.
      • Process names become the drill-down display names when right-clicking a cell.
      • Example: []=S:'Drill_Process_1,Drill_Process_2,Drill_Process_3';
    2. Drill Process:

      • For TM1 cube drilling, the process data source is typically the drill cube view.
      • This requires defining a handle to the cube view, e.g., ReturnViewHandle('Source_Cube','Source_Cube_View');.
    3. Drill View:

      • Views created in PAW cannot be used directly for drill-through.
      • It is possible to create a usable server view in Architect, Performance Modeler (PM), or save one using a TI process.
    4. Resulting Drill Display:

      • Detailed data is displayed in nearly full-screen format, making it difficult to see both the drilled data and the original view at the same time.
      • Customizing the look of detailed data (color, formatting) is not supported.

    It would be great to have some guidance on how to effectively create drill-throughs and to know if there is something I am doing wrong or missing out on. Also, are any future enhancements planned for this functionality in the PAW roadmap?  Any input or advice would be much appreciated.



    ------------------------------
    Asgeir Thorgeirsson
    Software Engineer, MS
    Icelandair
    Reykjavik
    ------------------------------