Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------

Hi Ty,

The multiple selection widget generates a set (the set is the members you select in the list) to synchronize to other widgets.  The Advanced synchronization feature can be used on the widget receiving the synchronized set to determine what set to display in the widget based on the synchronized set.  The current options are Set , Set and aggregate, Aggregate and set, and Aggregate. 

We could extend the Advanced synchronization feature to include 'Children of set' and 'Descendants of set'.  I've also seen one enhancement requests to provide sort options for the set of members that is displayed in the widget.

The really nice thing about the Advanced synchronization feature is that each widget can do something unique with the set of members that is synchronized to the widget.

Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------

Hi Ty,

The multiple selection widget generates a set (the set is the members you select in the list) to synchronize to other widgets.  The Advanced synchronization feature can be used on the widget receiving the synchronized set to determine what set to display in the widget based on the synchronized set.  The current options are Set , Set and aggregate, Aggregate and set, and Aggregate. 

We could extend the Advanced synchronization feature to include 'Children of set' and 'Descendants of set'.  I've also seen one enhancement requests to provide sort options for the set of members that is displayed in the widget.

The really nice thing about the Advanced synchronization feature is that each widget can do something unique with the set of members that is synchronized to the widget.

------------------------------
Stuart King
Product Manager
IBM Planning Analytics

Original Message:
Sent: Mon January 27, 2025 10:13 AM
From: Ty Cardin
Subject: Multiselector lists

Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------

Hi Ty,

The multiple selection widget generates a set (the set is the members you select in the list) to synchronize to other widgets.  The Advanced synchronization feature can be used on the widget receiving the synchronized set to determine what set to display in the widget based on the synchronized set.  The current options are Set , Set and aggregate, Aggregate and set, and Aggregate. 

We could extend the Advanced synchronization feature to include 'Children of set' and 'Descendants of set'.  I've also seen one enhancement requests to provide sort options for the set of members that is displayed in the widget.

The really nice thing about the Advanced synchronization feature is that each widget can do something unique with the set of members that is synchronized to the widget.

Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------

Stuart,

Played around some more with the selector lists.  Yes, it would be great to have a children of set option for Action on set change.

Hi Ty,

The multiple selection widget generates a set (the set is the members you select in the list) to synchronize to other widgets.  The Advanced synchronization feature can be used on the widget receiving the synchronized set to determine what set to display in the widget based on the synchronized set.  The current options are Set , Set and aggregate, Aggregate and set, and Aggregate. 

We could extend the Advanced synchronization feature to include 'Children of set' and 'Descendants of set'.  I've also seen one enhancement requests to provide sort options for the set of members that is displayed in the widget.

The really nice thing about the Advanced synchronization feature is that each widget can do something unique with the set of members that is synchronized to the widget.

Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------

Additional 'Advanced synchronization' options would be helpful in many cases.  Your use case is a bit more complex as the synchronization feature in PAW books only synchronizes the same hierarchy between different widgets.  In your case you want to synchronize different hierarchies (where you have defined some relationship between the members in each).  This might require a more open ended approach like Ryan is suggesting.  We could consider a custom 'Advanced Synchronization' option where you can parameterize the MDX statements for each widget.

Make sure you look carefully at the release notes for the upcoming PAW 2.0101 or 2.1.8 release.  

In the mean time, I suspect that creating a lookup cube in TM1 to store the relationship between members in the each hierarchy is the only good solution.   

Stuart,

Played around some more with the selector lists.  Yes, it would be great to have a children of set option for Action on set change.

Hi Ty,

The multiple selection widget generates a set (the set is the members you select in the list) to synchronize to other widgets.  The Advanced synchronization feature can be used on the widget receiving the synchronized set to determine what set to display in the widget based on the synchronized set.  The current options are Set , Set and aggregate, Aggregate and set, and Aggregate. 

We could extend the Advanced synchronization feature to include 'Children of set' and 'Descendants of set'.  I've also seen one enhancement requests to provide sort options for the set of members that is displayed in the widget.

The really nice thing about the Advanced synchronization feature is that each widget can do something unique with the set of members that is synchronized to the widget.

Question:

I have a dimension with an alternate hierarchy that groups the leaf elements of the base hierarchy.  I want to be able to multi-select parents and return only the children/leaves of the selected parents.  The alternate hierarchy is an attribute hierarchy.

Not having a problem at all with selecting one parent and returning the children.  However, have not been able to figure out how, or if, the multi-selector can be used to achieve selecting multiple parents and returning all their children.  Or some way to accomplish this.  

Have done some testing and it does not appear to be feasible to pass to a TI the selections from a Multi-Selector List, but any suggestions would be most welcome.

UPDATE: Have setup a cube to allow the user to select items and then use those selections in an MDX subset to return the desired subset.  Just not the elegant solution I was looking for.

------------------------------
Ty Cardin
------------------------------