Skip to Content
author's profile photo Former Member
Former Member

Context Filter


In the Database Administrator, under Context Management - Scorecard management - Default Scorecard you can select filters to apply to the Context. There if the model has dimensions you can choose values to filters, but can you choose two or more values for the same dimension?.

Example: I need to filter the context by Cost Center dimension with values 1, 2 and 3 but I am able to select one value only in edit filters.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2014 at 12:36 AM

    I believe it is a limit to a single member but there is another solution.

    Firstly understand that context filters are a convenient way to limit the user's starting view. If you want them to see two see two cities and if your dimension has no roll-up of those cities into a single region, then their starting view must be one city or the other. However they can still change that view through the dimensional requester to see the other city. What's more they can see any other city in the organisation.

    If you go into PAS and create a security procedure you can limit a user to seeing only certain members of a dimension. Here you can force the restriction to only the two cities.

    However you must still have the context default to one of those two cities. The users must be educated to use the dimensional requester to select the second city. If that is not acceptable you can create two score cards, one per city, and give them access to both.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If I have understood, and using my city example, you will need to

      • create a region as the sum of the two cities
      • consolidate the cities into the region
      • make the scorecard default to the region.

      The users can still drill down to either city. You have the option to use PAS security if you want to prevent them viewing date for cities that are not part of their region

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.