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

Filter Current View

HI,

If in a report, I want to filter the Entities the user can select according to a certain dimension property, I can put in a cell of the report a filter inside the a cell via EVCVW( , filter). Nevertheles the user can bypass the filter by selecting whatever he wants via the Action Pane/Current view.

Is there any way to include the EVCVW() filter inside the Action Pane/Current view?

Thanks & regards

Gael

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2008 at 06:29 PM

    Hi Gael,

    Is it only in a certain report(s) that you want to filter what Entities the user can select? If so, then I'm not aware of any way to override the filter options in the Action Pane/Current view.

    However, if you want to always filter what Entities the user can select from (regardless of the report or schedule), then you might want to consider using Security. When the Entity dimension is secured, then the only entities that will appear in the Action Pane will be the specific set of entities the user has been granted access to.

    Ray.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ray,

      Yes it is only on certain reports that I want to filter the possible members. In other reports those members may be selected by the user. It is more a question of the report context than a question of security.

      Thanks

      Gael

  • author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2008 at 09:13 PM

    No, you cannot alter the behavior of the current view dialogs. The EVCVW fuction opens the dialog with the predefined filter but the user can still select from the action pane whatever they want. The only thing that comes close it to build a override range in the report that blocks the user from changing the CV but that is limited to selecting a single value for all users.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello James,

      In fact I think you and Ray confirmed that SAP BPC is not able to manage what we could call "prohibited" dimension crossings.

      That is why we have designed our reports in that direction in order to make sure data are keyed in at the right dimension crossings. It also impose that depending of the context of the report, some dimension members cannot be selected by the user. That is why we have implemented filters in the EVCVW()s. The only issue is that we have to train the user to select the members via the Excel worksheet and not the Action Pane / Current View

      Thanks and regards

      Gael

      +33 6 18 98 11 69

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 04:56 PM

    Hereu2019s a great feature;

    Using dimension locks

    When you set dimension locks on a report, the dimension members that are locked are displayed in the

    action pane as non-editable.

    To use dimension locks

    1. From an open report, select Worksheet Dimension Lock Options from the Report State

    Action Pane.

    2. Select the application from the list in the action pane. The dimension fields for the selected

    application is displayed below the application field.

    3. If you want to change a dimension member, use the member drop-down list to select another

    member, or click moreu2026 to open the Member Lookup.

    4. If you want to lock a dimension member, select the check box to the left of the dimension name.

    If you want to unlock a dimension member, select the check box next to the dimension name to

    remove the check.

    5. When you are done, click the green check in the lower right corner of the Worksheet

    Dimension Lock Options action pane.

    You can use either evcvw or evmbr to select dimension members, (you can filter on both).

    You can have you set your pagekey range to reference cells containing the member selector.

    Please let me know how this works for you!

    Add a comment
    10|10000 characters needed characters exceeded

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.