Drill-through to a cube view with minimalistic coding

[Wim Gielis]

Hello,

I was able to script a drill-through to a cube view:
https://tm1forum.com/viewtopic.php?p=84403#p84403

Have a look there to download the generic process and look at the examples of how to call it.
Bedrock is underpinning the new process so you need (at least some of) the Bedrock TI processes.

Works fine in PAW and PAfE ánd TM1 Web.

Best regards,

Wim

[Wim Gielis]

As an example call, use:

Code: Select all

NumericGlobalVariable( 'nErrors' );
StringGlobalVariable( 'vObject_Name' );

cCube = 'Prm_Init';
vObject_Name = 'Drill_Details (%u% at %t%)';

# Create the drill object (the order of subsets is retained)
nErrors = nErrors + ExecuteProcess( 'WG_DRILL_cube_view_drill_setup', 'pCube', cCube, 'pObject_Name', vObject_Name, 'pZero_Suppression', 'YY', 'pFilter', '
    Scenario¦' | pScenario | ' & Version¦' | pVersion | ' & Year¦' | pYear | ' & Period¦mdx:c(YTD M12) & 
    ~
    GL_Account¦mdx:d0(' | pGL_Account | ')' | ' & Organisation¦mdx:0' | ' & 
    ~
    Prm_Init_Msr¦Initialized' );

# Launch the drill object
If( nErrors > 0 ); ProcessError; EndIf;
ReturnViewHandle( cCube, vObject_Name );