on 04-01-2008 6:54 PM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.