Dimension Members are not appearing based on Validation Rules

[Vasu_Sac]

Hello,

I have updated Master Data Validation Rules in Planning Model. But in story, the dimension values are not appearing based validation rules. 

Ex, When I select Company Code, I am expecting to show respective Sales Groups based on validation rules. But it showing Sales Group Dimension members  "ALL".  I selected Cascading Effect, still not working.

Company Code dimension is Story Filter and Sales Group Dimension is Input Control in the Story.

Please let me know how to achieve required functionality.

Regards,

Vasu

[SarauShen]

@Vasu_Sac , from your description, I understand you would like having cascading effect on member selector based on validation rule, e.g. selecting a company code in one filter, and only the valid sales group should be shown in the second filter based on validation rule.  

Cascading effect based on validation rule is NOT supported in product. 

Sarau

[Vasu_Sac]

Hi @SarauShen, Thanks for your reply. Any alternative ways to achieve this functionality. Regards, Vasu

[SarauShen]

Hi @Vasu_Sac, if the volume of valid member combinations are acceptable, you might create zero values for valid member combinations, then enable the cascading effect with story filter/page filter. However, if the volume of valid combinations is huge, this alternative is not recommended as it might harm query performance

[Vasu_Sac]

Hi @SarauShen, Unfortunately Model contains many dimension members with lot of valid combinations.