I have a Cube with few scenario and version.the user's lock and send access are restricted by a user filter.
Now i wanted to grant a write access for two scenario and different version.
FYF10 -> Draft1 restrict
FYF10 -> Draft2 write
FYF11 -> Draft1 Write
FYF11 -> Draft2 Restrict
the abouve is a sample where draft2 is unrestricted for both scenario .Please help
there is no way around creating multiple lines in the filter. The combination in one line always gives an different outcome you are looking for.
Tip: use one version for working in. Keep other versions for reference only.
Tip: use substitution variables in the filter. Then you do not go and change it everytime somethin changes.
p.s. close questions which were answered. Then we do not have to open them to see if we can help.
The easy option would be to use multiple lines in the security filter with desired access details.
As suggested by Philip, easy maintenance is to use substitution variables and just update them rather than editing the filters.
Or you can also use attributes to define your filters and simply change the attribute association within the dimension.
Best way to do ,is create the security filters in the shared services with the write access or else using the maxl command to grant access for a particular level of intersection for that particular application.In your case you need to give muliple line write access based up on your requirement
If its a planning application ,then you can assign access for a particular planning user (accessing data forms) through import/export security utility and create a sec.txt file in planning bin directory