01-18-2022 11:19 AM
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
01-18-2022 04:34 PM
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.
01-19-2022 04:38 AM - edited 01-19-2022 04:40 AM
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!|