5 Replies Latest reply: Jan 17, 2014 5:01 AM by SreekumarHariharan RSS

Need Help in Essbase filter

user6377416 Newbie
Currently Being Moderated

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

@REMOVE(@IDESCENDANTS("Scenario"),@LIST("FYF10","FYF11")),@REMOVE(@IDESCENDANTS("Version"),@LIST("Draft1")

the abouve is a sample where draft2 is unrestricted for both scenario .Please help

 

Thanks,

Anbuvel Nagarathinam

  • 1. Re: Need Help in Essbase filter
    Phulsebosch Pro
    Currently Being Moderated

    Hello Anbuvel,

    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.

     

    Regards,

    Philip Hulsebosch.

    www.trexco.nl

     

     

    p.s. close questions which were answered. Then we do not have to open them to see if we can help.

  • 2. Re: Need Help in Essbase filter
    user8628169 Explorer
    Currently Being Moderated

    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.

  • 3. Re: Need Help in Essbase filter
    Ross Newbie
    Currently Being Moderated

    Hi Anbuvel,

     

    I think @IDescendants (Version) is ok but for Scenario, you should mention the those scenario dimensions members in which you want grant accces.

     

    Let me update if this work.

     

    Regards

    Ross

  • 4. Re: Need Help in Essbase filter
    SreekumarHariharan Explorer
    Currently Being Moderated

    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

    or

    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

     

     

    Thanks,

    Sreekumar Hariharan

     

     

     

    .

  • 5. Re: Need Help in Essbase filter
    Phulsebosch Pro
    Currently Being Moderated

    Hello Ross,

    How do you want to accomplish this with @IDescendants (Version) for the combinations needed? They are different, some read, some write. There is no way to do this in less than 2 lines, better 4 lines of filter code.

     

    Regards,

    Philip

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points