TM1 Forum

Posted: **Sat Apr 12, 2025 1:35 am**

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

Posted: **Sat Apr 12, 2025 1:43 am**

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 );

TM1 Forum

Drill-through to a cube view with minimalistic coding

Drill-through to a cube view with minimalistic coding

Re: Drill-through to a cube view with minimalistic coding