SAP Business Objects Planning and Consolidation, version for SAP NetWeaver is a robust Planning and Consolidation Application offering a series of solutions in the area of Enterprise Performance Management fulfilling the Planning, Budgeting, Forecasting and Reporting requirements also enabling Legal and Management Consolidation. Business Objects Planning and Consolidation is an Online Analytical Processing System providing technology-enabled Business Solutions that help an Organization monitor and track performance.

Planning, Budgeting, Forecasting and Consolidation processes revolve around Data. Data forms the core of any Planning and Consolidation process. Data primarily resides in Dimensions and Applications. Modeling of Data takes place in the BPC Administration Module by defining Dimensions with properties and Applications of a specific type. Administration Module also handles the tasks associated with the configuration of Security, Work Status, Business Rules and logic files associated with Application. BPC is built around Microsoft tools such as Word, PowerPoint and Excel. Reporting and Data Management of Applications are performed via the BPC for Excel client.

This Document demonstrates an end-to-end scenario of the necessary tasks to be performed in the Administration module to configure a simple currency translation using "Currency Conversion' Business Rules which involves Creation of Dimensions, Applications, Configuration of Member Access Profile, Setting up Dimension properties and members, Configuration of Business Rule and Validations of the Script logic file associated with Currency Conversion Rules. This end-to-end Document also deals with the Data Management and Reporting tasks executed via the intuitive Interface, BPC for Excel.

• BPC Administration Module
  • Logon to BPC Admin Interface
  • BPC Administration Tasks
  • BPC Administration Web mode
• Dimensions
  • Dimension Property
  • Dimension Members
  • Dimension Management
• BPC Application
  • Application Types
• Currency Translation using the "Currency Conversion" Business Rule
  • Setting up of Dimensions and its properties in Admin Console
  • Configuration of Finance and Rate Application in Admin Console
  • Configuration of "Currency Conversion" Business Rule
• Configuration of Member Access Profile
• BPC for Excel.
• RATE Application - Reporting & Data Management
  • Load Exchange Rates into RATE Application
  • Create Report to verify Exchange Rates loaded into RATE Application
  • Build Input Schedule to maintain Exchange Rates
• Finance Application - Reporting & Data Management
  • Maintain Conversion Files for Dimensions
  • Maintain Transformation for Data File
  • Non Interactive Currency Conversion of Data
  • Interactive Currency Conversion of Data
  • Enabling Macros for Action Buttons inserted in Reports
• Reporting
  • Build Report using delivered Dynamic Templates
  • Drill Down options
  • Advanced Formatting

• Tree list of BPC objects/components on the left. BPC objects are Applications, Dimension Library and Security.
• Metadata Information of the object/component selected from the tree list is displayed in the middle section.
• Action Pane is on the right. The content of the Action Pane is determined by the selections made from the tree list of objects/components.

BPC Administration Tasks associated with the Setup and Management of Applications falls in to the following two categories:

• Admin Console Tasks
• Web Admin Tasks

Highlight the name of the Application Set.

The Action Pane lists the set of Tasks associated with the Application Set Management.

Select Application from the tree list of objects/components.

Action Pane displays the list of Tasks associated with the Application Management.

Highlight the Dimension Library. Dimension Library is a repository of all the available Dimensions within the Applications Set.

Action Pane lists the set of Tasks associated with Dimensions Management.

Work States are Codes defined which refer to the actual state of data such as "Submitted", "Locked" in an Application along with method of update (such as DM, JRN, MAN, COMM, DOCS) used to update the Application.. Work State Codes are defined at the Application Set Level.

Work Status provides ability to lock "slice" of data in an Application defined by an intersection of Dimension members.

Managing Work Status involves specifying who can make changes to the Data and who can change the Work State on a Data set. Users can use Work State Code to apply Label to a "slice" of Data defined by an intersection of Dimension Members and lock its Data for Review, Approval and so on.

Business Rules are parameter driven table based logic which provide the flexibility to customize certain delivered functions to meet business needs. Business Rules are predefined calculations or Functions delivered with Business Objects Planning and Consolidation.

