Creating drill-through from cube cells in PAW can be a tedious process.
Here's a summary of some current steps and limitations
-
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';
-
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');
.
-
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.
-
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
------------------------------