ActiveForm and MDX

[gujsa01]

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

[EvgenyT]

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

[gujsa01]

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,

[gujsa01]

f1.PNG (22.91 KiB) Viewed 4188 times

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

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

s2.PNG (59.35 KiB) Viewed 4188 times

[declanr]

What is in your TM1RPTRow formula cell?

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

[gujsa01]

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

Thanks a lot!!