Security has to be configured per Application Set. Users belong to groups called Teams. Profiles are created and assigned to Teams.

Profiles can be assigned directly to a User or to Teams which contain a group of Users. There are Task Profiles and Member Access Profiles.

Task Profile determines what kind of activities a User or a Team can perform in BPC.

Member Access Profile determines Applications and Dimension Members where a User or a Team has Read, Write or Deny access to a specific region of data within the Application.

Web Admin Tasks can be performed only in BPC Administration Web mode.

• Set AppSet Parameters
• Set Application Parameters
• Manage Document Types
• Manage Document Subtypes
• Manage Activity Audit
• Manage Data Audit

An Application Set consists of a set of Dimensions under the Dimension Library. Dimensions may be shared across Applications within the Application Set.

A Dimension holds master data. Dimension types are used to organize data within Application based on the type of information involved.

Web Admin Tasks can be performed only in BPC Administration Web mode.

• Set AppSet Parameters
• Set Application Parameters
• Manage Document Types
• Manage Document Subtypes
• Manage Activity Audit
• Manage Data Audit

There are three types of Dimension Properties

• Required Properties - Each Dimension of a specific Dimension Type has certain Required Properties. Dimension Type determines the default properties that are required for a Dimension. Properties such as EVDESCRIPTION, ACCTYPE, RATETYPE and SCALING are required for every Account Type Dimension.
• User Defined Properties - Properties that are maintained from the Admin Console for specific business needs.
  
  
• Hidden Properties - Properties that are not displayed within the BPC Admin Client but are generated by the system such as 'CALC' property. 'CALC' property can be seen in the BPC for Excel Interface.

• Member Lookup.
• Data Manager Selections.
• Script Logic and Business Rules.
• Reporting.

Flat Dimensions have a common grouping of members.

The Members of the following Category Type Dimension has a flat structure.

The Members of Time Dimension have a parent, child and sibling relationship. Members are arranged in a hierarchical order.

Hierarchical Dimensions have natural "roll ups" thereby showing a structure as well as implied additions at the parent level.

To create a new Dimension, highlight the Dimension Library from the tree list. Highlighting the Dimension Library will list the set of Tasks associated with Dimension Management in the Action Pane. The content of the Action Pane changes based on the selections made in the Navigation Pane of the Admin Console. When a particular Dimension is chosen in the Navigation pane, the tasks associated with that particular Dimension such as Maintain Dimension Property, Maintain Dimension Member are displayed in the Admin Console. The Admin Console is context sensitive and its contents are based on the selection of object from the Navigation Pane.

Entity Type Dimension F_ENTITY has InputCurrency Dimension as a Reference Dimension. Here the members of the Property 'Currency' of the Entity type Dimension are validated against the Dimension Member IDs of the InputCurrency Dimension. Member of 'Currency' property of Entity Dimension should be a valid member of the Currency Type Dimension, InputCurrency.

• Copy Dimension:
  Copy an existing Dimension within the Dimension Library of the Application Set.
• Modify Dimension:
  Modify Dimension Task gives the option to modify the description of an existing Dimension and the Reference Dimension. Dimension Type cannot be modified.
• Process Dimension:
  Processing a Dimension validates the Hierarchies associated with the Dimension members and validates the Dimension formulas if any.
  Processing a Dimension updates the member values to the BW server.
• Delete Dimension:
  A Dimension can be deleted from the Application Set using Delete Dimension. However deleting a Dimension which is used by an Application is not possible.

BPC Application is a unit which serves a specific purpose. Application stores the Transaction Data and the Data is described by the Dimension members.

Each Application serves a specific purpose and supports one or more segments of overall Planning or Consolidation process.BPC Application is defined by set of Dimensions from the Dimension Library and the Dimension Members of these Dimensions describe the Transaction Data stored in the Application.

BPC Application must have four mandatory Dimensions such as Category, Account, Entity and Time Type Dimension.

Required Dimensions in any BPC Applications

• CATEGORY Type Dimension
• ACCOUNT Type Dimension
• ENTITY Type Dimension
• TIME Type Dimension

There are two types of Applications in BPC.

