Controlling subset selection in PAW

[wbf]

PAW version: 2.0.53

Trying to find a way to make subset selection more user friendly. First thing first there are a lot of manually created subsets in this dimension, and as well as TI generated subsets. Users are ought to only select the TI generated ones, on top of that for each PAW book tab, they ought to only pick from a few.

for instance, I have 10 subsets created from TI, there are two tabs in PAW containing the same cube view except user is able to pick subset from one dimension. First tab, they should only see / select from 5 subsets and the other tab show show only the remaining 5 subsets.

P.s. I would love to hide the overview of the cube view if possible because:
1. I don't really want the user to mess up the element selection
2. I don't want to reveal other manually created subsets since they are not meant for selection
3. Its not looking good

Thought of creating another cube to allow user pick subset from picklist which then automates the selection of subset in the original cube view.

##########################################################################
1. Enhance the TI that generates the subset so that it would also create elements into a new dimension using the subset name
2. In this new dimension, manually create dynamic subsets that group the elements by pattern. From the example above of two PAW tabs, there will be 2 dynamic subsets created with 5 elements each.
3. Create a mapping cube with two dimensions. One dimension with element representing the PAW tab, while the other is a measure dimension with picklist attribute referencing the dynamic subset created from step 2
========================================
\\\\\\\\\\\\| Value |
----------------------------------------------------------
Picklist 1 | <subset picklist 1> |
----------------------------------------------------------
Picklist 2 | <subset picklist 2> |
=========================================
4. Put this cube view side by side to the original cube view in both PAW tabs, 1st tab will show only Picklist 1 element, while 2nd tab shows only Picklist 2 element
5. In the original cube view, the dimension which subset should be auto selected should have mdx statement like follows: TM1SubsetToSet([dim],[cube].[measure].currentmember)
6. When user select a subset from the controlled subset list in the mapping cube, it will filter the original cube view.
##########################################################################


Sorry having to write down the steps and editing a few times makes me doubt whether it will work Hopefully it helps with the visualization.

Begging for comments and ideas. Or is there a way already (like control cubes or function in PAW) that can do this.

Thank you in advance

[burnstripe]

I may have misinterpreted this and I think it's similar to what you have already jotted but from what I understand of your requirements I would have:

A control cube with 3 dimensions:
}client (so each user has there own selection
Paw page (to ensure selections are unique to each tab if required)
Measure (string element to store subset selection)

On this control cube then create a picklist cube, so that the user can only selection the required subsets for each view/tab. (create a rule in the picklist cube to control which subsets to allow)

Link this control cube to the book, I.e bring in the individual cell, and that will define the selections a user my make. The active client can be identified/selected using mdx.

Then on the cube views link to the subsets named in the control cube. The mdx can grab the tm1 user, go grab the subset from the control cube based on the user/paw page and then return the contents of the subset.

This should do the trick, if you need help generating the mdx statements let us know and I'm sure I or someone else will be able to help

By doing it this way
1) The user Won't have to go into the subset editor and potentially mess up selections
2) Give you full control over what the users can select