I am experimenting with setting up a drill-through to a cube view, in Architect. 2.0.5 as the PA version.
The scenario is that any cell can be drilled upon and the resulting view contains all descendants of the chosen cell. Like that, we see all numbers that make up the initial number.
If the drill view is pretty fix and does not change, this exercise is rather easy. It's more difficult, however, in these 2 cases:
1. the user and/or the time of the drill should be added as a suffix to the names of drill views and subsets
2. we want to script the view because we maybe want to bring the subsets with only 1 element to the titles. Having these subsets in rows or columns does not add a lot IMHO.
I can do point 2 but I am stuck with point 1. I saw this page: https://lodestarsolutions.com/tm1-drill ... t-working/
The page contains code to script the view and subsets with names that dependent on the user.
I cannot get this code to work. For me the function RETURNVIEWHANDLE does not seem to pick up the new view name.
Example: the drill is created based on view 'Level 0' on cube 'My_test_cube', data source type is 'cube view'. In the Prolog tab we script view 'Level 0_Wim_20181008 033650' and its associated subsets. The latter view should be picked up as the drill view, not the first view. To this end, I used code like:
Code: Select all
If( 'TM1' @= 'slow' ); #****Begin: Generated Statements*** RETURNVIEWHANDLE('My_test_cube','Level 0'); #****End: Generated Statements**** EndIf; View = 'Level 0_Wim_20181008 033650'; RETURNVIEWHANDLE('My_test_cube',View);