• Reporting Application
  • Generic
  • Financial
  • Consolidation
• Non-Reporting Application
  • Generic
  • Rate
  • Ownership

Business Rules are not available for Non-Reporting type Applications.

Two Applications are delivered with the default Appshell.

• PLANNING
• RATE

PLANNING is a Reporting type Financial Application which has RATE Application as a Reference Application. RATE is a Non-Reporting type Rate Application.

RATE Application is a supporting Application of type Non-Reporting Rate which is used to store the exchange rates and is used as a Reference Application to Applications that require Multi-Currency Conversion.

RATE Application is used to capture and manage the Exchange Rates associated with different currencies.

Multiple Reporting Financial or Consolidation Applications can reference to the same Rate Application or each Reporting Financial or Consolidation Application can have its own Rate Application.

Multi-National Organizations with business units spread across geographical locations around the globe have the necessity of Data translation from Local Currencies to Reporting Currencies for Management and External Reporting purposes.

Each entity spread across the globe has its own Local Currency which is also the Reporting Currency for Internal Reporting purposes.

Business Objects Planning and Consolidation supports the Data Translation from Local Currency to multiple Reporting Currencies or Group Currencies.

Currency Translation process starts with the setting up of the necessary Dimensions and their Properties and Members. Configuring the required Dimensions and populating the Business Rule table with the necessary parameters to define the Currency Conversion process provides the Built-In Intelligence to perform Currency Translation.

Finance Application contains finance data. The finance data requires data translation from Local Currency to multiple Reporting Currencies. Finance Application has RATE Application as Reference Application.

Following Dimensions are considered mandatory for performing Currency Translation of Data in the Finance Application.

• Category - Category Dimension
• F_ACCT - Account Type Dimension
• F_ENTITY - Entity Type Dimension
• Time - Time Type Dimension
• RptCurrency - Currency Type Dimension

RATE Application stores the Exchange Rates associated with different currencies. Exchange Rates can be loaded to RATE Application using Data Manager Packages or can be manually maintained via Input Schedules.

Following Dimensions are considered mandatory in the RATE Application:

• Catergory - Category Type Dimension
• R_ACCT - Account Type Dimension
• R_Entity - Entity Type Dimension
• Time - Time Type Dimension
• InputCurrency - Currency Type Dimension

Configuring the Dimension involves setting up the properties and members of the Dimension which provide built-in intelligence for performing multi reporting currency conversion of data.

Category Dimension defines the type of data or the version of data in the system. Category and Time Dimensions are shared by both the Finance Application and the Rate Application.

Properties to be maintained for Category Dimension:

• CATEGORY_FOR_OPE
• FX_DIFFERENCE_ONLY
• FX_SOURCE_CATEGORY
• OPENING_PERIOD
• OPENING_YEAR
• RATE_CATEGORY
• RATE_PERIOD
• RATE_YEAR

• Hierarchies if present in the members of Dimension are validated.
• Member values maintained in the Property columns are updated to the backend BI system.
• Version of Dimension members are updated by invalidating the Server Cache.
• Formulas defined for Dimensions members are validated.

Multiple Dimensions can be selected for processing. The option "Process members from member sheet" can be unchecked if the members are already saved to server using the option "Save to Server" from the Action Pane after maintaining the Dimension members.

Time Dimension defines the unit of Time for the BPC Application. Time Dimension has a hierarchical structure which defines the aggregation of the units in the Dimension.

Each BPC Application can have only one Time Dimension. Time Dimension is mandatory in any BPC Application.

Appshell is delivered with a Time Dimension.

Properties:

• YEAR - Contains the year corresponding to Time Dimension ID.
• PERIOD - Contains the period corresponding to Time Dimension ID.
• TIMEID - TIMEID is an important property required for Currency translation process. System uses TIMEID property to lookup for Rates from Rate Application.
• MONTHNUM - This property takes the numerical value of the month.

Time Dimension members are maintained for in the Dimension member sheet. After maintaining the members choose "Process Dimension" from the Action Pane to reflect the updates made to the Time Dimension members into the BI system.

