PAW functionality for preselecting (depending input selection)

[schlemiel29]

When selecting an element for a dimension, I like to restrict another dimension depending on this selection. So in TM1Web I use 100% Excel functionality. I create a subset or a c element which represents my first selection. Let's assume I selected a department (100). With this ID I had created at import time a subset named "D100" in the product dimension or a c element with the same name. There are only products sold in this department listeted (it's static!).
So in a list of valid entry values for dimension product I use "Children of D100" or Subset "D100".
But is there a functionality in PAW, which enables me to do this, or is "syncronize" the only dependency handling functionality? Or do I need to stay on old school features?

[MarenC]

You could create a client attribute called Dept for the user selection, and then retrieve the subset with mdx as follows:

Code: Select all

STRTOSET('TM1SUBSETTOSET([Product], "D' + STRTOMEMBER("[}Clients].[}Clients].[" + USERNAME + "]").properties("Dept") + '" )')

[schlemiel29]

Interestingly!
But I didn't get it complete.
So there is an attribute for }Clients, so each user has his own subset for elements of "products", right?
But where is his selection in the report used? He selected "Departement 100" in this report, so how does this information influence the outcome of the attribute?

[MarenC]

The attribute is the selector, basically you make the selector a cube view of the client attribute cube, e.g. The client dim in the column using MDX for the logged on user and the department attribute in the row (which could be a picklist of the department dim).

When a user selects a department it returns the relevant Product subset. As per your original example, the user selects department 100 and in the report the product subset D100 is returned.

Maren