Summary:
This article discusses a method on how to use Security to apply the Solver Data warehouse Trees
Method:
Solver Data Warehouse Trees are unique in that they are a query not a table. You will need special type of security if you want to use in on Trees. In this example we will make two trees on the same Dimension. We have Drill1 and Drill2.
It will then look like this in the Report Designer. You will we see both Drill and Drill 2 Trees.
You will then go to security to the Dimension and you will find a field called Tree Structure. You then drag in the security and then use the Not statement to exclude this. The reason to use the Not statement is it would effect the Dimension lookup.
Properties:
Trees, Security