InputCurrency Dimension is a Currency Type Dimension. InputCurrency Dimension is a mandatory Dimension in the Rate Application.

InputCurrency Dimension is delivered with the Appshell.

InputCurrency Dimension has all the available currencies corresponding to entities as Dimension members. InputCurrency Dimension is a reference Dimension to Entity Dimension meaning the currency member of a particular entity should be a valid member of the InputCurrency Dimension.

The property MD of the InputCurrency Dimension indicates the relationship between each of the currency members and the base currency. It can take one of the two values M or D.

Maintain the value "Y" for the property 'Reporting' corresponding to the currencies USD and EUR which are used for Reporting.

Account Type Dimension is a mandatory Dimension in any BPC Application. Each Application can have only one Account Type Dimension

R_ACCT is the Account type Dimension of the RATE Application. R_ACCT Dimension is delivered with the Apshell.

The properties ID, EVDESCRIPTION, RATETYPE and ACCTYPE are required properties for any Account Type Dimensions.

Members of the Account Dimension have a hierarchical structure defined. RATETYPE property is a driving field controlling the Currency Conversion Business Rule to apply to a given account based on the value of the RATETYPE property of the particular account. The value of the RATETYPE property must be a valid member of the Account Dimension of RATE Application.

R_Entity is the Entity type Dimension of the RATE Application. R_Entity is delivered with the Appshell.

R_Entity Dimension is limited to one dummy member named GLOBAL.

Maintain members for the Entity Type Dimension. Members of the Currency property are the local currencies corresponding to each individual entity. These members should be valid ID's of the InputCurrency Dimension.

RptCurrency is mandatory Dimension in the Finance Application which holds the finance data that require translation to multiple Reporting Currencies.

Member 'Y' should be maintained for 'Reporting' property corresponding to the Reporting Currencies. The property 'Currency_Type' has a value 'R' for Reporting Currencies and a value 'L' for Local Currencies.

Finance Application is a Reporting Type Financial Application. Finance Application has the default RATE Application delivered with the Appshell as the Reference Application.

• Category - Category Type Dimension
• Time - Time Type Dimension
• F_ACCT - Account Type Dimension
• F_ENTITY - Entity Type Dimension
• RptCurrency - Currency Type Dimension

The Exchange Rates required for performing Currency Conversion on the Transaction Data of the Finance Application are maintained in the RATE Application which is a supporting Application. RATE application should always include a Currency Type Dimension to store the Exchange Rates associated with different currencies.

• Category - Category Type Dimension
• Time - Time Type Dimension
• R_Entity - Entity Type Dimension
• R_ACCT - Account Type Dimension
• InputCurrency - Currency Type Dimension.

When the Dimensions Category and F_ENTITY (Entity Type Dimension) are flagged as "Secured", "Authorization Objects" are created for these Dimensions. Read / Write / deny access is controlled for the "Secured" Dimensions in the Member Access Profile.

Securing the Entity Dimension allows the control of which User or Team has the read / write / deny access to which member (a particular entity in an organizational structure) of the Entity Dimension. Similarly securing the Category Dimension allows the control of which User or Team has read / write / deny access to which version of data within the Application.

Business Rule table has so many columns which are populated with the appropriate parameters to perform Currency Conversion.The first olumn Account Rate type is populated with the values from RATETYPE property of Account dimension which specifies the type of Exchange Rate to be applied for a particular account. Source Flow and Destination Flow columns are used to specify the movement type to post the converted values against. Destination account column is used to specify the target account to which the converted data should be posted. Apply to periodic option is checked in order to apply the Currency Conversion rule to data stored in YTD format.

• Script Logic File is an .LGF file. Upon the validation of the .LGF file, an .LGX file is created.
• .LGX file is an executable version of the .LGF file.
  System displays an information message upon the successful completion of the task. Click "OK"

DEFAULT.LGF is a Logic File used frequently in Business Objects Planning and Consolidation. The Logic Files included in the DEFAULT.LGF using "INCLUDE" statement or the logic directly included in DEFAULT.LGF are executed in real-time under three scenarios

