Member Lookup specific members to use in reports, input schedules, journals, member security definitions, and data management packages.
1) Select members: At any time to display in your report or input schedule. You can select only the dimensions and members to which you have access.
2) Filter members: the member list based on member properties.
3) View member properties: Members those are available for use when creating and modifying reports or input schedules are enabled. Properties that are for information purposes only are disabled.
4) Set Member Lookup options: set options that control behavior on the Member Lookup dialog box. The Select All Children Behavior section determines how members are selected when you use the Copy option to copy one or more members and paste them into your spreadsheet.
5) Copy and Paste Member Lists: You can copy members from Member Lookup and paste them into a spreadsheet. You can use this feature to create journal entries, reports, or input schedules.
Current View
The Planning and Consolidation current view feature transforms static spreadsheets into dynamic, reusable reports and input schedules.
The current view represents the following:
· The dimensions those are included in the current application.
· The members that are used in the current display of a live report (or the saved members in an offline report).
Dynamically select members to change the current view in a live report by selecting new members from the current view.
To change the current view->make sure the action pane is maximized->maximize the current view list in the Session Information section->Select the Member->to refresh the report or input schedule->click on yes.
Use the current view you we can drill down and drill up options,by mean expanding the rows,columns to the dimensions properties.
There are two types of drill through functionality in the SAP BPC Microsoft version of Planning and Consolidation. One type allows you to view data that is linked from a database table (including external databases and the Journal database). The second type of drill through allows you to view data linked from a URL.
Database-based drill through
The ability to drill through to a database table is available on any EvGTS, EvGET, EvDRE, or EvINP cell that references a dimension for which a drill-through definition has been defined.
URL-based drill through
The ability to drill through to an external URL allows you to drill through to a target with the mapping of an EvDRE page key or a specific current view.
No comments:
Post a Comment