cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Current View

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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!

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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