• DEFAULT.LGF is executed via Data Manager Packages which provide the option to run the Default Logic file when Importing Data to an Application.
• DEFAULT.LGF is executed on every Write-Back to Application via Input Schedules.
• DEFAULT.LGF is executed when posting data to an Application through Journals.

Currency Conversion Business Rules Tables and Script logic files have been configured in the BPC Admin Interface. Currency translation of the Transaction Data of Finance Application can be performed in the BPC Excel Interface by executing the "FXTRANS.LGF" through the appropriate Data Manager Package.

Finance Application has both "Secured" and "Unsecured" Dimensions. All Users or Teams can access the members of the unsecured Dimension.

Member Access Profile are used to control which User or Team can perform a Read or Write operation on which region and version of Data within a BPC Application.

To grant read / write / deny access to the secured Dimension members of the newly created Application, highlight the profile FULL_MBR under the Member Access Profile.

Action Pane lists the Tasks associated with the Management of Member Access Profiles.

Member Access Profile should be modified to grant read/ write/ or deny access to the "Secured" Dimensions of the newly created Finance Application. After defining the Member Access Profile the Profile has to be assigned to Users or Teams.

Member Access Profiles have to be configured per Application Set. They determine the Application and Dimension members where an End User has Access rights to a region of data within the Application.

The Wizard helps to configure Member Access Profile to grant Access for Applications and Dimension members at Application Set through a series of steps.

Define the Access for the Category Dimension which is "Secured". Choose the Access and select the Dimension from the dropdown list which displays the "Secured" Dimensions of the Application.

Click the tab on the right hand side to open the Member Lookup for the Category Dimension.

From the Member Lookup of the Category Dimension, select the members of Dimensions to which access should be granted.

Here Read & Write access is granted for All Members which implies that the Member Access Profile grants Read & Write access to all versions of Data within the Application.

Users with this Member Access Profile can Read and Write the Actual, Plan and Forecast version of Data that resides in the Application.

This Member Access Profile lets Users or Teams to whom the Member Access Profile is assigned to perform Read & Write operations on all entities or regions of data within the Application.

If a specific entity member is chosen in the Member Lookup of the Entity Dimension, then Read and Write Access is granted for only that particular region of Data within the Application.

The third step in configuring the Member Access Profile is to select the Users or Teams and Assign the Member Access Profile to the chosen Users or Teams.

Here there is one user 'BPCUSERxxx' and one team 'Admin' Team. The Member Access Profile is assigned to 'BPCUSERxxx' in the domain.

Business Objects Planning and Consolidation is built around Microsoft Office tools such as Microsoft Word, Microsoft PowerPoint and Microsoft Excel.

BPC for Excel Interface is built on Microsoft Excel which offers an Intuitive Interface. Business Users primarily access BPC through the Excel Interface. Reporting and Data Management activities are performed in the Excel Interface.

Data Management and Reporting activities related to RATE Application are performed in the BPC for Excel Interface. To perform currency translation of the finance data to multiple reporting currencies, it is necessary to load the exchange rates associated with currencies of the entities present in the Finance Application.

Reports are used to retrieve and display the data from the database into an Excel Interface.Reports are used for the data retrieval and Analysis of the retrieved data.Multidimensional Analysis of the data can be performed by setting up the Dimension Members using Member Selector for Dimensions in the Current View of the Action Pane.

EvDRE function has two required parameters and one optional parameter.
EvDRE(AppName, Key Range, Expand Range)
AppName is the name of the Application from which to retrieve or send data.

EvDRE (Data Range Exchange) function is used to generate Reports and Input Schedules with Optimal Performance. By accepting cell ranges as parameters, EvDRE workbooks are faster to upload and download because there are no send or retrieve functions in the data cells.

EvDRE is bidirectional since EvDRE can be used to build Reports which retrieve Data from the database and can also be used to build Input Schedules to make Data entries into the Application in database.

EvDRE can be used to build Static Reports (without expansions) or Dynamic Reports (with expansions)

Reports can also be built using EvGET or EvGTS functions. These functions retrieve Data from the database. EvSEND function can be used to Send Data to the Database. If there is a Data Range of 5*4 (5 rows and 4 columns), EVDRE requires a single query whereas EvSND, EvGTS and EvGET functions require 20 queries (one query for each cell in the data range).

