Active form rebuild removes MDX in subset

Post Reply
User avatar
Alex
Posts: 10
Joined: Tue Oct 22, 2013 8:24 am
OLAP Product: Planning Analytics Local
Version: 2.0.9
Excel Version: 2016
Location: Germany

Active form rebuild removes MDX in subset

Post by Alex » Wed Nov 18, 2020 12:07 pm

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

tomok
MVP
Posts: 2767
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Active form rebuild removes MDX in subset

Post by tomok » Wed Nov 18, 2020 1:00 pm

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Mark RMBC
Community Contributor
Posts: 240
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Active form rebuild removes MDX in subset

Post by Mark RMBC » Thu Nov 19, 2020 11:24 am

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

Post Reply