Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

Adding member filter expansion to a paramter?

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

 

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. 

 

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

 

Cube View

2 Replies

Sort By
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    4 years ago

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

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

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

  • ckattookaran's avatar
    ckattookaran
    VIP
    4 years ago

    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.