• EvDRE combines and extends the functionality of EvSEND and EvGET functions.
• EvDRE is fast and powerful.
• EvDRE provides greater Performance Enhancement with nested rows/columns.
• EvDRE = 1 Query. Passes Share Query Engine one query per cell based function
• Shared Query Engine (SQE) evaluates EvDRE as a single, range-based query whereas EvSEND, EvGET, EvGTS are evaluated as Multiple Queries.

EvDRE Builder is a query building tool that allows to quickly creating Reports and Input Schedules by selecting the necessary Dimensions in to the Rows and Columns along with report details.

Control Panel is divided into two parts

• Page Members & Formatting
• EVDRE Ranges and Expansion

EVDRE Expansion has several functions. One interesting feature of the EVDRE Expansion is the MemberSet.

MemberSet describes if a node, its sub-nodes, leaves shall be seen or only the leaves without sub-nodes in case of Dimensions with hierarchical structure and describes the members in case of a Dimension with a Flat structure.

Default Report created using EVDRE Builder has two expansions. One expansion in the Row using Time Dimension and another expansion in Column using Account Dimension and MemberSet is SELF, DEP.

Input Schedules are built to send Data to the database. Data entry to the database is performed via Input Schedules.

Data can be entered in cells only for base members of the Dimension. The values of the parent members are calculated automatically upon Data Input to the database.

MemberSet selections made in the Control Panel describe the Members of the Dimension to be displayed in the report or input schedule.

MemberSet is used to describe the node, its sub-nodes and leaves that can be seen or the leaves without the sub-nodes in case of Dimensions with hierarchical structure.

MemberSet selections:

