Skip to main content
A
Avatar-Roku
Newcomer
January 18, 2022

Adding member filter expansion to a paramter?

  • January 18, 2022
  • 2 replies
  • 0 views

Can we add these expansion to a parameter, and have the user select on their own? 

Mustafa_A_0-1642522458943.png

 

I was able to build a entity selection parameter, however when I run it, it pulls in everything (branches, regions, district) because I have used "Tree Descendent" expansion. But it would be preferred if I could add a expansion parameter (Children, Base, Tree Des, Member etc) and have it prompt the user to select.

 

This is how my dialog prompt looks. Looking to add that parameter in their. 

Mustafa_A_1-1642522708561.png

 

 Let me know if this can be done? any example will be appreciated. Thanks

 

2 replies

C
ckattookaran
Newcomer
January 18, 2022

If you combine the other questions you asked earlier about the multi-selection, you can provide the user with a dropdown of selecting those expansions and pass it to the rule. That will work. However, if you are going to do something like Entity A select Base, Entity B select Descendants, that will need something similar to what I posted earlier as the blog post.

C
OneStream Employee
ChristianWOneStream Employee
OneStream Employee
January 19, 2022

Create a delimited list parameter named DimListType it should look like this one:

ChristianW_0-1642584948928.png

and combine it with the member selection (MemberSelection). In the cubeview row or column definition it should look like this:

E#[|!MemberSelection!|]|!DimListType!|

    Terms & ConditionsAccessibility statement