TM1 Forum

Hi,

I'm trying to dynamically update row subset based of a value selected in title element.

Planning Sample:bcbs_OpEx:15

{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bcbs_Cost Center] )}, 0)},[bcbs_OpEx].([bcbs_Account].[615800],[bcbs_Methodology].[Budget],[bcbs_Month].[12YTD]) > 0 )}

bcbs_Account 615800
bcbs_Year 2016
bcbs_m_OpEx Value
bcbs_Methodology Budget


01 02 03 04 05 06 07 08 09 10 11 12
400282 100 0 0 0 0 0 0 0 0 0 0 0


Expression above will filter Cost Center by filtering OpEx cube for Account (615800) , Methodology (Budget) and Month (12 YTD) >0. When I run this on Cost Center subset, i get correct Cost Center value of 400282. When I change account to 615700, I get 2 Cost Centers as expected. But this change is not reflected in rows of this Active Form.

Changed TM1RPTROW function to reference this MDX expression.

Appreciate any help please.

Thanks

Changed TM1RPTROW function to reference this MDX expression.

What does it look like in Excel? Remember is has to be referenced as a string.

Evgeny

Hi EvgenyT,

Expression is set to ="{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bcbs_Cost Center] )}, 0)},[bcbs_OpEx].([bcbs_Account].[" & C11 & "],[bcbs_Methodology].[Budget],[bcbs_Month].[12YTD]) > 0 )}"

This gets resolved as:
{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bcbs_Cost Center] )}, 0)},[bcbs_OpEx].([bcbs_Account].[615800],[bcbs_Methodology].[Budget],[bcbs_Month].[12YTD]) > 0 )}
where C11 is 615800 in this example.

For some reason rows are not refreshed.

Thanks,

615700 account has 2 Cost Centers as shown above, per expression.

Switching to 615800 should show cost center 400282 but is not getting refreshed.

What is in your TM1RPTRow formula cell?

And to start with the obvious did you press Rebuild Active Form?

Obviously user error on my art. Apologies. Pressed Build Active Form and works like a charm.

Thanks a lot!!