• Member ID (hardcoded Member ID's with delimiter)
• Flag (keywords such as SELF, BAS, DEP, BASMEMBERS etc.)
• Filter (Filters based on Properties of Dimensions)

Asset Account members and Time members coming from the External system has a different format compared to the internal format of members of Account and Time Dimensions within BPC Application. Account 'BS00211' corresponds to 'AA00211' in BPC Account Dimension. Time '1010' corresponds to 'OCT.2010', which represents the internal format of Time Dimension member in BPC. Mapping of the External format of field members to internal format of Dimension members is performed in Conversion files.

BPC has an Account Based model with a single key figure. SignedData values represent the value associated with each Account.

Also, BPC is Case Sensitive. 'ACTUAL' and 'Actual' are considered as two different members. It is necessary to ensure that the Case of the field members of external file matches the Case of the Dimension members of BPC Application.

Headers of the Data file from the external system should be mapped to the Dimension names of the BPC Application in the *Mapping section of Transformation file.

If the Field names are same as the Dimension names of BPC Application, mapping is not needed.

Conversion Files define the mapping by Dimensions from external member names to internal member names within BPC. Conversion file can contain one or more sheets for different types of Transformation. Arithmetic operations and rounding of SignedData can also be performed on the input data in Conversion files.

Conversion File workbook is created automatically with columns "EXTERNAL","INTERNAL" and "FORMULA".

EXTERNAL - Format of the Dimension Member data coming from external systems.

INTERNAL - Format of the Dimension Member data within BPC.

Format of the external Dimension Member data from the source is mapped to the internal format of the Dimension Member data within BPC.

FORMULA - Formulas for the transactional Measures from the external systems.

Fixed list of members in external format can be mapped to internal format. In case of complex mapping, wildcards and formulas are used.

Conversion file can contain one or more worksheets for different types of transformations.

A conversion file is created for the Account Type Dimension, F_ACCT.

During the validation of the Conversion file, the system checks and ensures that the inputs from the external file are known to the system. After performing the check, the Conversion file is saved in the "CONVERSIONFILES" folder of the team "COMPANY".

ACCOUNT1.xls is a Conversion file maintained for Account type Dimension.

TIME1.xls is a Conversion file maintained for Time Dimension.

Rules necessary for the successful import of the master data or transaction data from the external source to Business Planning and Consolidation are setup in the Transformation files. Transformation files are Excel files with one worksheet.

Transformation file has three sections.

• OPTIONS
• MAPPING
• CONVERSION

Mapping section is a place to define the mappings of the field names of the flat file to the Dimension names of the BPC Application.

Conversion files associated with the Dimensions are listed in the CONVERSION section of the Transformation file.

Syntax to associate a Dimension with a conversion file Dimension Name = ConversionFilename.xls [! ConversionSheetname]

Currency Translation of the Finance Data into multiple reporting currencies is performed while loading Data into Finance Application on the entire Data without the option to choose a region of Data.

When "Import Transaction Data" package is run, it reads the Transformation file ( which has a pointer to Conversion file) and maps the data from external system to the internal format within Business Objects Planning and Consolidation.

Default logic includes a call to the FXTRANS.LGF which has the Script logic associated with the "Currency Conversion" to perform the Currency translation of the finance data.

SELF –Dimension Member from the Current view of Application.
DEP - Sub nodes or child Members of the Dimension Member in Current View.

SELF - The flag 'SELF' will fetch into Report the Dimension Member from the Current View.
LC, USD, EUR – Members of the RptCurrency Dimension is hardcoded directly in the MemberSet selection with 'comma' delimiter.
BASEMEMBERS - The keyword or flag 'BASEMEMBERS' will fetch into Report all the Base members of the F_ACCT Dimension.

Interactive Currency Conversion is performed using the "Currency Conversion" Data Manager package from the Financial Processes package group which prompts to choose the region/slice of data from an Application. Interactive Currency Conversion is performed on Demand Basis on Application Data that has been loaded already to an Application.

The "Currency Conversion" process executes "FXTRANS.LGF" advanced rule to perform the Currency Conversion of the 'Finance' Application data.

Detail log has a Package log and a Formula log.

Detail log has a Package log and a Formula log.

Action Buttons can be inserted in the Reports and SAP delivered Macros can be assigned to the button to perform a specific action on the click of the button. Enabling macros for the Action Buttons added to the Reports lets the users run the FXRestatement Package from within the Report on the imported Transaction data on demand.

Import Transaction Data to the BPC Application without running the Default Logic and using the option "Replace and Clear data values".

MNU_EDATA_SELECTPACKAGE is a menu command used to open a specific Data Manager package.

Syntax: MNU_EDATA_SELECTPACKAGE (< package name >,< package file path >,< team name >,< package group >)

MNU_ETOOLS_EXPAND expands all dynamic expansions and refreshes.

MNU_ETOOLS_MEMBERSELECTOR_E is a menu command which is used to open the Member Lookup for the Entity type Dimension. This macro when assigned to a Button lets open the Member Lookup for the Entity Dimension from within the Report on the click of the Button.

Business Objects Planning and Consolidation offers a set of predefined Dynamic Templates & Reports. The delivered templates can be customized by making changes in the Control Panel and saving them as Custom Templates locally or in BPC server. The template version should be updated via the Application Set task "Set template version" after making any change to the Templates.

Report Wizard Dynamic templates delivered for Reports in BPC. Each of Report template in the Report Template has a title, a legend, a bitmap icon and an xlt file for Report itself.

A library of dynamic Report and Input Schedule templates are stored on the BPC server. These templates are provided to reduce the initial setup time for building Reports & Input Schedules.

Drill Down option enables the drill down from Parent nodes to base members based on the hierarchical relation existing between the members of the Dimension.

Advanced Format section in built by defining a Format Range and using specific Format Commands which form Format Instruction.

Format Range is made up of six required columns.

• CRITERIA
• EVALUATE IN
• FORMAT
• USE
• PARAMETERS
• APPLY TO

Format Instructions are defined within the Format Range. A format Instruction is defined in a single row across six columns which form the required columns of the Format Range. Format Range is controlled by the Range set in the "Format Range" option of the Ranges in the Control Panel.

Multiple rows of Formatting Instructions are defined in the Format Range using multiple Format Instructions. EvDRE applies the Format Instructions to the Reports or Input Schedules generated in a sequence specified in the Format Range.