TM1 Forum

Hi folks,

I have encountered a strange behaviour in connection with dynamic subsets.

I have an active form. Outside the data range of the active form I have some DBRW-formulas in which I use dynamic subsets instead of a specific dimension member to retrieve the total for a specific set of elements. The dynamic subset is build up by filtering a set of elements based on a cube value (and beginning with a specific pattern):

{TM1FILTERBYPATTERN (
{FILTER (
DESCENDANTS ( [RC_UBZ_PC].[X0078PC0078] ),
[RC_UBZ_PC].(
[RC_UBZ_PC].CurrentMember,
[RC_UBZ_FI].[DUMMY],
[RC_UBZ_GF].[DUMMY],
[RC_UBZ_YEAR].[2019],
[RC_UBZ_PERI].[pro Dez],
[RC_UBZ_STMB].[Ist Stichtag],
[RC_UBZ_COSTELEM].[TRS_S1_KST_TYP],
[RC_UBZ_WAEH].[Output]
) = "A" )},
"X0078PC*" )}

This works fine until I rebuild the current sheet. After that the MDX "disappears" from the dynamic subset, i.e. the dynamic subset has turned into a static subset. This is reproducable, every time I rebuild the active sheet this happens!

Is this a bug or am I missing something?

Best Regards,

Alexander Koeppe

For starters, subsets exist on the server and there is no functionality in TM1 to create or modify subsets via an active form so this is not happening. It sounds like you are talking about using MDX in a TM1RPTROW formula, instead of a subset. If so, that formula only exists in the first row of the form. If it is disappearing after a rebuild then you must have it inside the active form area. If this is not the case we'll need more information like what are the cell ranges for where this "subset" is located and then all the cell references for the active form named ranges. Without this it's going to be impossible to diagnose.

Hi,

Like Tomok this makes little sense to me without more information.

One thing I would point out is that I notice in your MDX you have a cube name, RC_UBZ_PC and a dimension with exactly the same name.

I have seen where a cube and dimension have the same name it messes with MDX, however it usually doesn't render the MDX properly.

regards,

Mark