I have a process who selects only Child elemnts. I wanted to add a single consolidated element to the MDX list ised in this process. so that my process can take in consideration my new consolidated elemnt I had to activate the consolidation by putting : ViewExtractSkipCalcsSet ( zCube, zView, 0 ).
But Then I notice that my process Takes a long time in execution compared to the old logic. Is there any way to add my consolidated element and be able to modify ir without Taking So long ?
Here is my Old Code (it runs in less that 1 minute ):
Code: Select all
SubsetDestroy( zDim, zView );
Mdx='{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Account] )}, 0)}';
SubsetCreateByMDX( zView,Mdx);
ViewSubsetAssign( zCube, zView, zDim, zView );
ViewExtractSkipRuleValuesSet( zCube, zView , 0 );
ViewExtractSkipCalcsSet ( zCube, zView, 1 );
ViewExtractSkipZeroesSet( zCube, zView , 1 );
Code: Select all
SubsetDestroy( zDim, zView );
Mdx='{{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Account] )}, 0)},[Account].[Total]}';
SubsetCreateByMDX( zView,Mdx);
ViewSubsetAssign( zCube, zView, zDim, zView );
ViewExtractSkipRuleValuesSet( zCube, zView , 0 );
#I think If I put consolidation to 1 I will not have access to the consolidated element 'Total' so that's why I put it to 0
ViewExtractSkipCalcsSet ( zCube, zView, 1 );
ViewExtractSkipZeroesSet( zCube, zView , 1 );
Thank you In Advance