TI: Update subset after cube load

[kudzis]

Hello,

I need to update a subset of specific dimension when I finish loading data into cube (using TI process). I want this subset to include all N level elements from this dimension. How can I do that?

[qml]

The best approach is to create a Dynamic Subset with the following MDX code

Code: Select all

{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dimension] )}, 0)}

This subset will not need any maintenance, it will always be automatically up to date.

[kudzis]

The best approach is to create a Dynamic Subset with the following MDX code

Code: Select all

{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dimension] )}, 0)}

This subset will not need any maintenance, it will always be automatically up to date.

I haven't fought of that. Thanks!